Access Setting SetWarnings globally

Is there a way to setwarnings globally within access VBA?
keschusterAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
do it in the
Tools > options > edit/find tab

in the Confirm box  make your selection

in vba

Application.SetOption ("confirm record changes"), 0
Application.SetOption ("confirm action queries"), 0
Application.SetOption ("confirm document deletions"), 0


change 0 to -1 to do the reverse
0
 
rockiroadsCommented:
tools/options and edit/find tab, look at the Confirm options
is that what u want?
if so then they can be set via vba
0
 
rockiroadsCommented:
okay, well I see cap has posted the vba code so I wont bother.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
keschusterAuthor Commented:
Tools > options > edit/find tab...  where is this?  In VB window?  I'm running Access 2007.
0
 
keschusterAuthor Commented:
I think I found it
confirm.png
0
 
rockiroadsCommented:
Thats the one, they are the same as A2003, just the menu display is different.
Always advisable to specify what version Access you are using in your question to get a better response.
0
 
Rey Obrero (Capricorn1)Commented:
it will help if you will include in your post what version of access you are using..


;-)
0
 
keschusterAuthor Commented:
Isn't everyone running A2007? ;-)
Thanks
0
 
Rey Obrero (Capricorn1)Commented:
i am running 2000,2003,2007 most of the time 2003
0
All Courses

From novice to tech pro — start learning today.