[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