get the current procedure name - Access 2000

[Tony Wilkinson]

Hi,

Does anyone know if it is possible to get the current procedure name
from any function or code please.

I have had many occassions to need this but have not been able to find
a way of doing it.

One example of the use I want to put it to is to create a generic
error message function that can be called by passing the calling
procedure to it such as below.

msgbox "There has been an error in " & <passed procedure name> & "."
If anyone knows how to do this or can tell me where to find out the
way to do it I would be most appreciative.

TIA

Tony Wilkinson

[Terry Kreft]

Get hold of the mztools addin (www.mztools.com ).

One of the things this does is allow you to enter Error Handling code to a
template you can define, one of the intrinsic variables it uses is the
procedure name

--
Terry Kreft
MVP Microsoft Access
"Tony Wilkinson" <so*****@home.com> wrote in message
news:bk********************************@4ax.com...

Hi,

Does anyone know if it is possible to get the current procedure name
from any function or code please.

I have had many occassions to need this but have not been able to find
a way of doing it.

One example of the use I want to put it to is to create a generic
error message function that can be called by passing the calling
procedure to it such as below.

msgbox "There has been an error in " & <passed procedure name> & "."
If anyone knows how to do this or can tell me where to find out the
way to do it I would be most appreciative.

TIA

Tony Wilkinson