Suppress error message, close on run time error

[mkb137]

Is there any way to, on any untrapped error such as a run time error,
suppress the usual message dialog and instead close the application
immediately?

I have an application being launched on a server and would rather have it
fail on error than hang with an open dialog.

Thanks.

 

[mkb137]

Will all errors result in the "on error" function being called? I thought
some were untrappable.

 

[Jim Burke in Novi]

It sounds like what you want is a 'global' error trapper that will catch any
error that isn't handled by an on error statement. While it's true that you
should capture all possible errors, this IS the real world. There's no simple
way to do that as far as I know, but there is some software out there that
will do that. Check out this link:

http://www.everythingaccess.com/simplyvba-global-error-handler.htm

NOt sure if it's exactly what you want, and there is a free version as well
as a purchased one - I've never looked ito it other than to check it out on
that site. Alex Dybenko, who's a regualr contributor here, posted about it a
while back. He links to it thru his site at http://accessblog.net/

 

[mkb137]

OK. Thanks for the info, both of you.