supress warnings in ACCESS 2007

[mls via AccessMonster.com]

How can I do the following in Access 2007..
In Access 2003 we can supress the warnings by the following...
Tools > Options > Edit/Find (Tab) > Action Queries (remove the
selection)

My database works fine in 2003 but when I run in 2007 it shows the alert for
all my DoCmd.OpenQuery , DoCmd.RunSQL . I don't want to use DoCmd.SetWarnings
False\True as there are about 10 action queries.

Thanks

 

[Al Campagna]

mls,
I think you want the Office Button/Access Options/Advanced, and
uncheck the ActionQueries.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[mls via AccessMonster.com]

Thank you very much. That worked perfectly.

mls,
I think you want the Office Button/Access Options/Advanced, and
uncheck the ActionQueries.

How can I do the following in Access 2007..
In Access 2003 we can supress the warnings by the following...

[quoted text clipped - 8 lines]

Thanks