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
"Douglas J. Steele" wrote:
[Quoted Text] > 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> > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele> (no private e-mails, please) > > > "Tom" <Tom[ at ]discussions.microsoft.com> wrote in message > news:C1EAEFBA-BF21-4B18-8904-D379AE42D692[ at ]microsoft.com... > >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 > > > |