Here is my question:
1.) I have a database (duh!!) which we use in our showroom for order entry. We then back up the db to CDRW and bring it to our wharehouse (weekly) to use for creating purchase orders, delivery tickets etc... The copy we use at the wharehouse only has one field that we change in the entire db. When i get the two copies together the showroom copy will have additional orders not in the wharehouse copy. I have some vba that checks in the wharehouse copy for orders that are marked 'complete' (the one field we modify) and then updates the showroom copy. (Lost yet?)
2.) I have a DOS batch file that after the above updating of the Showroom db renames the existing Wharehouse db as .bk1 and replaces the Wharehouse db with the Showroom db (thus becoming the Wharehouse db). (My head hurts!!)
Shocking as it may seem, this works great for our purposes.
But, what i would love to be able to do is incorporate step 1 above into the DOS batch file and thus update and replace the Wharehouse db in one easy step.
Now the real question... can i call the module that updates the 'Complete' field in the Showroom db from within the batch file.
Well at this point i would guess you are either laughing
or your head hurts like mine!
Thanks for taking the time to at least read this!
D'oh!!
1.) I have a database (duh!!) which we use in our showroom for order entry. We then back up the db to CDRW and bring it to our wharehouse (weekly) to use for creating purchase orders, delivery tickets etc... The copy we use at the wharehouse only has one field that we change in the entire db. When i get the two copies together the showroom copy will have additional orders not in the wharehouse copy. I have some vba that checks in the wharehouse copy for orders that are marked 'complete' (the one field we modify) and then updates the showroom copy. (Lost yet?)
2.) I have a DOS batch file that after the above updating of the Showroom db renames the existing Wharehouse db as .bk1 and replaces the Wharehouse db with the Showroom db (thus becoming the Wharehouse db). (My head hurts!!)
Shocking as it may seem, this works great for our purposes.
But, what i would love to be able to do is incorporate step 1 above into the DOS batch file and thus update and replace the Wharehouse db in one easy step.
Now the real question... can i call the module that updates the 'Complete' field in the Showroom db from within the batch file.
Well at this point i would guess you are either laughing
or your head hurts like mine!Thanks for taking the time to at least read this!
D'oh!!
