From the course: Access: VBA

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Work in the Visual Basic Editor

Work in the Visual Basic Editor

From the course: Access: VBA

Start my 1-month free trial

Work in the Visual Basic Editor

“

- [Instructor] When you write or edit VBA code in Access, you'll do so using the Visual Basic Editor. The editor gives you all the tools you need to manage your code effectively. When you're in an Access database window, there are two ways to get to the Visual Basic Editor. The first is to go to the create tab on the ribbon, and click Visual Basic. Or as the tools tip shows, you can also press ALT+F11. That's the shortcut I'll use most of the time. So I'll go ahead and press ALT+F11, and we're in the Visual Basic Editor. When you open the Visual Basic Editor, you should see two panels over on the left. The first is the project explorer and that contains code, if any, for the current Access Database as well as any other Microsoft Office programs you might have open. And then below that there is the Properties panel. And that displays properties for anything that you might have open. That could be a code module, code associated with the form and so on. If you don't see the project…

Contents