Make table query dialogue boxes

B

bid19

I have a macro that runs a make table query. I want to prevent the message
box appearing that tells me I am about to overwrite data (I am aware of
this). This message box prevents the rest of the macro running until the ok
button is clicked in the message box. I s there any way of turning of these
message boxes.
 
M

Meindert Manshanden

I've found one way to eliminate a couple of the message boxes. You'll
still get some message boxes.
I've pasted (and cleaned) the SQL of the query in the macro option runSQL
then disabled the use of transaction.
 
S

schasteen

On a single machine you can go to tools,options and on the add/edit tab
unclick action querys from the confirm section. This will turn off all
notifications of action quearys on just the one machine, other users will
still get the dialogue boxes. I really do not use macros so I cannot tell
you how to turn this off for all users, but in code you would us
docmd.setwarnings (false) before running the queary and set this back to true
afterwards.
 
Top