Anyone wanna help a newbie (1 Viewer)

[dreamz]

I have 6 Queries that i would like to Automate to run with a click of a button or 2 or 3.

The db needs 2 tables to run which i'll need to import.

Can anyone help me out. Tell me where i can begin or where i can find out more about this.

Thanks in advance


Rayan

 

[Rickster57]

query

Let's start with the 6 queries running in succession.
To do this on the On Click Event of a command button on a form have it run a macro called macro1.
When you set up this macro in design view start with Set warnings to No. Then choose Open Query and set it to the first query to run. Follow that with close and the name of the query. Do this for all six queries under one macro in the exact order you want them to run. The last step should be Set warnings to yes.

 

[dreamz]

thanks

i've created the macro to run all six queries in succession.

Also created a form with a button to run the macro.

was trying to create another button to upload the tables but kind of stuck now :/