Search results

Sorry but that is not an option. Database are all on one server. The are for different clients. ALL in MS access. I can move them to SQL server.

Hello, I have 10 databases . ALL identical and used for different vendors. All have same table structure ( invoice, price, etc , etc tables) I want to run a query where I type in the invoice number and it should query all the database and display the appropriate information that I need. Would...

Hello, I have 10 databases . ALL identical and used for different vendors. All have same table structure ( invoice, price, etc , etc tables) I want to run a query where I type in the invoice number and it should query all the database and display the appropriate information that I need. Would...

thanks for the reply. But not good in access. Do I need to create any tables etc regards

Hello have a table with the following: Destinations, sent date , return date date in the table looks like this London 11/12/04 11/14/04 London 15/12/04 18/12/04 Geneva 14/12/04 16/12/04 I need to calculate the average time it takes for destination to...

I will try that

Even a bigger problem I changed the ShipDate from Text to Date and it worked fine for dates like 11-19-2004 and 11-26-2004 but today 12-01-2004 showed up as 01-12-2004 Meaning month became date and date became month.

Have a table with 5 fields. four are filled. Now have a query that shows me the records that I want to see. Now also have a form based on that query . Again that query has only four fields. Need to put some code behind this text box so that when I enter stuff in it updates records in the main...

thanks it works. but I have another problem. We ship the bags using UPS, TNT and other couriers.Meaning we group all the bags going to one destination and ship them using one of the assinged couriers. for example we imported 5 GVA and 3 LON in the table and they were all assigned ShipNumbers...

Wayne, Thanks a million. And thanks to others too. Just 2 quick question if we import around 500 records a day , would the process get slow say perhaps after 6 months or a year. And would it help if I move the tables to an SQL server if it does get slow. Regards

attached as requested cheers

Did as you said. Now getting Error 13 .Some type mismatch and this line is highlighted rst!ShipNumber = Nz(DMax("[Code]", "Pouch", "[Code] = '" & varInput(0) & "'"), 0) + 1 Appreciate the help. Regards

I am clueless as far a programing is concerned.

Thanks a million for taking time and replying. I did as you said but was getting this error message and AS DAO.Database was being highlighted. Attached is the file. I used winrar and then zipped it. Regards

Thanks for the reply. Took a while to get it setup like you suggested. but what is happening is that When I first imported the stuff from temp table the Shipment numbers were all 1. Meaning that I had 5 ASB's in the temp table and they all got assigned ShipmentNumber 1 and also for the other...

No response to my earliar post. Perhaps not clear.I will try again. have a table with called Info with following fields Code Weight Date Sh[/B]ip # Now we get this text file fixed width with the following information Code Weight date This is generated by...

No response to my earliar post. Perhaps not clear.I will try again. have a table with called Info with following fields Code Weight Date Ship # Now we get this text file fixed width with the following information Code Weight date This is generated by...

Gat ya. Let me get back and see if we can change . thanks

Thanks David for you help earlier. Got it working. Still need more help. Now I have a table with the following fields. Dest Date Pakage Info PGVA 12-12-01 ABC RGVA 12-12-01 EFG PGVA 12-12-01 123 PGVA 12-12-01 154 RGVA 12-12-01 2123 PLIM...