Charlotte Foust
cfoust at infostatsystems.com
Wed Mar 24 17:08:04 CST 2004
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