Insert new procedure with built-in error handling

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phred Bear - 25 Jul 2005 23:59 GMT

Any body know of any downloads which will create the bare bones of a new
procedure in Access 2000 but which includes simple error handling. Like, for
example, when you insert an On-Click event from the properties form but with
user defined properties.

Reply to this Message

David C. Holley - 26 Jul 2005 00:35 GMT

No, however if you want simple error handing...create a new command
button on a form and have it do something (anything), then just copy the
EH code created by the wizard. (It'll be pretty obvious as to what the
code is.) From there its just a matter of changing the labels in the code.

On Error Goto cmdButton_onClick_Error

becomes

On Error Goto myFunction_Error

> Any body know of any downloads which will create the bare bones of a new
> procedure in Access 2000 but which includes simple error handling. Like, for
> example, when you insert an On-Click event from the properties form but with
> user defined properties.
>
>

Reply to this Message

Dirk Goldgar - 26 Jul 2005 01:57 GMT

> Any body know of any downloads which will create the bare bones of a
> new procedure in Access 2000 but which includes simple error
> handling. Like, for example, when you insert an On-Click event from
> the properties form but with user defined properties.

I think MZ-Tools may have, if not exactly what you want, at least
something very like it:

http://www.mztools.com/v3/features.htm.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Phred Bear - 26 Jul 2005 15:33 GMT

<< I think MZ-Tools may have, if not exactly what you want, at least
something very like it:

http://www.mztools.com/v3/features.htm.>>

That's exactly what I want. It works fine. Many thanks for that.

Ian Millward
Edinburgh

Reply to this Message