Business solutions Automating Microsoft

2. Getting Around in the Visual Basic Editor

IN THIS CHAPTER

Your First Glance at the Visual Basic Editor

Introducing the VBA Modules

Entering and Running VBA Code

Getting Help on Code

Establishing Good Habits in Coding

Your First Glance at the Visual Basic Editor

The Visual Basic Editor (VBE) is the interface you’ll use to write VBA code. Figure 2.1 shows the VBE window for the TimeTrack sample database. The easiest way to launch the VBE is to open Access, load the database, and then press Alt+F11. (If you’re following along with an existing database, the VBE may display some code when you first open it.)

Figure 2.1 Welcome to the Access Visual Basic Editor.

In this chapter, we’ll introduce you to the many components you’ll be working ...