VBA brush up 01: procedures and modules

Technorati label: Procedures modules

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

1. Related process:
1. Procedure is a collection of instructions.
2. There are three types of procedure: Sub, function, and property.
3. Property is used to assign values to the attributes of custom objects or obtain the attribute values.
2. Related modules
1. Module is a collection of procedures. The process in the same module cannot be duplicated.
2. The module consists of the Declaration section and Procedure Section.
3. There are two types of modules: standard module and class module.
4. There are two types of class modules: Custom class modules, as well as the form modules and report modules automatically generated by the system.
3. About form modules and events:
1. Each form can be considered as a Form class, and each control is an object referenced in its property object controls.
2. The event processing process written for the control can be automatically called by the system after the event is triggered.
3. Each control is also a control class object, and its event attributes define the events that it can respond.
4. There are two ways to specify the event process to be triggered when an event occurs for the event attribute: one is to directly specify the event process name in the attribute window; one is to directly write the event processing process in the form module (the system automatically provides a list of available event process names. Note: The event process name cannot be changed at will, it can only be pre-defined by the system. Otherwise, the event trigger mechanism cannot be changed .)
4. Others: You can use DEBUG | compile to compile the code.