How to hide MsgBox when I run update query?

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

Guest

I try to hide the automated pop-up that it displays for user to comfirms
after run to update (insert, or delete) query?
 
Use SetWarnings

DoCmd.SetWarnings False
'Run your action query
DoCmd.SetWarnings True
 
Or, better in my opinion,

CurrentDb.QueryDefs("NameOfActionQuery").Execute dbFailOnError

That has the advantage that you can trap for any errors that might be raised
during running the query.
 
In that the Execute method goes directly to Jet, rather than through Access,
is it safe to Assume the standard Access Action Query warnings would not
appear?
 
Yes, not having the Action Query warnings is the other advantage of using
the Execute method.
 
Just as I suspected.

Thanks

Douglas J Steele said:
Yes, not having the Action Query warnings is the other advantage of using
the Execute method.
Click to expand...
 
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

Query: Hide columns with VB/VBA 0
Re: Display Form or MsgBox while query is running 4
Query update fails 7
Record insert/delete anomaly 0
Windows Update 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Informing user of a process running using MsgBox 3

Back
Top