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