VBA Environment in MS Access: An Introduction

VBA Environment in MS Access

This MSAccess tutorial explains the VBA environment in Access (with screenshots and step-by-step instructions).

What is VBA?

This is what the VBA environment looks like in Microsoft Access:

image 116
VBA Environment in MS Access

VBA standards for Visual Basic for Applications and is the language embedded within your database in Access.

You use VBA whenever you do one of the following:

  1. Create a new function.
  2. Create a new subroutine.
  3. Define a global variable.
  4. Place code behind an event procedure such as the “On Click” event of a command button.
  5. Execute the RunCode action in a macro.

These are just some of the examples of when you might be running VBA code.