SeadnaS
Programmer
- May 30, 2011
- 214
Hi folks,
I have a large Access 2003 database with a lot of forms and I am implementing an error logging system based on a code module i found online. The module checks all of the forms subs/functions to see if there is error handling and if there is none it inserts error handling code into them. The error handling code I wrote calls another module which logs the error to a table in the database.
The problem is that there are so many subs in the project that already have error handling. I need to delete the error handling from these so that I can implement the new error handling code instead.
I could do it manually but there is so much code here it would be an unbearable long and tedious task. I need either an Add-in or some code to run in the immediate window to go in and find the error handling code of each sub and delete it or replace it with my error handling.
If anyone could provide some help it would be much appreciated.
Regards,
SeadnaS.
I have a large Access 2003 database with a lot of forms and I am implementing an error logging system based on a code module i found online. The module checks all of the forms subs/functions to see if there is error handling and if there is none it inserts error handling code into them. The error handling code I wrote calls another module which logs the error to a table in the database.
The problem is that there are so many subs in the project that already have error handling. I need to delete the error handling from these so that I can implement the new error handling code instead.
I could do it manually but there is so much code here it would be an unbearable long and tedious task. I need either an Add-in or some code to run in the immediate window to go in and find the error handling code of each sub and delete it or replace it with my error handling.
If anyone could provide some help it would be much appreciated.
Regards,
SeadnaS.