[AccessD] Error Code Generator

...ditto ...excellent tool :)

William Hindman

----- Original Message ----- 
From: "Heenan, Lambert" <Lambert.Heenan at aig.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, September 22, 2006 5:10 PM
Subject: Re: [AccessD] Error Code Generator


> Check out the error handler insertion function of the (FREE!) MZ Tools. I
> like it plenty.
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
> Sent: Friday, September 22, 2006 2:37 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Error Code Generator
>
>
> 'Twas I more or less.  You can go to www.DatabaseAdvisors.com to download 
> a
> VB error handler VbErrorHandler.exe generator that is based on my code but
> ported to VB by Seth Galitzer.  Having downloaded and installed this, a
> toolbar will be added to the VBA Editor IDE to allow you to insert error
> handlers into your code, either in the form you showed or in a select case
> form.
>
> The bottom line is that I never found an error handler insertion wizard 
> that
> I liked so I highly modified one I found.
>
> 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 Martin Reid
> Sent: Friday, September 22, 2006 1:19 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Error Code Generator
>
> I believe someone on the list created an error generator. I believe it 
> might
> be JC? Anyway I have been using it a lot for code examples and just to be
> politically correct want the owner to know. Example below
>
>
> Function CopytoWss()
> On Error GoTo Err_CopytoWss
>    DoCmd.SelectObject acTable, "Contacts"
>    DoCmd.RunCommand acCmdExportSharePointList
> Exit_CopytoWss:
> Exit Function
> Err_CopytoWss:
>        MsgBox Err.Description, , "Error in Function CopytoWss"
>        Resume Exit_CopytoWss
>    Resume 0    '.FOR TROUBLESHOOTING
> End Function
>
>
> Martin
>
> Martin WP Reid
> Training and Assessment Unit
> Riddle Hall
> Belfast
>
> tel: 02890 974477
>
>
>
> -- 
> 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