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
>