hide warning messages

  • Thread starter Thread starter Guest
  • Start date Start date
When running action query using code, you can set the warning to False

DoCmd.SetWarnings False
' run your query
DoCmd.SetWarnings True
=============================
Or
CurrentDb.Execute "QueryName" , dbFailOnError

=============================
If you want to set the warnings off when you delete or append directly to
the query or using code, then in the menu bar select

Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
selection)

But you have to remember that it will never prompt with the message event
when
you are using the queries directly
==============================
 

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

File Download - Security Warning 5
Strange warning message 1
Remove warning pop up choice 4
Queries have stopped displaying error messages 1
Suppressing warning messages from MakeTable query 2
Append Query 3
query field names changing to expr#: 8
Duplicate Security warnings 5

Back
Top