Search results for query: *

Hi all, Is there any formula will help me with the following query? I'm aiming to punch in a date and have a "vlookup" type function return sales figures for that date, plus the next 6 days. Thanks in advance. B.M.

Hi all I had thought that using vlookup within a module would be fairly easy. I've got the code 'a = WorksheetFunction.VLookup("a", data, 2, False)', but I get an error message of "Unable to get the Vlookup property of the WorksheetFunction class. Am I missing something? Cheers B.M.

Hi all I have a database containing a list of members, and next of kin details. As you can imagine, most NoK share the address with the member. I've created a routine to copy the member's address details to the NoK subform, but can't dump the data. Does anyone have any idea how I can "copy"...

hi, I've "inherited" a database that's being used as part of a project, and have been asked to introduce a combo box listing all training delegates names, to prevent the mistyping of names we're currently experiencing. Easy, right? the catch is, the delegates names are in a non-relational...

Can someone recommend a best practice for validating the entries a user makes on a user form. The form I'm creating will contain dates and values. Is there a function similar to the worksheet function IsNumber() Thanks in advance B.M.

Hi all Is it possible to have an input mask accept the following format: Letter A or M, followed by 5 digits, followe by either a letter E, S or N. OK, I know the 5 digits is easy enough - it's the choice of letters I'm stuck on. Thanks in advance. Bm B.M.

Hi, I've created a new form detailing all details regarding our clients, and have used the wizard to insert a subform, which should display details of our training to them. The relationships between these two fields is configured via the ID field in Clients to the clients_id field in Training...

Hi all, sorry I've been absent for so long I've been asked to convert an old database into something a bit more relational. As part of the final step, I've added a new subform to display the related contents of a new table. The displaying of pre-entered data is fine. However, if I try to...

Hi, I'm redesigning my website based on a layout I found within a tutorial. The "template" is CSS based (the reason for change). Unfortunately FP02 is displaying the various elements of the page incorrectly within Editor mode - specifically my LEFT Div is smack in the middle of my CENTER...

Hi, I get an intermittant problem on my website, whereby all DRW do not display correctly after I've updated and uploaded my Access DB. There are several DRW's sourced from several DB's. I get the error message as follows for each DRW: Database Results Error...

Hi, I'm not sure if this is possible, but what I'd like to achieve is a top ten of each salesman for each product. I've got the basic report setup with the Products as the Group, with the top ten numbers against each rep. Is it possible to reset these numbers at every new group - currently they...

Hi, I'm sure this is simple for someone, but I can't get my head around it: I have a number of products that we sell, and I want my query to display actual units sold, and a percentage it's sales against all units sold. I can't get this answer within one query (but I can in two) Thanks in...

Hi, Is it at all possible to embed a font within a HTML page? Reason I ask is I have been asked to embed the company logo into a HTML page within a bespoke application - using graphics is not a possibility. Thanks B.M. B.M.

Hi, is it possible to display fields that match my criteria in bold/italics etc within a report? Regards BM B.M.

Hi, Is there a way of moving to the start of a line or paragraph in VBA? Failing that, anyway of determining your current character position within the current line? Thanks B.M.

Hi, Is there any way that I can display the results of a DRW randomly on each and every load.... So the first time someone sees a page they get A,B,C, and the next C,A,B? Thanks in advance. BM B.M.

Hi, I want to be able to create a drop down menu, from which users will select product a, and then be presented with the relevant page. Can someone give me an overview of how I would create this in FP2000 - eg, do I need a form? do I need a submit button? do I need code? Thanks in advance. B.M.

Hi I run a website for a sports club with 15 different age groups. I want to have an asp page that displays results/fixtures for each age group, and obviously 1 page is easier to manage than 15 pages! I guess I need to pass parameters to this page for the query, to tell the database which age...

Help ! My daughter tried to install a windows component, which kicked off the whole Windows 2000 installation process again. When I boot the PC now the second part of the install process starts, but when it tries installing "COM+" it hangs. Anyone know how I can fix or get around...

Hi Is it possible to export a selection of clipart from one PC to another? Cheers B.M.