Application.VBE (Access)

You can use the VBE property to return a reference to the current VBE object and its related properties. The VBE property of the Application object represents the Microsoft Visual Basic for Applications editor.

After you establish a reference to the VBE object, you can access all the properties and methods of the object. You can set a reference to the VBE object by choosing References on the Tools menu while in module Design view. You can then set a reference to the Microsoft Visual Basic for Applications Extensibility 5.3 Object Library in the References dialog box by selecting the appropriate check box. Microsoft Access can set this reference for you if you use a Microsoft Visual Basic for Applications Extensibility 5.3 Object Library constant to set a VBE object's property or as an argument to a VBE object's method.

MsgBox "Number of References = " & VBE.ActiveVBProject _ 
 .References.Count