Alison Balter's Mastering Access 97 Development, Second Edition

Chapter 17. Handling Those Dreaded Runtime Errors

• Implementing Error Handling

• Working with Error Events

• Using On Error Statements

• Using Resume Statements

• Clearing an Error

• Examining the Cascading Error Effect

• Using the Err Object

• Raising an Error

• Using the Errors Collection

• Creating a Generic Error Handler

• Preventing Your Own Error Handling from Being Invoked

• Practical Examples: Incorporating Error Handling

Implementing Error Handling

Errors happen, even in the absence of programmer error. You need to protect your programs and your data from the adverse effects of errors by practicing error handling.

Error handling is also known as error trapping. Error handling is the process of intercepting Jet's or VBA's response to an error. It enables the developer to ...