suppress error message in Access VB

M

MilesMike

I want to be able to overwrite tables using Access VB code without a message
box popping up each time asking the user to verify that that's what he/she
wants to do.
 
O

Ofer

Use the setwarnings
docmd.setWarnings False
......
The sql update
......
Docmd.setwarnings True

don't forget to set the warnings back to true.
 
Top