Recent content by Sara Overton

I have a split db. The front end contains a number of forms with subforms. On my remote copy I can see the subform. However when I pass it over to the server I cannot see the subform from the server or on my machine. Can anyone help?

I have built a split database for my customers. These databases are then personalised and distributed via WiseInstallBuilder exe software. The problem I have is if the end user holds the backend d/b in a different location the linked files cannot find the db. Have you any ideas to automate...

Thanks very much. Obviously couldn't find it for looking!

I know this is probably a very simple question but suprise suprise the help and manuals don't obviously state it! Does anyone know the maximum number of fields allowed in a query? Thanks

Thankis alot. I'm going on holiday now so I'll be back in touch if I need anymore help in 2 weeks! Sara

Ken a) 102 107 etc Thanks

Thanks Axa Problem: I'm not sure where to put the code. I've tried putting against afterupdate on my serial number field rather than doing an input box for the time being. But when I try to call the procedure it doesn't work! Any ideas

Thanks alot for the quick response. Problem is the Serial number always changes per entry. So the code needs to look at the start and end Serial number and work out if the Serial Number input by the user falls into the incremental sum. ie Start 100 Increment 5 105 is valid and 137 is...

Hope you can help! I have a form which the users enters a serial number and a product code into separate input boxes. The product codes are held in a separate table with 3 fields -the start serial number, the end serial number, the increments they are counted in i.e. 3. I need the database to...

Hi I have a main table holidng my customers. Then another table with purchases. In this table multiple product can be entered and quantites for a customer. The product details are held in another table and details which product is in which product category. Exactly as Northwind. I need to...

Hi I have a main table holidng my customers. Then another table with purchases. In this table multiple product can be entered and quantites for a customer. The product details are held in another table and details which product is in which product category. Exactly as Northwind. I need to...

Thanks for the quick reponse. Unfortunatley that doesn't work either. The problem is it's showing the last date but if I filter off that Account Number it suddenly changes and shows me the first date!!! [This message has been edited by Sara Overton (edited 07-16-2001).]

I have a major problem. I have been running reports on a table to check the first date of a date field against records on their Account Number. When I put first in the query window it actually brings up the last entry date for that Account Number. Any ideas what I can do?

Oh dear that makes my life difficult. Thanks anyway.

I am trying to publish a report I have written into word. One of the fields is an OLE object which contains a bmp file. When I run the report it displays the bmp but when I publish it into word it doesn't. Is there any way of doing this as it is crucial I publish the report in word. Thanks alot