Modules object (Access)

The Modules collection contains all open standard modules and class modules in a Microsoft Access database.

Remarks

All open modules are included in the Modules collection, whether they are uncompiled, compiled, or in break mode, or contain the code that's running.

To determine whether an individual Module object represents a standard module or a class module, check the Module object's Type property.

The Modules collection belongs to the Microsoft Access Application object.

Individual Module objects in the Modules collection are indexed beginning with zero.

Example

The following example illustrates how to use the Modules collection to loop through the open modules. The example prints the name of each open module in the Immediate window.

 
Sub PrintOpenModuleNames() 
 Dim i As Integer 
 Dim modOpenModules As Modules 
 
 Set modOpenModules = Application.Modules 
 
 For i = 0 To modOpenModules.Count - 1 
 
 Debug.Print modOpenModules(i).Name 
 
 Next 
End Sub

Properties

• Application
• Count
• Item
• Parent

See also

• Access Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.