By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Set Warnings Off in a macro

P: 2
On previous versions of MSAccess you could run a macro and make the first step SetWarnings False so you did not get a message for every query the macro runs. In 2007 this command seems to have dissappeared.

I can do it if I convert the macro to vba code but surely you can still do it in a macro? Any ideas??

NB, the database is in a trusted location.
Nov 14 '08 #1
Share this Question
Share on Google+
4 Replies


RuralGuy
Expert 100+
P: 375
I have SetWarnings as a possible Action in my ac2007.
Nov 15 '08 #2

P: 2
Must be a security thing somewhere then??
Nov 18 '08 #3

RuralGuy
Expert 100+
P: 375
All I can find in Help is:
This action will not be allowed if the database is not trusted.
Maybe try setting the trusted location again.
Nov 19 '08 #4

RuralGuy
Expert 100+
P: 375
It also looks like Macro security is set separately per program. Use the Help system to show how to do it.
Nov 19 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.