Stuart McCall's Microsoft Access Pages - Modules

Home
Determine if Module exists in current Database

Public Function IsModule(ModuleName As String) As Boolean
    Dim mdl As Access.AccessObject
    
    For Each mdl In CurrentProject.AllModules
        If mdl.Name = ModuleName Then
            IsModule = True
            Exit For
        End If
    Next
End Function
Paste this Code into a standard module.

Usage:

Debug.Print IsModule("MyModule")
Home Contents