Suppress Access Messagebox

  • Thread starter Thread starter Sanjay
  • Start date Start date
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
 
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
 
Back
Top