[AccessD] VBE Error Handler

Doug Murphy doug at murphyscreativity.com
Wed Mar 24 13:14:21 CST 2004


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






More information about the AccessD mailing list