[AccessD] VBE Error Handler - MZ_TOOLS

O'Connor, Patricia Patricia.O'Connor at DFA.STATE.NY.US
Wed Mar 24 15:53:36 CST 2004


Does MZ_TOOL's error handler - handle connection errors or just regular
access errors?
I know I could download the tool - but would rather know if it was worth it
beforehand. Besides the error handler is there other things in this tool
that make it worthwhile

Thanks
Patti 

example 

  Dim cnn As New ADODB.Connection
  Dim objErr As ADODB.Error
  If cnn.Errors.Count > 0 Then
       For Each objErr In cnn.Errors
           Select Case objErr.NativeError
             Case 942
                  NoTable = True
                  Exit For
             Case Else
                strError = Error_Rtn(cnn.Errors)
                Exit For
          End Select
        Next

        cnn.Errors.Clear
        If NoTable Then
            Resume Next
        Else
            fExpFsMoYrTable = False
            Resume Exit_fExpFsMoYrTable
        End If
    End If

> -----Original Message-----
> From: Doug Murphy [mailto:doug at murphyscreativity.com]
> Sent: Wednesday, March 24, 2004 02:14 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] VBE Error Handler
> 
> 
> MZ Tools has a pretty nice error handler insertion feature.  
> The handler
> is customizable. Works in all versions of Access from 2000 on.
> 
> Doug
> 
> 
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> John W. Colby
> Sent: Wednesday, March 24, 2004 4:23 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] VBE Error Handler
> 
> 
> >grmbl.
> 
> Yea, I understand.  Unfortunately I am not a VB kind of guy.  
> I "wrote"
> the original but it was in Access.  I don't event own VB (non .NET
> version anyway).
> 
> You might beg and plead with Drew Wutka.  He is very handy with VB and
> loves a challenge.  It would also give him a chance to get up to his
> elbows in my old code and moan about it.  I know Seth moaned a bit.
> 
> <grin>
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of S D
> Sent: Wednesday, March 24, 2004 1:33 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] VBE Error Handler
> 
> 
> grmbl.
> 
> A pitty. I think I'm going to try using you're error handler and some
> copy/paste/replace stuff...or copy it into a textfile and 
> write a litte
> prog to do the replacing.
> 
> Thanks anyway.
> 
> Sander
> 
> PS: A couple of weeks back I saw my first MS-Access 2.0 app 
> from 1995 or
> so....oi, PS1 was not completely applicable but....although
> normalization was correct and it still works like a charm :-)
> 
> "John W. Colby" <jwcolby at colbyconsulting.com> wrote:
> LOL to the whole message!!! In particular the PS1: I feel for you, but
> with any luck it will generate prodigious revenue as you clean it up.
> 
> The error handler wizard is in VB and is under the care of Seth
> Galitzer. This sounds like a very custom mod which you would probably
> have to make.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of S D
> Sent: Tuesday, March 23, 2004 9:34 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] VBE Error Handler
> 
> 
> We use a VB function to create a standard message. We use this in all
> (500+) applications.
> 
> I don't won't to break the line of work.
> Problem is we enherited a HUGE Access app (250+ tables, 300+ forms,
> 7(!?!)
> modules)
> 
> So we've got the following line in all our error handling:
> Call GenErr("Switchdatabase.Form_Startscherm", "Form_Load")
> 
> TIA
> 
> Sander
> 
> PS1: according to the programmer of this beast:
> - 'normalization'? What's that, a snack?
> - a function is never used more then once
> - dim a, b, c as string creates 3 strings....
> - dim blnError as String
> blnError = "0"
> blnError = "1"
> blnError = "incorrect" aaahhhhrg.....
> 
> 
> "John W. Colby" wrote:
> In short, it is not "programmable".
> 
> The message the user gets is the native Access error plus the 
> function /
> module name. What did you have in mind?
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of S D
> Sent: Tuesday, March 23, 2004 8:20 AM
> To: accessd
> Subject: [AccessD] VBE Error Handler
> 
> 
> Hi group,
> 
> i downloaded the VBE Error Handler dll from 
> www.databaseadvisors written
> by John Colby. I really love this program....almost.
> 
> It works great however I want to change the message that the 
> user gets.
> Is that possible?
> 
> Thnx in advance.
> 
> Regards
> 
> Sander
> 
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> --
> _______________________________________________
> 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
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> --
> _______________________________________________
> 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
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> --
> _______________________________________________
> 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
> 



More information about the AccessD mailing list