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.

PropertyData TypeDescription
ApplicationApplication objectReturns the currently active Application object
CountOfDeclaration-LinesLongCount of the number of lines in the General Declarations section of a standard or class module
CountOfLinesLongCount of lines of code in a standard or class module
LinesStringContains the contents of a specified line or lines in a standard or class module
NameStringReturns the name of the standard or class module
ParentVariousUsually the Application object
ProcBodyLineLongContains the number of the line at which the body of the specified procedure begins
ProcCountLinesLongContains the number of lines in a specified procedure of a standard of class module
ProcOfLineStringContains the name of the procedure that contains the specified line in a standard or class module
ProcStartLineLongIdentifies the line at which a specified procedure begins in a standard or class module
TypeacModuleType (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.

MethodArgumentsDescription
AddFromFileFileNameAdds the contents of the text file to a module
AddFromStringStringAdds the contents of the string to a module
CreateEventProcEventName, 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.