Do NOT display Error Messages

[JHB]

I have a situation where I am getting a 440 error during a process,
but the process does what its supposed to do, and as far as I can see
the error has no effect on the functionality. I am unable to find the
reason for the error, and for the moment would like to suppress it,
since it disrupts the process flow.

The question is, what commands do i use to turn off the error display
and, later in the macro, turn it on again?

Thanks

John Baker

 

[Tom Wickerath]

Hi John,

Error 440 is an Automation Error. Have you single-stepped through your macro
to determine which action is attracting this error? If so, please provide the
action, along with any arguments.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________