automatically answer popup message

  • Thread starter Thread starter Joe E via AccessMonster.com
  • Start date Start date
J

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
 
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
 
Back
Top