Just run please!!!!

[Emmanuel]

Hi people,

Quick question, how do I create a macro that runs 13 queries without going thru the open query, run command/run, close query?


Let me further explain...

I have 13 update and make table queries. I need to run them in an specific order and the only way that I know is to write 3 line in the macro to run just one query and those lines are:

1-Open Query-With query name, View and data mode.
2-RunCommand- Run
3-Close-Object Type, Object Name and Save Mode


Is there any other way?

Please help.....

Best Regards,
Emmanuel

 

[antomack]

All you need to do is create the macro and enter the following lines

SetWarnings No
OpenQuery Query Name - YourQueryName, View - Datasheet, Data Mode - Edit
Repeat the OpenQuery for eahc query you require in the specific order you require
SetWarnings Yes

The SetWarnings is used to stop the display of the Access notifications telling you that you are about to append x rows, etc..

Then you just need to run your macro either manually or from a form.