By pass prompts on Macros running several make tables queries

  • Thread starter Thread starter limousin
  • Start date Start date
L

limousin

Bonjour!
I think there is a way (option of something) to prevent MS Access to send
prompts confirming deletion or updates and other messages while running
macros/queries.
I'm running about 15 make tables queries in a macro but it defeats the
purpose of automation if I still have to be there and click ok on each query
request.

Does anybody know?
Thanks
~~Marie
 
Bonjour Marie.

Put a SetWarnings/No action in your macro before the first OpenQuery action.
 
Back
Top