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
>