Confirm message dispaly

G

Gina

You need to a DoCmd.SetWarnings False before and a
DoCmd.SetWarnings True after the query. I am assuming you
are using a button or soemthing to run this query...

DoCmd.SetWarnings False
DoCmd.RunQuery "QueryName"
DoCmd.SetWarnings True

Hope that helps...
 

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

Word macro that can call cells out of Excel for a find and replace 0
docmd.setwarning false and true 6
update code vba (sql server 2000 and access 2003) 10
FollowHyperlink warning 1
delete warning 9
How to avoid double entry of Data 8
Runtime Error 6 Overflow 1
First Effort Using VBA Code on ComboBox 3

Top