action queries and macro execution

  • Thread starter Thread starter ganderson
  • Start date Start date
G

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.
 
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
 
Back
Top