warnings help

[Tom]

I have a macro that runs an update query in access 2007
when I execute the macro I get a warning that I am about to run an update
query that will modify the data in my table
I used to be able in 2003 to set warnings off I believe was what I did to
prevent these from showing. Is there a way to stop this from showing in
2007? I just want the macro to run

Thanks
Tom

 

[Douglas J. Steele]

AFAIK, SetWarnings is still an action in Access 2007. I can't remember,
though, whether you need to specific Show All Actions, as Jeff Conrad
explains in http://accessjunkie.com/faq_02.aspx

 

[BeckyC]

Go to the Create Macro part of the ribbon and click on SHOW ALL ACTIONS and
then SETWARNINGS will appear as an option in the drop down list for actions.
Put it first in your macro to turn them off. Also make sure the MS ACCESS
Options (advanced tab) Confirm is unchecked.

ALso make sure the