Can query messages be suppressed ro turned off

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm still pretty new at Access but it appears that whenever I execute a SQL
command, Access displays a message telling you what is about to occur. For
example, if I'm executing an INSERT query, Access display a message
indicating it's about to insert xx rows. Is there a way to turn off these
types of messages?

Thanks,
Rich
 
Hello,

I'm still pretty new at Access but it appears that whenever I execute a SQL
command, Access displays a message telling you what is about to occur. For
example, if I'm executing an INSERT query, Access display a message
indicating it's about to insert xx rows. Is there a way to turn off these
types of messages?

Thanks,
Rich
Click to expand...

DoCmd.SetWarnings False
DoCmd.RunSQL "Insert into ......."
DoCmd.SetWarnings True

A better way might be to use the Execute method.
No need to turn off the Warnings.

CurrentDb.Execute "Insert Into ...", dbFailOnError
 
Back
Top