Search results

Thank you for your assistance, it was very informative. I would like to ask a couple more questions and then should be well on my way. I have attached a copy of the database in question to help explain. The problem I have now is that it displays the same value numerous times in the next combo...

I have read through the forums and followed the data but cannot seem to make a simple daisychain. I have a single table (bcone) with 13 fields (job, customer, description, etc.). I simply want to allow a user to enter data in the first combo box (Job) using the drop down or typing in the data...

I have resolved the problem. I used a batch file to open the database, run the internal macro and then close the database. "C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE" c:\WR1.mdb /x IIM Thanks for the help.

I have everything pretty much in order less one final item. Hate to admit it but I am out of my experience zone here but this is what I have: I have a macro called IIM that reads the .CSV file and imports it to the table. I have tried to use a VBS for this but have been unsuccessful. I...

I should have clarified, my apologies. If allow the file to be overwritten, the three units will overwrite each others data in the CSV file. They all sync at different times throughout the day and do it multiple times. For example if unit 1 syncs at 9am and then unit 2 at 11am, unit 2's data...

I have three devices which will upload data to a single CSV file each day. I have a database (Access 2003) to track and sort the data once it performs a transfer text macro from the CSV file to the database main table. I would like to purge the original data automatically from the CSV file...

Well that was embarrassingly simple. I don't think I have seen that in any of the other posts on here, but the screen may have gone blurry after a lengthy search... That is my story and I am sticking to it. Thank you very much for your help.

My apologies as I am no VBA programmer. I am simply trying to add a report number to a header on a report. The report number should sequentially change each time the report is generated. I have followed about two days worth of effort based on the other submissions on this website and have...