Reference to currently running function- subname

[John J.]

How can I get the current Object, Subroutine name, function name in VBA so
that I can make a generic error message that automatically shows the right
name?
Thanks.
JOhn

 

[Douglas J. Steele]

There's nothing built into Access that will return that information for you.
You need to set the values in each routine so that you can pass them to your
generic error handler.

MZ Tools, available for free at http://www.mztools.com/v3/mztools3.aspx, is
an add-in that, among other things, can automatically fill in that
information for you.

 

[John J.]

Great! Thanks. I found the option.

John

There's nothing built into Access that will return that information for
you. You need to set the values in each routine so that you can pass them
to your generic error handler.

MZ Tools, available for free at http://www.mztools.com/v3/mztools3.aspx,
is an add-in that, among other things, can automatically fill in that
information for you.