F. Scott Barker’s Microsoft Access 2002 Power Programming

Chapter 7. Handling Your Errors in Access with VBA

IN THIS CHAPTER

• Examining Access’s Runtime Error Handling 148

• Working with the Err and Error Objects 153

• Working with the ADO Errors Collection 157

• Creating User-Defined Errors 161

• Using Custom Error Logs to Track Errors 163

• Creating a Centralized Error-Handling Routine 171

• A Last Look at Error-Handling Issues 176

Although it’s not the most glamorous subject for a book, runtime error handling is one of the most important subjects when it comes to creating robust applications. Access has several commands that help you use error handling to trap all those bugs that either slip through when you’re debugging an application, or come about through no fault of yours but because of bad data or user error. Access’s ...