Warning messages and action queries

  • Thread starter Thread starter Stephen Glynn
  • Start date Start date
S

Stephen Glynn

Is there an easy way of turning these off in Access 2000?

It would be ideal if I could turn them off for specific action queries I
want to run when particular forms are opened or closed.

Steve
 
DoCmd.SetWarnings False
DoCmd.OpenQuery ...
DoCmd.SetWarnings True

Alternatively, you can use the Execute Method (of the Database object or
Connection object) to run your action queries. The Execute Method does not
give warnings.
 
Back
Top