Removing the append msgbox

J

Joel

how do you remove the msgbox when you append a record? I always want it to
append but i hate clicking on the "yes" everytime.
 
A

Arvin Meyer [MVP]

Joel said:
how do you remove the msgbox when you append a record? I always want it to
append but i hate clicking on the "yes" everytime.
Click to expand...

If you do it from a menu, the only way to turn it off is in Tools ...
Options ... Edit/Find tab, then uncheck "Action Queries". That's not too
good an idea because it will also shut off the warning for deletions. If you
are appending from code, use:

DoCmd.SetWarnings False
'Run the append query
DoCmd.SetWarnings True

Always turn them back on again for the same reason as using the menu driven
option.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top