"Setwarnings" option not available

[theintern]

I'm trying to supress those warning messages everyone else is annoyed with
too, but I don't have the "setwarnings" option in the pull down menu of the
"action" column in my macro. Help! I know there's some code you can use as
well (docmd.SetWarnings True), but i'm not sure where to put that.

Thanks
scott

 

[theintern]

Nevermind, i figured it out. just need to click "show all actions" in the
toolbar.

 

[Allen Browne]

Nevermind, i figured it out. just need to click "show all actions" in the
toolbar.

Yes, that's a trap in A2007.

BTW, since you found your way here, you might be ready to look at an
alternative approach:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html