Macro to Run Multiple Delete Queries

[Juliet]

Hi
I have an extension on this issue. I have many tables - unrelated - I have set up a delete query for all tables, and now want a simple macro to run all the delete queries. (preferably without Displayalerts). I just want a simple Access macro which can easily be updated should I delete or add tables going forward.
Thanks

 

[Juliet]

Hi
I have many tables - unrelated - I have set up a delete query for all tables, and now want a simple macro to run all the delete queries. (preferably without Displayalerts). I just want a simple Access macro which can easily be updated should I delete or add tables going forward.
Thanks

 

[Mike375]

Use the OpenQuery action.

For the first action line use SetWarnings No
Then the OpenQuery actions for each query
Then SetWarnings Yes

SetWarnings no turns off the normal Access warning boxes and bell ringing.

If you want the warning boxes/messages then just put the OpenQuery action lines in the macro.