SetWarnings Action in Access 2007 Macros

[Guest]

The Help says it is there, but it doesn't appear to be. Any help?

 

[Guest]

I'm not sure what you are trying to do. If you want to use the set warnings
you need to code it in on VBA.

In your event procedure you can use the following to shut off warnings:

DoCmd.SetWarnings False

I strongly recommend that at the end of your procedure you turn them back on
by:

DoCmd.SetWarnings True

I also make a very simple form with a command button that sets my warnings
back to true so if I made an error I can simply click the button to turn
warnings back on. I can not stress enough how important it is to turn
warnings back on. I know I have lost hours of work by not having the
warnings on.

hope this helps,
Robert

 

[susiedba]

I disagree.. don't turn it on dont turn it OFF unless you REALLY NEEED
TO

if every procedure turns it on and off then you're ****ed

do you ever nest functions / procedures, Robert?

Turn them off when you start a BATCH and turn them off on COMPLETION.

-Susie

 

[Jeff Conrad]

By default Access 2007 only displays macro actions that can work in untrusted environments. Click
the "Show All Actions" button in the Show/Hide group of the Macro Design contextual Ribbon tab in
order to see the full list of macro actions available (including SetWarnings).

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message: