[AccessD] VBE Error Handler - MZ_TOOLS

O'Connor, Patricia Patricia.O'Connor at DFA.STATE.NY.US
Thu Mar 25 08:53:07 CST 2004


Thanks Charlotte
Sounds pretty neat

Patti

> -----Original Message-----
> From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
> Sent: Wednesday, March 24, 2004 06:08 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] VBE Error Handler - MZ_TOOLS
> 
> 
> MZ-Tools doesn't have an error handler, it has a tool to insert error
> handling into your code.  It has a find that I couldn't live without
> because it shows alls hits in a tree view.  It has helpful tools like
> templates you can customize for not only your error handling 
> but also a
> wizard for inserting procedures, module headers, procedure headers,
> adding and removing line numbers in code, splitting and 
> combining lines,
> a Select Case wizard, and a bunch of other tools, including 
> one to clear
> the immediate window and to close all code windows.  It also 
> has a nifty
> Review Source Code utility that will show you a list of variables and
> procedures that aren't used in the project - and it's lots 
> cheaper than
> FMS tools.
> 
> Charlotte Foust 
> 
> -----Original Message-----
> From: O'Connor, Patricia [mailto:Patricia.O'Connor at DFA.STATE.NY.US] 
> Sent: Wednesday, March 24, 2004 1:54 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] VBE Error Handler - MZ_TOOLS
> 
> 
> 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
> > 
> -- 
> _______________________________________________
> 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