SetWarnings action missing from drop down menu in macro window

[msmith8754]

Hi,

My Access 2007 doesn't have "SetWarnings" action listed in drop down menu whereas Access 2003 did. How do I activate this option? Do I have to do via Visual Basic programming? Basically, I want to prevent any messages from popping up while series of queries are being run.

Thank you.

 

[Norie]

You'll need to click Show All Actions in the Show/Hide section of the Macro design toolbar.

Handy that isn't it.

Spent about an hour trying to find it myself.

 

[msmith8754]

Thank you so much, Norie. I was seriously going crazy locating that. I love this forum.

 

[velohead]

I have to chuckle when I see my exact question posted 3 years earlier, by a different user.

I have not used access for many years now, (change of jobs), but I do now (another change of jobs).
So I should substitute Access 2013 for Access 2007 in the original post. Yes, in Access 2003 SetWarnings to No with an access macro was soooooo simple.

My hurdle at the moment is to run a macro (that runs multiple Make Table Queries and Append queries), but this comes with a huge amount of Warnings, Do I Want to Append Data ??? , yes that's why I'm running an Append query.


The Show All Actions does nothing to my drop down menu, it still has SetWarnings missing. I think it's because my *work* file on the *work* network is not a *trusted* file.
OK, next problem - it does not ask me if I want to make it a trusted file, unlike several excel files that I regularly open. I guess back to unhelpful MS web pages that hint at the answer. D'oh!

 

[xenou]

This used to be at:
File (tab) | Options | Trust Center | Trust Center Setting ... (Button) | Trusted Locations

Which allows you to make the location of the file trusted (if on a network you must first check the box to allow trusted locations on the network). I have never done this on a file basis - just for folders.

Note: although personally I'd be surprised if that was the problem.

 

[velohead]

Yes, that is the fix.
Now I have set a particular network drive as a trusted location. the SetWarnings now appears on my dropdown list.

Thank You Xenou.

 

[xenou]

Well, I guess you are trusted now. Great!