VBA Error Logging

AccessAdvisor.com has just published a timely article on The Value of VBA Error Logging. The article makes the point that any error handling scheme is incomplete unless it includes an error log, and provides some sample code.

My MS Access Add-In, 123 Error-Handler Wizard, can instantly add error-handling and error-logging to your Access databases:

1. The Wizard reviews your database and identifies all procedures without error-handling, and reports the On Error... statement for all other procedures.
   
2. You select which procedures to add error-handling to, or you can opt for global error-handling using a global error-handling procedure and an error-log table.
   
3. The Wizard adds error-handling to the selected procedures in one automated operation.