Skip to content

Module: Mod Utilities

Type: Standard
Lines of Code: 282
Source: ms_access_files\purple\Modules\Mod Utilities.bas

Dependencies

Module Dependencies: - HisRecSet - RecSet - CompRecSet - EPRecSet - Actdatabase - RecSetTwo

Tables Accessed: - CompRecSet - dashboard - Qry - End - Entrepreneur - Entrepreneurs

Forms Referenced: - Frm

Procedures

FrmProductListProductList_AfterUpdate

Type: Public Sub
Lines: 8

Calls: FrmProductListProductList_AfterUpdate, Column

AllocateSpecificEPs

Type: Public Sub
Lines: 85

Calls: Fields, OpenRecordset, AllocateSpecificEPs, Year

DeleteEntrepreneur

Type: Public Sub
Lines: 47
Parameters: EPID As Long

Calls: OpenRecordset, Fields, DeleteEntrepreneur

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: IsLoaded, Forms, SysCmd

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: CheckForNumber, Asc

DeleteImportErrorTables

Type: Public Sub
Lines: 11

Calls: DeleteImportErrorTables

ObjectCounts

Type: Public Sub
Lines: 18

Calls: ObjectCounts