Running Multiple Queries

[maureen227]

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

Thanks ahead
Maureen

 

[Marshall Barton]

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

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

 

[maureen227]

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

Marsh
Thank you so much this worked like magic.

Tera-bytes of Gratitude!
Maureen