A reader wants to know if there’s a tool that sets up code for error handling.
Q:Stephen Young writes to ask whether there is a tool for Access that sets up the code for error handling in a function or sub.
A:There is no built-in tool for this purpose in either Access 97 or Access 2000, but in Access 97 you can get Colin Hill’s very useful Access Basic Builders shareware add-in (available from http://www.colhill.demon.co.uk/). This add-in includes a Code Library, which can be used (among other purposes) to store standard error-trapping code to paste into your procedures. For Access 2000, if you have the Microsoft Office Developer (MOD) edition of Office 2000, you can use its Code Librarian for a similar purpose, or the VBA Error Handler tool, which inserts error-trapping routines automatically, though it isn’t as customizable as I would like.
