eveCalypso
Programmer
Good Day All,
I have two questions. I want to check for any open Forms related to my application when the application exits, and close any if they are open. What is the best way to do this?
Secondly, I am doing quite extensive error handling of my own, but I would like to intercept standard DB (SQL 2000) errors like Duplicate Primary Key and Foreign Key Constraints when they happen and give the user a friendlier message. I have recently converted all my DB operations to be Stored Procedure driven. How can I catch these errors before Access displays the standard message and what would be the best way to handle this scenario??
ANY help or pointers to references would be appreciated.
Best Regards,
EvE
I have two questions. I want to check for any open Forms related to my application when the application exits, and close any if they are open. What is the best way to do this?
Secondly, I am doing quite extensive error handling of my own, but I would like to intercept standard DB (SQL 2000) errors like Duplicate Primary Key and Foreign Key Constraints when they happen and give the user a friendlier message. I have recently converted all my DB operations to be Stored Procedure driven. How can I catch these errors before Access displays the standard message and what would be the best way to handle this scenario??
ANY help or pointers to references would be appreciated.
Best Regards,
EvE
