Running a query in a macro

[netcashin]

This is probably and easy answer but I haven't dealt much with Access macros.

I have created some queries saved in Access. I am wishing to run the queries from one macro. How to I call the queries in the macro.

thanks

 

[jebry]

Hi!

Use either the RunSQL action or the OpenQuery action.

hth
Jeff Bridgham

 

[netcashin]

Using the RunSQL option, how do I call the saved query?

 

[jebry]

Hi!

Well, you have two options. Go to your saved query and open the SQL view. Copy the SQL and then paste it into the appropriate box of the macro. Or you can use the OpenQuery action and just click on the dropdown arrow and choose the query you want to open.

hth
Jeff Bridgham

 

[tlbroadbent]

RunSQL doesn't run saved queries. It runs SQL code. Use the OpenQuery action to run a saved query from a macro. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.