SetWarnings macro command in Access 2010

Question

In Access 2010, while building a macro in design view, the SetWarnings action command is not available in the "Add New Action" drop-down menu.  I can import a macro from an earlier version of Access and copy/paste the SetWarnings into my new macro, but I can't simply select it while building a new macro.  Is there a different command in Access 2010 or am I missing something?

Answer 1

You need to click on the show all actions.

So, the option not been removed. (it should turn orange if you click on it). The show all actions allows all macros commands to be viewed (by default, you only see macro commands that can be run with low security and in a non trusted locations, so this is a way to filter and create applications + commands that will run in a lower security setting).

Once you click on that command, I seem to recall it will remember the setting.

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

Answer 2

Almost three years later you are still helping others with your post!  Thanks a bunch.

Answer 3

Thanks so much.  Amazing how easy things are in 2010 when you figure out where to look.

Answer 4

Thank you very much for your helpful advice.

Answer 5

That worked, thanks.  Silly.  Just switched from Office 2003 to 2010.  Big changes visually.  The "Trust Center" and security settings are killing me!  Thanks again for the help.