Skip to content

Module: Form_Company List

Type: Form
Lines of Code: 487
Source: ms_access_files\gia\Forms\Frm Company List.txt

Dependencies

Module Dependencies: - ProdRecSet - RubRecSet - ActDatabase - RecSet - TempRecSet - NewRecSet

Tables Accessed: - RubRecSet - Delivery - Temp - Entrepreneurs - End - RecSet - Rubric - Qry - Ctr - Purple

Forms Referenced: - Frm

Procedures

UpdateList

Type: Public Sub
Lines: 54

Calls: Column, UpdateList, Chr

Complexity Notes: - ⚠️ High branching (9 If statements)

ClearFilters_Click

Type: Private Sub
Lines: 17

Calls: ClearFilters_Click

CloseFOrm_Click

Type: Private Sub
Lines: 3

Calls: CloseFOrm_Click

CompanyList_AfterUpdate

Type: Private Sub
Lines: 8

Calls: Column, CompanyList_AfterUpdate

CompanyStatus_AfterUpdate

Type: Private Sub
Lines: 3

Calls: CompanyStatus_AfterUpdate

CriteriaCombo1_AfterUpdate

Type: Private Sub
Lines: 3

Calls: CriteriaCombo1_AfterUpdate

EnterPurplePanelResults_Click

Type: Private Sub
Lines: 77

Calls: Column, EnterPurplePanelResults_Click, OpenRecordset, Fields

Complexity Notes: - ⚠️ High branching (7 If statements)

Filter1_AfterUpdate

Type: Private Sub
Lines: 16

Calls: Filter1_AfterUpdate

Form_Open

Type: Private Sub
Lines: 14
Parameters: Cancel As Integer

Calls: Form_Open

MaintenanceFunction_Click

Type: Private Sub
Lines: 3

Calls: MaintenanceFunction_Click

PrintReport_Click

Type: Private Sub
Lines: 54

Calls: Column, OpenRecordset, Fields, PrintReport_Click

SchedulePurplePanel_Click

Type: Private Sub
Lines: 36

Calls: OpenRecordset, SchedulePurplePanel_Click, Fields

StrCriteria1_AfterUpdate

Type: Private Sub
Lines: 3

Calls: StrCriteria1_AfterUpdate

CalculatePanelistScore

Type: Private Function
Lines: 18
Parameters: PPID As Long
Returns: Long

Calls: CalculatePanelistScore, OpenRecordset, Fields

SummarisePurplePanelResults_Click

Type: Private Sub
Lines: 156

Calls: Column, Round, CalculatePanelistScore, OpenRecordset, SummarisePurplePanelResults_Click, Fields

Complexity Notes: - ⚠️ High branching (14 If statements) - ⚠️ Large procedure (156 lines)