How to return the name of the current function/sub

[new2access123 via AccessMonster.com]

I am trying to put together the error handler for my app. I want to send the
name of the function/sub in which the error occurred to send my error log. I
have been looking for a function that returns the name of the current
function/sub but have not been able to find one. Does such a function exist?

 

[Allen Browne]

No: Access doesn't expose the procedure stack to you.

Here's what I personally for error handling:
http://allenbrowne.com/ser-23a.html

If you want a commercial solution:
http://www.everythingaccess.com/simplyvba-global-error-handler.htm

 

[new2access123 via AccessMonster.com]

Thanks for the links. The error handler i am designing is very much like
yours. Now I know how to do it in VBA.

No: Access doesn't expose the procedure stack to you.

Here's what I personally for error handling:
http://allenbrowne.com/ser-23a.html

If you want a commercial solution:
http://www.everythingaccess.com/simplyvba-global-error-handler.htm

I am trying to put together the error handler for my app. I want to send
the

[quoted text clipped - 3 lines]

function/sub but have not been able to find one. Does such a function
exist?

 

[Alex Dybenko]

Hi,
You can also consider using http://www.mztools.com to insert it

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com