Running Multiple Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maureen227@cox.net - 27 Jul 2006 21:04 GMT

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

Thanks ahead
Maureen

Reply to this Message

Marshall Barton - 27 Jul 2006 23:46 GMT

>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

Signature

Marsh
MVP [MS Access]

Reply to this Message

maureen227@cox.net - 28 Jul 2006 08:55 GMT

> >I have 3 queries that need to run consecutively. What would be the
> >best process? A button click or macro?
[quoted text clipped - 14 lines]
> Marsh
> MVP [MS Access]

Marsh
Thank you so much this worked like magic.

Tera-bytes of Gratitude!
Maureen

Reply to this Message