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.

Get Access™ 2007 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.