By pass prompts on Macros running several make tables queries

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
 
S

Steve Schapel

Bonjour Marie.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to bypass having to ok the prompts in Access Macros 5
Queries and Tables Flashing on screen when running a report 4
Make Table Query 2
Linked Tables vs Pass-Through Queries 2
How can I carry a variable across several queries? 2
Can I pass one parameter to two queries at the same time? 2
Automating a database table update 6
Running Make Table Queries in a Macro 2

Top