Running Multiple Queries

M

maureen227

I have 3 queries that need to run consecutively. What would be the
best process? A button click or macro?

Thanks ahead
Maureen
 
M

Marshall Barton

I have 3 queries that need to run consecutively. What would be the
best process? A button click or macro?
Click to expand...


If these are action queries, use VBA code behind a button or
whatever.

Dim db As DAO.Database
Set db = CurrentDb()

db.Execute "query1"
db.Execute "query2"
db.Execute "query3"

Set db = Nothing
 
M

maureen227

Marshall said:
If these are action queries, use VBA code behind a button or
whatever.

Dim db As DAO.Database
Set db = CurrentDb()

db.Execute "query1"
db.Execute "query2"
db.Execute "query3"

Set db = Nothing
Click to expand...

Marsh
Thank you so much this worked like magic.

Tera-bytes of Gratitude!
Maureen
 
Top