Error handling

[Guest_imported]

Hey, I made a function that that writes a given error number & desription to a log with the date and a whole bunch of other info. Now what I would like is this function to be called when an error occurs. My first though for doing so is to put the function call in each and every procedure of each module, but doing so is a very long job. So, is there a simpler way to refer all errors to this function? Something like a general error handling?

 

[Malchik]

hi,

unfortunatly there is no "general handling". But to help you cna go over the net and find MZTOOL2 its a free dll that install VERY useful tools in the IDE of VB. You can use it to "normilize" you code. You cna predifined the parameters of error handling and by using the menu of MZTOOLS2 put in all Sub and Function your error handling.

Mal'chik

 

[FancyPrairie]

Access 2000 has a built-in Add-in that will insert YOUR error handling code in one or all of you modules. It works very well.

 

[Guest_imported]

Thank you for the hints!
What add-in are you talking about FanciePrairie?

 

[Guest_imported]

First of all, my apologies to FancyPrairie for spelling it FanciePrairie . Sorry!

Malchik, I've been looking on all major search engine and on download.com for mztool2 but got nothing... Where can I get it? Thank you again.

 

[Malchik]

hi Eairal,

Here is the site :

http://www.mztools.com/

Mal'chik

 

[FancyPrairie]

Sorry, didn't realize that the following add-ins were part of the Microsoft Access Developer Tools: (VBA Code Librarian, VBA String Editor, VBA Error Handler, VBA Code Commenter).

However, you could create a text file (using NotePad) that contains your error handling code. When you want to add your error handling code to one of your modules, simply open the module and insert the text file via INSERT|FILE via the menu bar.