Access™ 2007 VBA Programmer's Reference
by Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein
Chapter 5. VBA Basics
Now that you know a bit about automating Access, using macros, and how VBA fits into the Access automation picture, you're almost ready to write some code. The next step is to review some VBA basics.
For experienced programmers, this chapter is unnecessary; however, if you're just delving into VBA from another programming language or from VBScript, this chapter contains vital information that will help you to better understand and utilize what you learn in subsequent chapters. Here you'll examine the basic VBA programming objects, learn about variables and how to declare them, and review some additional VBA structures that you'll use in your code. Along the way, you'll build a few procedures, and you will soon gain the skill and confidence to modify those procedures and to create your own.