Module: Form_Sales Brief List

Type: Form
Lines of Code: 956
Source: ms_access_files\emerald\Forms\Frm Sales Brief List.txt

Dependencies

Module Dependencies: - Actdatabase - RecSet - NewRecSet - TmpRecSet

Tables Accessed: - Temp - End - RecSet - NewRecSet - DatabaseUsers - Sales - Qry

Forms Referenced: - Frm

Procedures

UpdateList

Type: Public Sub
Lines: 62

Calls: Chr, UpdateList, Column

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

CreateRevisedSalesBrief

Type: Public Sub
Lines: 679

Calls: Client, Database, Affidavit, Management, CreateRevisedSalesBrief, Campaign, Fields, Architect, OpenRecordset, Conference

Complexity Notes: - ⚠️ High branching (23 If statements) - ⚠️ Large procedure (679 lines)

AddSalesBrief_Click

Type: Private Sub
Lines: 4

Calls: AddSalesBrief_Click

ChangePassword_Click

Type: Private Sub
Lines: 3

Calls: ChangePassword_Click

ClearFilters_Click

Type: Private Sub
Lines: 22

Calls: ClearFilters_Click, Selected

CloseFOrm_Click

Type: Private Sub
Lines: 3

Calls: CloseFOrm_Click

CriteriaCombo1_AfterUpdate

Type: Private Sub
Lines: 3

Calls: CriteriaCombo1_AfterUpdate

Dashboards_AfterUpdate

Type: Private Sub
Lines: 15

Calls: Dashboards_AfterUpdate, IsLoaded

Filter1_AfterUpdate

Type: Private Sub
Lines: 19

Calls: Filter1_AfterUpdate

Form_Activate

Type: Private Sub
Lines: 3

Calls: Form_Activate

Form_Open

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

Calls: Form_Open

MaintenanceFunction_Click

Type: Private Sub
Lines: 3

Calls: MaintenanceFunction_Click

PrintSalesBrief_Click

Type: Private Sub
Lines: 5

Calls: PrintSalesBrief_Click

ReportMenu_Click

Type: Private Sub
Lines: 3

Calls: ReportMenu_Click

ReviseSalesBrief_Click

Type: Private Sub
Lines: 11

Calls: ReviseSalesBrief_Click, Column

SalesBriefList_DblClick

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

Calls: SalesBriefList_DblClick

SalesBriefList_KeyDown

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

Calls: Fields, SalesBriefList_KeyDown, Column, OpenRecordset

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

SalesBriefStatus_AfterUpdate

Type: Private Sub
Lines: 3

Calls: SalesBriefStatus_AfterUpdate

StrCriteria1_AfterUpdate

Type: Private Sub
Lines: 3

Calls: StrCriteria1_AfterUpdate