action queries and macro execution

[ganderson]

Each time i try to run an action query in a maco, a
prompt appears that asks a question that must be answered
before the macro will complete. How can i bypass these
prompts so the the macro runs from start to finish
without stopping to ask me a question.

 

[Steve Schapel]

Ganderson,

To suppress the display of the action query confirmation messages, put
a 'SetWarnings, No' action in the macro before the first query action
(whatever you're using presumably OpenQuery or RunSQL).

- Steve Schapel, Microsoft Access MVP