How do I run a query from a macro ?

[Phideaux]

I've got a group of queries that perform needed update functions when my DB is closed or behind a few button clicks. all of the queries work fine individually. The problem i'm having is finding how to trigger these queries from a macro. any help is needed. I can't find the command from a macro to run the queries. does any one know what is is? help please.
Thanks


Phideaux

The mind is the best toy.
Play with someone else's often

 

[jrbarnett]

Hi,

You can use OpenQuery to run a saved query, or RunSQL and copy and paste the query's SQL code in the design.

John

 

[MinusM]

In the macro design window Select OpenQuery for each query in the list, row by row

Best fo Luck