How automatically accpet messages

G

Guest

Hi. I have a macro that runs several queries. One inserts values into a
related table.

Well, when I run the macro it appears a message saying that I'm trying to
copy records that cannot be insert.

and user must to accept saying yes to continue.

How do I prevent that message to appear?

regards,
Marco
 
S

Steve Schapel

Marco,

Put a SetWarnings/No action in the macro before the first OpenQuery action.
 

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

Stop macro on error 2
How to put the condition in Macro ? 1
How to suppress make table warning 2
Turn_off confirm message"Table will be deleted" inside a Macro 2
Active X VB no longer works in Excel 2008 home & student? 1
How to split by the value of a field and copy to respectively exce 5
autoexec macro, dialog box pops up 14
Record insert/delete anomaly 0

Top