Am I missing a refence for the Tools=>Confirm for action query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to run my queries so I can have others use macros in order to run
the queries without being asked if they are sure about running the query.
This will just confuse the user of the macros. I unchecked the boxes in the
Tools =>Confirm=>Action Query, Record Changes, Document deletions. I ran the
query and it gave me the prompt box along with a Help box stating that if I
didn't want the prompt box, I could simply uncheck the confirm boxes
mentioned above.

Any help would be greatly appreciated.

Thank you,

Zack Andersen
 
hi,

at the start of your macro in the action column select Setwarnings and then
select warnings on as no..

at the end of your macro select Setwarnings as yes..

hope this helps
Lee-Anne
 

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

Confirm Table Deletion Box in Make Table Query 2
Turning off action query confirmation messages 1
Confirm action query runtime option 1
Confirm Action Query 2
Make Table Query Popups 9
Message displayed when running action query... 5
Turn off confirmations for action queries 2
Make-Table query simple question 1

Back
Top