Run a Query to Run a set of queries

[Ananth]

I have created a set of 10 queriies. they have run in the order (Qry1,
Qry,2... Qry10) to produce a final Database extract.

Is it possible to run a single VBA routine or a query to automate running
the queries in the same order.

I am a Managment Accountant & my VBA skills are rudimentary.

ANy help appreciated

 

[Allen Browne]

See:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

Essentially, the code will look like this:
dim db As DAO.Database
Set db = CurrentDb()
db.Execute qry1, dbFailOnError
db.Execute qry2, dbFailOnError
db.Execute qry3, dbFailOnError
...
Set db = Nothing

 

[rhall]

I have created a set of 10 queriies. they have run in the order (Qry1,
Qry,2... Qry10) to produce a final Database extract.

Is it possible to run a single VBA routine or a query to automate running
the queries in the same order.

I am a Managment Accountant & my VBA skills are rudimentary.

ANy help appreciated

I would think you could load them all into a macro- in whatever order
you choose. Running the macro will give you the desired result every
time.

 

[Ananth]

Thanks Rhall. It helped.

I would think you could load them all into a macro- in whatever order
you choose. Running the macro will give you the desired result every
time.