Run all queries in a group

  • Thread starter Thread starter CFitz
  • Start date Start date
C

CFitz

Is there any way to run all of the queries that are in a group? I could
always make a macro that runs each query but it'd be easier if there was just
one action. I have about 40 update queries that need to run.
 
Is there any way to run all of the queries that are in a group? I could
always make a macro that runs each query but it'd be easier if there was just
one action. I have about 40 update queries that need to run.
Click to expand...

Use code.
CurrentDb.Execute "QueryA", dbFailOnError
CurrentDb.Execute "QueryB", dbFailOnError
CurrentDb.Execute "QueryC", dbFailOnError
CurrentDb.Execute "QueryD", dbFailOnError
etc.

Or if you name each update query in sequential order, i.e.
"Query1","Query2","Query3", etc. you can loop through them quite
simply:

Dim strName as String
Dim intX as Integer
For intX = 1 to 41
strName = "Query" & intX
CurrentDb.Execute strName, dbFailOnError
Next intX
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Duplicates in Query 0
Parameter Query Won't Run 0
Append Query Issue 0
Run multiple append queries? 1
Query to display highest totals 1
Invalid Argument - Append Query 1
open and run access query in excel 1
Group By Desing View 4

Back
Top