I have an Inventory database that I manually update each week with .csv & .txt files.
Here is my current procedure:
-----------------------------
1) Run "delQryAppaoo" - This deletes the old data first.
2) Import "edidb.txt" using Import Spec "APPAOO EDIDB Import Specification"
3) Import into existing "tblMasterReferenceDatabase"
4) Run "qryUpdateDistIDAppaoo" - This updates the Distributor field to the value "APPAOO"
What I want to do is make this a One Click update. I would like to add a button to my master search form that says "Update" , which when clicked runs my query, uses my Import Spec & then runs my update query. Also, it would be nice to have a status message that all went ok!
Thanks in advance for your help!
Jerry
Here is my current procedure:
-----------------------------
1) Run "delQryAppaoo" - This deletes the old data first.
2) Import "edidb.txt" using Import Spec "APPAOO EDIDB Import Specification"
3) Import into existing "tblMasterReferenceDatabase"
4) Run "qryUpdateDistIDAppaoo" - This updates the Distributor field to the value "APPAOO"
What I want to do is make this a One Click update. I would like to add a button to my master search form that says "Update" , which when clicked runs my query, uses my Import Spec & then runs my update query. Also, it would be nice to have a status message that all went ok!
Thanks in advance for your help!
Jerry