Update query?????????/ continued............... 2 " a quicky "

[chrisgreen]

I can know update and append records from one table to another and I am running the code via vba.<br><br>DoCmd.Openquery &quot;query&quot;<br><br><br>How can I get rid of the warning messages that access throws up?&nbsp;&nbsp;It is anoying because when I run 3 query's there are 6 warning messages.<br><br>

 

[Akrogh]

<FONT FACE=monospace> docmd.setwarnings false<br><br>[...run queries etc...]<br><br>docmd.setwarnings true </font><br><br>(last line is to turn warnings back on again. If you don't do this, access wont warn you when you run Update, Append and Delete queries - even if you are running them manually)

 

[chrisgreen]

Cheers Akrogh