[AccessD] Module Name - UPDATED

John:

I used Colby's error handler to insert error traps in every module of my
distributable mde. But then modified it to call an error form:

DoCmd.OpenForm "frmErrorMessage ", , , , , , "Error: " & Err.Number & " - "
& Err.Description & vbCrLf & "In:
frmPartMaster.BOMUnitofMeasure_AfterUpdate"

Which contains the name of the offending module in every case.  The form has
a command button which causes an email with the error info to be sent to me.


I can send you that form off-line if you want it.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Friday, January 26, 2007 8: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

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.11/652 - Release Date: 1/25/2007
3:32 PM