[AccessD] Module Name - UPDATED

John Skolits askolits at ot.com
Fri Jan 26 10:56:58 CST 2007


Well, if Ken can't do it, then I won't try.

I have a wizard I wrote many years ago so all my code is covered. But there
is a lot of old code a customer had in their modules and I was looking for a
quick fix. 

Thanks for the explanation of the VBE.



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

John,

The EDITOR knows (which is what VBE is) but what it is really returning is
the name of the code panel that you are currently viewing.  That is entirely
different from the module that the currently executing function is contained
within, as determined at run time.  I add a constant at the top of each
module, then reference that.  My error handler wizard can insert these into
your error handler (built by my wizard) because it is iterating through the
modules and thus knows the module it is in.  Again though, that is the
EDITOR object at DESIGN TIME. 

AFAIK obtaining either the module name or the function name at RUN TIME is
not possible.  And I have tried!!!  As have Gurus way above me - Ken Getz
for example.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Friday, January 26, 2007 11:31 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list