Is it possible to import an Module's namespace into a form's code? (So I don't have to type module1.this() for example)

All you have to do is declare the sub or function as Public and it will be available to all forms and queries.

Public MyFunctionName(sSomeParameter as string) as String

or

Public MyFunctionName() as String

or

Public Sub MySubName()

The same applies to application-wide variables. You can create a Globals module with global variables. Below is an example of a Globals module:

Option Compare Database
Option Explicit
 
 
'********************
'* System Constants *
'********************
   
    Public Const sTitle As String = "Sales Inquiry Application" ' sMsgbox title.
 
'******************
'*   DEFINITIONS  *
'******************
 
    '********************
    '* sMsgBox - related *
    '********************
    Public sMsg As String
    Public iDgDef As Integer
    Public iUserResponse As Integer     ' Evaluated by vbYes, vbNo, etc.
    
    '******************
    '* Form - related *
    '******************
    Public bCloseFormFlag As Boolean    ' True will let the form close, False will block the closure
    Public sDataEntryMode As String     ' "ADD", "CHANGE", "DELETE"
    Public bIsFormDirty As Boolean
    Public sFormCaption As String
    Public sControlFileFormName As String
    Public sControlFileHeading As String
    
    '********************
    '* System Variables *
    '********************
    Public i As Long                    ' counter
    Public sReportTitle As String       ' for e-mailed reports
    Public sVersion As String
    

Select allOpen in new window

Thanks - I would have never guessed this