O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

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 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.

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