Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automating my Query and Import Specs with a Single button.?

Status
Not open for further replies.

gbs01

MIS
Jun 2, 2003
73
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top