Add Commenting and Error Handling to all new procedures (1 Viewer)

[Kryst51]

Using code that I have found through searching, I have set up a general error handler for all of my code. Fortunately I wasn't so far into my programming as to have too many procedures to add it to... My question is, is there any way add a clock to add comments to, and the error handling text to every new procedure, so that when I start a new procedure those things are already there, and all I have to do is edit them.

I did find an add-in to do this on a different site, but it was for a previous version of access and didn't work with Access 2003. Any info would be helpful, even if just the right words to search on.

 

[pbaldy]

I use a free tool called MZ Tools:

http://www.mztools.com/index.aspx

It doesn't add them automatically, but a custom error handler is a right click away (as are header comments). I also use the code templates a lot.

 

[Kryst51]

Thanks! That works fantastically.

 

[pbaldy]

No problemo; for a lazy guy like me, that tool is a lifesaver. So is Smart Indenter, if you haven't heard of that one.