Search results

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

Yes, we have to put it in word so it's static. As entries could be made the next day but wouldn't relate to the previous month. They are processed last working day of every month.

Many thanks

I need to produce a report to push into Excel for manipulation. I have a table which allows duplicate entries of the Primary key. It also has a date field for the date of entry. I need to find only the first entry for each Primary key. Then I need to process a report grouped by week of new...

Because it is like a bank statement. And can be called upon at any time. There figures need to be static as the database is updated daily.

Has nobody get any ideas?