Does anyone have code or know of an add-in that will automatically add
error correction code to all existing subs and functions in much the same
way as the macro-to-code auto-tool (which supplied with Access95) can ?

Thanks Mark Brownlee

: Does anyone have code or know of an add-in that will automatically
: add error correction code to all existing subs and functions in much
: the same way as the macro-to-code auto-tool (which supplied with
: Access95) can ?
:.......................................................

Hi Mark,

"Total Access Code Tools" by FMS Inc has a nice feature that insert
error handling code into existing procedures which do not already have
one enabled.

You can also customise the code produced ... very neat !

For information call FMS at 703-356-4700, or see their web site at:

http://www.fmsinc.com

I would highly recommend any of the FMS Access add-ins.

-- Chris Bell --

:"Total Access Code Tools" by FMS Inc has a nice feature that insert
:error handling code into existing procedures which do not already
: have one enabled.
:..................................................

Sorry Mark ... I missed the point about Access 95 and CodeTools
currently only ships for Access 2.0

FMS are in the process of creating versions for Access 97 of most of
their Access 2 add-ins ... I am not sure whether CodeTools is one of
them.

If you have a compuserve account you may find something to get you
started in the MSACCESS forum libraries ... most of them work only on
new procedures and would require additional effort to handle existing
procedures.

-- Chris Bell --