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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

********************** Action Query Assistance **************** 8
action query message 1
turning off action queries 3
Is It Possible to Control Access Warning Pop-Up Message Boxes? 6
Warning box/option when running macros, but not default? 3
Hide Message in Action queries 7
Running Make Table Queries in a Macro 2
Access 2007 Runtime and Action Query Notices 6

Back
Top