[AccessD] Error Code Generator

John
 
Lot of code I am publishing uses this.Just wanted you to knwo. Figured it was you.
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of JWColby
Sent: Fri 22/09/2006 19:37
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 <http://www.databaseadvisors.com/>