VBA brush up 02: the Visual Basic Editor (VBE)

Technorati label: VBE, VBA

 

From: julitta korol, "access.2003.programming. By. example. With. VBA. xml. And. asp", by wordware Publishing, Inc. 2005, p12-p27

2. Alt + F11 can directly access VBE
4. To modify the properties of a Form Control in VBE, follow these steps:
1. First, select the module of the form to be viewed on Project explorer.
2. Click view object at the top of Project explorer.
3. Switch back to VBE. Then, the Property Window is filled with various attribute values of the form.
4. To view the properties of a control, you only need to select the control from the drop-down list below the title bar of the Property Window.
6. F4: Display Properties window; F7: display code window; F2: Display Object Browser
8. InputCodeIf the list of available attribute methods is not displayed, you can use one of the following three methods:
1. CTRL + J
2. Edit the list properties/methods icon on the toolbar.
3. Right-click list properties/methods
10. To display parameter information, you can use either of the following two methods:
1. CTRL + Shift + I
2. Edit the parameter info icon on the toolbar.
12. To list Constants
1. CTRL + Shift + J
2. Edit the list constants icon on the toolbar.
14. Quick info
1. CTRL + I
2. Click the quick info icon on the toolbar.
16. Object Browser usage
1. You can select a database name from the drop-down menu on the top left.
2. You can right-click the search result to specify "full match"
3. Object attribute methods can be arranged by group, right-click "group members"
4. For access9 objects (self-edited objects), you can double-click to view the Code. For VBA and access objects, you can click the question mark to view help.
5. The text in the code template can be dragged directly to the code window. The member name can be copied to the clipboard using the copy button.
6. The access library is a variety of control objects; the VBA library is a variety of common functions;
18. Immediate window
1. CTRL + G
2. F5 can run the current sub-process
3. Ask two questions at the same time :? 3 + 2 :? 12*8