Microsoft® Access® 2010 VBA Programming Inside Out

Chapter 2. Understanding the VBA Language Structure

• VBA Language Settings

• Working with Constants and Variables

• Functions and Procedures

• Control Statements and Program Flow

The popularity of Microsoft VBA as a programming language comes from the simplicity and productivity that the language offers. You will easily pick up the general principles and syntax of VBA; the more complex part of programming is in understanding the use of the language to control how your code interacts with other objects, such as tables, queries, forms, and reports that make up your application.

With Microsoft Access/VBA, you can often solve a problem by using several different techniques. It is this flexibility that is so valuable when you have a difficult problem that you ...