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.
Ofer - 15 Jul 2005 12:11 GMT
Use the setwarnings
docmd.setWarnings False
.....
The sql update
.....
Docmd.setwarnings True
don't forget to set the warnings back to true.
> 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.
MilesMike - 15 Jul 2005 12:23 GMT
That does it - thank you
> 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.