Chapter 12: Finding and Dealing with Errors

Overview

So far in this book, we've talked a lot about programming, code, recordsets, and so on - all the things that can make your applications great. However, one important concept is that of errors. You've probably encountered several already, and that's perfectly understandable. So what you need to know is how to stop those errors from occurring, and how to find the problems when they do occur.

One point to remember is that there is no such thing as bug-free software. We'd love to believe it's possible, but programs get more and more complex every year, and that means more people working on them and more lines of code. The law of averages dictates that there must be some errors somewhere. Humans are fallible, so their software probably is too, and that includes both beginners and seasoned professionals.

Therefore, in this chapter we are going to look at:

• How to prevent errors from occurring

• The different types of error that you might face

• How to handle those errors when they occur

• How to use the error events to control errors