How to catch in VBA an action query warning?

G

Guest

I am running an append query from VBA using DoCmd command. Sometimes I am
getting a message: “Microsoft Access can’t append all records in the append
query†(due, for example, to key violations) and no error is generated. I
want to be able to handle such situation through VBA. Is there way of doing
that?
Thanks.
 
G

Guest

I'm not sure if that what you are asking for, but if you want to remove the
message, then use this

Docmd.SetWarnings False
Docmd.OpenQuery "QueryName" ' or runsql
Docmd.SetWarnings True
 

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

Remove warning pop up choice 4
Access 2002 Append Query Problems 1
Strange warning message 1
Access 2007 Append Query – Issue with automatically inserted brack 3
Access Can't Append Message 3
append query 1
Append Query 1
How do I avoid key violations in append queries 7

Top