[AccessD] Module Name - UPDATED

Actually, I found I could get the module name by using:

Application.VBE.ActiveCodePanel.CodeModule

So there must be a way to get the function.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bryan Carbonnell
Sent: Friday, January 26, 2007 11:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Module Name - UPDATED

On 1/26/07, John Skolits <askolits at ot.com> wrote:
>
> Actually I wanted the function name, not the module name. I know how to
get
> the module name.
>
> ----
>
> Anyway to retrieve the name of the module you're code is running in.
>
> I want to have an email sent to me in the error trap if there is a failure
> and want it to send me the name of the module. I could just type in the
name
> in a text string, but I want to use this in a bunch of modules and would
> rather have something generic like " CurrentModule.name"

AFAIK, no.

You have to hard code the function and module name into the error handler.

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com