Chapter 17. Writing Smarter Code

17. Writing Smarter Code

In Chapter 16, you dove headfirst into the world of Visual Basic code, writing routines that could show messages, respond to events, and modify forms. Along the way, you learned a fair bit about the Visual Basic language, and the object-based system that gives VB its mojo.

There's still more to explore. In this chapter, you'll learn how to use VB code to solve some of the most common problems Access experts face. You'll focus on improving the Boutique Fudge database, which you've worked with throughout this book. However, the solutions you'll use are so useful that you'll want to incorporate them into your own databases.

But first, before you tackle these more advanced examples, you'll start by brushing up on the Visual Basic language, learning how to defang errors, and taking a closer look at objects. These topics complete the Visual Basic picture, and prepare you to become a true Access programmer.