Warning messages and action queries

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
 
V

Van T. Dinh

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.
 
Top