I am incredibly new to access and trying to learn as I go. I have set up a
few queries one of which is executed by a docmd.runsql in visual basic.
Because it is an update query it asks for confirmation every time it wants
to update the table. Is there any way to get around this

"Brandon Mackie" <awktane (AT) telus (DOT) net> wrote

Hello Brandon,

What you need to do in your code is to turn the
"Warning" off.

DoCmd.SetWarnings False

'Your code goes here.

DoCmd.SetWarnings True

Don't forget to ALWAYS turn the warnings back on or
there will be problems later on.

Regards,

Ray