By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Does anything like a "master error trap" exist in A97?

P: n/a
MLH
I'm thinking that maybe error trapping code could be
in a global module (standard procedure) and a Master
"OnError" statement could be set. Is anything like this
in use with VBA for A97?
Nov 13 '05 #1
Share this Question
Share on Google+
13 Replies


P: n/a
No.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CR**@NorthState.net> wrote in message
news:jj********************************@4ax.com...
I'm thinking that maybe error trapping code could be
in a global module (standard procedure) and a Master
"OnError" statement could be set. Is anything like this
in use with VBA for A97?

Nov 13 '05 #2

P: n/a
Error handling code can be in a general module. But you have to include
the On Error statement in every procedure that may some day cause a run
time error. In daily speak, that's every procedure.

Allen Browne wrote:
No.


--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

Nov 13 '05 #3

P: n/a
MLH
Too bad. Well, maybe it would be riddled
with difficulties.
xxxxxxxxxxxxxxxxxxxxxxxx
No.


Nov 13 '05 #4

P: n/a
MLH
Well now, that I can handle. Will have an experimental go at it.
Thanks.

ps... did you happen to see my recent post asking for some
guidance/suggestions integrating retail ms access 97 and runtime 97?
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx
Error handling code can be in a general module. But you have to include
the On Error statement in every procedure that may some day cause a run
time error. In daily speak, that's every procedure.


Nov 13 '05 #5

P: n/a
I spent some time writing an automated error handler insertion. But I
dare not give that away, it is far too buggy.

If you like to try anyway, you can mail me. Please note in my real mail
address the letter q does not occur; it should be a t

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

Nov 13 '05 #6

P: n/a
I purchased a book from Wrox publishing a year or two ago that came
with an add-in that automatically inserts error-handling into a module,
form, or all modules/class modules with the click of a button.

It works great. My only complaint is that you can't do much
customizing of the output it generates; that said, the error-handling
block it produces only requires slight modification for my personal
preferences. The book was Beginning Access 2002 VBA. Maybe look at
the Wrox website and see if they offer it for download???

-Johnny

Nov 13 '05 #7

P: n/a
"Bas Cost Budde" wrote
. . . But you have to include the On Error
statement in every procedure that may some
day cause a run time error. In daily speak,
that's every procedure.


However, if you consistently use a Code Library, almost all of them provide
for a "skeleton structure" for procedures which can include some basic error
handling. A commercial product of this kind is FMS, Inc.'s Total Visual Code
Tools for Access 2003, and other recent versions...
http://www.fmsinc.com/products. MVP Arvin Meyer has a free tool called
CodeWriter2 at his site, http://www.datastrat.com/DataStrat2.html, which I
have used for the same purpose.

Also, twice in my career, I have been called upon to write code to add basic
error handling to rather extensive databases, one was an Access 2.0 MDB and
the other was an Access 2000 ADP. It worked both times, with a lot less
manual "fixup" than I had anticipated. Both were complicated by the fact
that there is some error handling in code generated by Wizards -- that has
to be taken into account.

I couldn't post the code even if I had a copy, because it belongs to the
client in each case. They were interesting projects, separated by almost ten
years of time. I guess I should have made agreement with the first client to
retain rights and kept a copy of the code to use as a starting point, eh? As
the first client has discarded the Access 2.0 application, even they would
not have that code. There's probably no one there who even remembers that
kind of detail about the application, and maybe no one who remembers the
application at all.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #8

P: n/a
Bas Cost Budde <b.*********@heuvelqop.nl> wrote in
news:d9**********@localhost.localdomain:
I spent some time writing an automated error handler insertion.
But I dare not give that away, it is far too buggy.


Didn't writing that make you giggle? :)

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #9

P: n/a
Allen Browne wrote:
No.


And you say I'm succinct :-)

--
[OO=00=OO]
Nov 13 '05 #10

P: n/a
You would prefer a verbose proliferation of polysyllabic monstrosities,
diametrically opposed to the fundamental purpose of supplying an
intelligible and unencumbered response to the OP's salient issue? :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Trevor Best" <no****@besty.org.uk> wrote in message
news:42***********************@news.zen.co.uk...
Allen Browne wrote:
No.


And you say I'm succinct :-)

--
[OO=00=OO]

Nov 13 '05 #11

P: n/a
On Thu, 30 Jun 2005 15:38:19 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:
You would prefer a verbose proliferation of polysyllabic monstrosities,
diametrically opposed to the fundamental purpose of supplying an
intelligible and unencumbered response to the OP's salient issue? :-)


NO
Nov 13 '05 #12

P: n/a


Wayne Gillespie wrote:
On Thu, 30 Jun 2005 15:38:19 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:
You would prefer a verbose proliferation of polysyllabic monstrosities,
diametrically opposed to the fundamental purpose of supplying an
intelligible and unencumbered response to the OP's salient issue? :-)


NO


LOL. He forgot to use "sesquipedalian." :-)

James A. Fortune

Nov 13 '05 #13

P: n/a
Take a look at MZ Tools
http://www.mztools.com

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Bas Cost Budde" <b.*********@heuvelqop.nl> wrote in message
news:d9**********@localhost.localdomain...
I spent some time writing an automated error handler insertion. But I dare
not give that away, it is far too buggy.

If you like to try anyway, you can mail me. Please note in my real mail
address the letter q does not occur; it should be a t

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

Nov 13 '05 #14

This discussion thread is closed

Replies have been disabled for this discussion.