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