error checking and prompts

[Donna]

I am working on a project where Excel is calling Access to import data into
various tables using various routines. When testing all this directly
through Access, I get prompts about whether or not I want to save changes,
etc & I get error tables & messages telling me how many records were not
imported, etc. And this is all very good & I want this to continue.

However, as soon as we try running the project through command buttons on an
excel spreadsheet, Access quits prompting for saving changes, we have no idea
if the import is going well, etc.

Is this normal behavior or is there something we can do either in Excel or
Access to turn these features back on?

 

[Naresh Nichani MVP]

Hi:

On thing to check is the DoCmd.SetWarning - this should be False to make all
error messages appear. In your Excel code use the AccessApplicationObject to
reference the DoCmd object in Access.

AccessApplicationObject.Docmd.SetWarnings False

Regards,

Naresh Nichani
Microsoft Access MVP