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, ObjectNameCreates an event procedure in a class module
DeleteLinesStartLine, CountDeletes lines from a module
FindTarget, StartLine, StartColumn, EndLine, EndColumn, WholeWord, MatchCase, PatternSearchFinds the specified text in a class module
InsertLinesLine, StringInserts a line or group of lines of code in a module
InsertTextTextInserts a string of text into a module
ReplaceLineLine, StringReplaces the specified line with a string value

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.139.81.58