Removing the append msgbox

[Guest]

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.

 

[Al Camp]

Joel,
Check out DoCmd.SetWarnings False. It will supress action query
messages.
Remember to always turn it back on (True) after your code has run.
-
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Arvin Meyer [MVP]]

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.

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