Skip to content

Module: Mod Utilities

Type: Standard
Lines of Code: 220
Source: ms_access_files\emerald\Modules\Mod Utilities.bas

Dependencies

Module Dependencies: - Actdatabase - RecSet - SBRecSet

Tables Accessed: - RecSet - End

Forms Referenced: - Frm

Procedures

WriteProposalRevisionHistoryRecord

Type: Public Sub
Lines: 18
Parameters: PropID As Long, FldName As String

Calls: OpenRecordset, Fields, WriteProposalRevisionHistoryRecord

WriteRevisionHistoryRecord

Type: Public Sub
Lines: 18
Parameters: SalesBr As Long, FldName As String

Calls: WriteRevisionHistoryRecord, Fields, OpenRecordset

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

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

CheckForSpecial

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

Calls: Asc, CheckForSpecial

CheckForNumber

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

Calls: Asc, CheckForNumber

CalcWorkdays

Type: Public Function
Lines: 32
Parameters: StartDate, EndDate
Returns: Integer

Calls: CalcWorkdays, DateDiff

Complexity Notes: - ⚠️ Contains GoTo statements

ObjectCounts

Type: Public Sub
Lines: 18

Calls: ObjectCounts

UpdateMarketing

Type: Public Sub
Lines: 23

Calls: UpdateMarketing, Fields, OpenRecordset