Access Turn Off Pop-Ups

In running a Macro in Access, please offer how I may turn off all the pop-ups that appear during Macro execution.

I have gone to the "Security" tab, but cannot find any choice to turn these off.

Thanks

tahirihAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I believe you mean the confirmation dialogs that you get when action queries are executed. With the database open, go to tools, options, and then client on the Edit/Find tab. uncheck all the boxes in the confirm group.
JimD.
0
 
therealmongooseCommented:
Use Setwarnings = false at the beginning of the macro
Make sure you include Setwarnings = true at the end!!
0
 
TonyStCommented:
Add the   DoCmd.SetWarnings=False  command before you fireoff the macro.
0
 
tahirihAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.