Skip to content

Module: Mod Utilities

Type: Standard
Lines of Code: 177
Source: ms_access_files\gia\Modules\Mod Utilities.bas

Dependencies

Module Dependencies: - ProdRecSet - RecSet - ActDatabase

Tables Accessed: - Qry - End - Purple

Forms Referenced: - Frm

Procedures

UpdateDivision

Type: Public Sub
Lines: 30

Calls: UpdateDivision, OpenRecordset, Fields

TestIt

Type: Public Sub
Lines: 3

Calls: TestIt

GetXofY

Type: Public Function
Lines: 16
Parameters: f As Form

Calls: GetXofY

Complexity Notes: - ⚠️ Uses On Error Resume Next

IsLoaded

Type: Public Function
Lines: 13
Parameters: ByVal strFormName As String
Returns: Boolean

Calls: Forms, SysCmd, IsLoaded

StringsSameCase

Type: Public Function
Lines: 9
Parameters: x As String, y As String
Returns: Boolean

Calls: StringsSameCase

CheckForUpper

Type: Public Function
Lines: 13
Parameters: CheckString As String

Calls: CheckForUpper, Asc

CheckForSpecial

Type: Public Function
Lines: 20
Parameters: CheckString As String

Calls: CheckForSpecial, Asc

CheckForNumber

Type: Public Function
Lines: 13
Parameters: CheckString As String

Calls: Asc, CheckForNumber

DeleteImportErrorTables

Type: Public Sub
Lines: 11

Calls: DeleteImportErrorTables

ObjectCounts

Type: Public Sub
Lines: 18

Calls: ObjectCounts

OpenTheFile

Type: Public Sub
Lines: 5
Parameters: TheFileName As String

Calls: OpenTheFile