automatically answer popup message

[Joe E via AccessMonster.com]

Hello,

I have written a VBA macro to automatically import an XML file into Access
2003. The import works fine, but it gives me a pop-up error message that I
want to automatically close.

The message box that comes up says, "Not all of your data was successfully
imported. Error descriptions with associated row numbers of bad records can
be found in the Microsoft Office Access table 'ImportErrors'." It also has a
single "OK" button.

I want to program my macro to automatically click "OK" when this message pops
up. Does anyone know how to do this?

Thanks,
Joe

 

[Guest]

You can set the setwarnings to false before your macro starts, then it won't
even prompt when the error occurs, using a macro select setwarnings from the
action list and set the value below, or if you are using using vb:

docmd.setwarnings false