Skip to content

Module: Form_Company List

Type: Form
Lines of Code: 318
Source: ms_access_files\amber\Forms\Frm Company List.txt

Dependencies

Module Dependencies: - RecSet - Actdatabase

Tables Accessed: - Entrepreneur - BookkeeperAssignedDeliveryLocations - Submissions - DatabaseUsers - Submission - Qry

Forms Referenced: - Frm

Procedures

UpdateList

Type: Public Sub
Lines: 98

Calls: Chr, UpdateList, OpenRecordset

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

AddPreIgnition_Click

Type: Private Sub
Lines: 7

Calls: AddPreIgnition_Click

AddSubmission_Click

Type: Private Sub
Lines: 7

Calls: AddSubmission_Click

ArchiveSubmissions_Click

Type: Private Sub
Lines: 7

Calls: ArchiveSubmissions_Click

Assigned_AfterUpdate

Type: Private Sub
Lines: 14

Calls: Assigned_AfterUpdate

ChangePassword_Click

Type: Private Sub
Lines: 3

Calls: ChangePassword_Click

ClearFilters_Click

Type: Private Sub
Lines: 17

Calls: WHERE, ClearFilters_Click

CloseForm_Click

Type: Private Sub
Lines: 3

Calls: CloseForm_Click

CompanyList_AfterUpdate

Type: Private Sub
Lines: 4

Calls: CompanyList_AfterUpdate

CompanyList_DblClick

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

Calls: CompanyList_DblClick

CriteriaCombo1_AfterUpdate

Type: Private Sub
Lines: 3

Calls: CriteriaCombo1_AfterUpdate

Filter1_AfterUpdate

Type: Private Sub
Lines: 20

Calls: WHERE, Filter1_AfterUpdate

Form_Open

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

Calls: Form_Open, OpenRecordset

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

ImportFunction_Click

Type: Private Sub
Lines: 3

Calls: ImportFunction_Click, ImportFinancials

MaintenanceFunction_Click

Type: Private Sub
Lines: 3

Calls: MaintenanceFunction_Click

PreIgnitionList_DblClick

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

Calls: PreIgnitionList_DblClick

PreIgnitionList_KeyDown

Type: Private Sub
Lines: 16
Parameters: KeyCode As Integer, Shift As Integer

Calls: PreIgnitionList_KeyDown

ReportMenu_Click

Type: Private Sub
Lines: 3

Calls: ReportMenu_Click

StrCriteria1_AfterUpdate

Type: Private Sub
Lines: 3

Calls: StrCriteria1_AfterUpdate

SubmissionList_DblClick

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

Calls: SubmissionList_DblClick

SubmissionList_KeyDown

Type: Private Sub
Lines: 21
Parameters: KeyCode As Integer, Shift As Integer

Calls: SubmissionList_KeyDown

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