Logo
Mail us
ben@accessdatabasetutorial.com
Home » Microsoft Access Database VBA » Microsoft Access Database: Access VBA Programming Environment

Microsoft Access Database: Access VBA Programming Environment

accessdatabasetutorial

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.
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
  
HelpF1
  
View Object BrowserF2
  
View properties/eventsF4
  
View Code windowF7
  
View Immediate windowCtrl+G
  
View shortcut menuShift+F10 (or right-click)
  
Run a Sub/UserFormF5
Stop code executionCtrl+Break
  
Close VBA Editor and return to AccessAlt+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)

microsoft access vba prgramming vbe