Suppress Access Messagebox

S

Sanjay

Hi
Is there a way to suppress Access's Message "You are
about to append one row to the records etc." while
running an append query from a form.
I am using Docmd.RunSQL object to run an INSERT statement
I already validate the user's intention and want to
suppress this message
Would appreciate any help

Thanks

Sanjay
 
G

Glenn

You can use the SetWarnings action to turn system messages
on or off. See vb help (enter Setwarnings).

DoCmd.setwarnings Off
DoCmd.RunSQL
DoCmd.setwarnings On

Glenn
 
Top