Microsoft Access Database: Access VBA Programming Environment

Microsoft Access Database: How to get to the Access VBA Programming Environment

All VBA code in your Microsoft Access VBA programming environment is managed in an area known as the Visual Basic Editor (VBE) and can be accessible via a form, report or quickly by using the Alt + F11 function key from the keyboard.

microsoft access vba prgramming vbe

This can only be viewed via its host (Microsoft Access) and is available to all modern versions of Access (since Access VBA programming was introduced).

Microsoft Access Database: General VBA Shortcut Keys

The following table shows you some helpful shortcut keys, and their functions, available throughout the VBE (Visual Basic editor), where you write, edit, and test your VBA code.

Action Shortcut Key
Switch between Access and the VBA editor Alt+F11
Help F1
View Object Browser F2
View properties/events F4
View Code window F7
View Immediate window Ctrl+G
View shortcut menu Shift+F10 (or right-click)
Run a Sub/UserForm F5
Stop code execution Ctrl+Break
Close VBA Editor and return to Access Alt+Q

Microsoft Access Database: Final Thoughts – Access VBA Programming

Unlike with Microsoft Excel (or Word), there is no macro recorder feature available and therefore some basic Access VBA programming commands and language reference will need to be mastered to edit code.

With the latest version of Microsoft Access (2010), any wizard feature used in a form for example, when adding a button now generates an embedded macro to the form and is not generated as  Access VBA. Earlier versions generated the VBA code for you.

Next page: Components of the VBE (Visual Basic Editor)

Leave a Reply

Your email address will not be published. Required fields are marked *