Module: Form_Marketing Campaign List

Type: Form
Lines of Code: 284
Source: ms_access_files\topaz\Forms\Frm Marketing Campaign List.txt

Dependencies

Module Dependencies: - Actdatabase - RecSet

Tables Accessed: - Marketing - Qry

Forms Referenced: - Frm

Procedures

UpdateList

Type: Public Sub
Lines: 69

Calls: Column, UpdateList, Chr, OpenRecordset

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

AddBudgetItem_Click

Type: Private Sub
Lines: 3

Calls: AddBudgetItem_Click

AddPrincipalProjectCampaign_Click

Type: Private Sub
Lines: 3

Calls: AddPrincipalProjectCampaign_Click

AddSubCampaign_Click

Type: Private Sub
Lines: 7

Calls: AddSubCampaign_Click

AddUnrelatedCampaign_Click

Type: Private Sub
Lines: 3

Calls: AddUnrelatedCampaign_Click

BudgetItemList_DblClick

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

Calls: BudgetItemList_DblClick

BudgetItemList_KeyDown

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

Calls: BudgetItemList_KeyDown

BudgetStatus_AfterUpdate

Type: Private Sub
Lines: 7

Calls: BudgetStatus_AfterUpdate

CampaignStatus_AfterUpdate

Type: Private Sub
Lines: 3

Calls: CampaignStatus_AfterUpdate

ClearFilters_Click

Type: Private Sub
Lines: 22

Calls: Selected, ClearFilters_Click

CloseFOrm_Click

Type: Private Sub
Lines: 3

Calls: CloseFOrm_Click

Filter1_AfterUpdate

Type: Private Sub
Lines: 9

Calls: Filter1_AfterUpdate

Form_Open

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

Calls: Form_Open, OpenRecordset

MaintenanceFunction_Click

Type: Private Sub
Lines: 3

Calls: MaintenanceFunction_Click

MarketingCampaignList_AfterUpdate

Type: Private Sub
Lines: 3

Calls: MarketingCampaignList_AfterUpdate

MarketingCampaignList_DblClick

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

Calls: Column, MarketingCampaignList_DblClick

MarketingCampaignList_KeyDown

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

Calls: MarketingCampaignList_KeyDown, Column, Fields, OpenRecordset

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

MarketingSubCampaignList_DblClick

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

Calls: MarketingSubCampaignList_DblClick

MarketingSubCampaignList_KeyDown

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

Calls: MarketingSubCampaignList_KeyDown

ReportMenu_Click

Type: Private Sub
Lines: 3

Calls: ReportMenu_Click

StrCriteria1_AfterUpdate

Type: Private Sub
Lines: 3

Calls: StrCriteria1_AfterUpdate