E.16. The Module Object
The Module object refers to either a standard module or a class module within your database.
E.16.1. Module Properties
The properties of the Module object are listed in the following table.
Property | Data Type | Description |
---|---|---|
Application | Application object | Returns the currently active Application object |
CountOfDeclaration-Lines | Long | Count of the number of lines in the General Declarations section of a standard or class module |
CountOfLines | Long | Count of lines of code in a standard or class module |
Lines | String | Contains the contents of a specified line or lines in a standard or class module |
Name | String | Returns the name of the standard or class module |
Parent | Various | Usually the Application object |
ProcBodyLine | Long | Contains the number of the line at which the body of the specified procedure begins |
ProcCountLines | Long | Contains the number of lines in a specified procedure of a standard of class module |
ProcOfLine | String | Contains the name of the procedure that contains the specified line in a standard or class module |
ProcStartLine | Long | Identifies the line at which a specified procedure begins in a standard or class module |
Type | acModuleType (acClassModule, acStandardModule) | Indicates whether a module is a standard or a class module |
E.16.2. Module Methods
The methods for the Module object are listed in the following table.
Method | Arguments | Description |
---|---|---|
AddFromFile | FileName | Adds the contents of the text file to a module |
AddFromString | String | Adds the contents of the string to a module |
CreateEventProc | EventName, ObjectName ... |
Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.