Suppress Access Messagebox

[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

 

[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