How to run a macro with auto confirm to "YES" option

K

Karen Middleton

I have a macro that calls a few access queries and before calling any
of the access queries it loads data from a .csv file.

But the annoying part of the macro is it asks for yes, no confirmation
in many places is it possible for me to ensure that the macro runs in
silent mode also is it possible for me to invoke the macro from
command line from DOS prompt.

Thanks
Karen
 
C

Chris Reveille

Use the SetWarnings action in the beginning of your macro
set it to NO
Chris
 

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

Turn_off confirm message"Table will be deleted" inside a Macro 2
Echo/Message display problem 2
Confirm action query runtime option 1
Turning off action query confirmation messages 1
Macro to run queries 1
Auto Confirmation after running update query 1
Set Display Control for a Table Yes/No Field 5
autoexec macro, dialog box pops up 15

Top