Access 2007 SetWarnings in MACRO

L

Lydia

I need to prevent the "make table" warnings from appearing when I run
a macro. Previous versions of Access had a SetWarnings action, which
allowed you to turn the warnings off. However, in 2007 SetWarnings is
not an option in the list of actions.

I DO have the file in a trusted folder.

Any suggestions?
 
K

KARL DEWEY

in 2007 SetWarnings is not an option in the list of actions.
They hid it! If they thought something could do you harm it was hidden.
On the icon bar in macro design view click on the 'Show all actions' icon.
 
Joined
Apr 8, 2010
Messages
1
Reaction score
0
On the icon bar in macro design view click on the 'Show all actions' icon

HA! THANK YOU!!! I spent hours trying to figure that out because I thought they'd replaced it with the "Output To" command. Then I noticed there were no commands after the S's and started searching for answers based on that. I really hate what they did with MS Access 2007. No added benefits, just scrambled things around. :-(
 
Joined
Mar 22, 2012
Messages
15
Reaction score
0
>>in 2007 SetWarnings is not an option in the list of actions.
They hid it! If they thought something could do you harm it was hidden.
On the icon bar in macro design view click on the 'Show all actions' icon.

aye. only had to click it a dozen times!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setwarnings in Access 2007 2
setwarnings - message suppression 1
SetWarnings 2
access 2007 setwarnings?? 1
SetWarnings 07 2
SetWarnings Action 1
Macro Action Disabled 2
Setwarnings in Access 2007 3

Top