[AccessD] Colby's Error Handler Builder

It would be much easier to just download the new VB6 version from our
website.  Register than, close then reopen the FE.  It is immediately
available as a toolbar IIRC.  You will need to first click the "setup"
button of the toolbar and select the options you want and then you can start
using it.


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 Bryan Carbonnell
Sent: Monday, October 22, 2007 9:13 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Colby's Error Handler Builder

On 10/21/07, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
wrote:
> John:
>
> I used your Error Handler to make error traps for all the modules in 
> E-Z-MRP. Worked really slick.
>
> I'm trying to do the same for another app and I thought I imported all 
> of the necessary stuff but I'm getting a compile error in the new app 
> C2DbErrHndlrBldr, module ccFillUsrProc, line:
>
> Case vbext_pk_Get
>
> The error is variable not defined.  I can't figure out what I'm 
> missing. Is it DIMmed in another module?  Or is it a constant my new app's
not seeing?
> E-Z-MRP compiles OK so I know the new app is missing something.
>
> Do you know what it might be?

You need to set a reference to Visual Basic for Application Extensibility
Library.

--
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