O'Reilly logo

Microsoft® Access VBA Programming for the Absolute Beginner by Michael Vine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 8DEBUGGING, INPUT VALIDATION, FILE PROCESSING, AND ERROR HANDLING

This chapter teaches you techniques for preventing runtime errors through input validation and error handling. You also see how to debug your VBA code using common VBE debugging windows. In addition, I show you how VBA manages file input and output (file I/O).

DEBUGGING

Sooner or later, all programmers seek the Holy Grail of debugging. The Holy Grail of debugging is different for each programming language. VBA programmers are very lucky in that the VBE provides a multitude of debugging facilities not found in many other programming environments.

As a programming instructor, I’ve often encouraged my Visual Basic students to use the VBE debugging facilities not only to debug ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required