having trouble causing macro to run append query, help 1

[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

 

[artcabot]

The command from the macros drop-down is OpenQuery.

Or, you could use "RunCode", then create a function that just lists all your queries as in:

Function CleanUp()

doCmd.OpenQuery "QueryName1"
doCmd.OpenQuery "QueryName2"

End Function

Then call the function as an argument to RunCode in the macro.