Skip to content

Module: Form_Principal List

Type: Form
Lines of Code: 157
Source: ms_access_files\emerald\Forms\Frm Principal List.txt

Dependencies

Module Dependencies: - Actdatabase - RecSet

Tables Accessed: - Principals - RecSet - this - Sales - Qry

Forms Referenced: - Frm

Procedures

UpdateList

Type: Public Sub
Lines: 22

Calls: Chr, UpdateList

AddPrincipal_Click

Type: Private Sub
Lines: 3

Calls: AddPrincipal_Click

AddPrincipaltoSalesBrief_Click

Type: Private Sub
Lines: 28

Calls: IsLoaded, Forms, AddPrincipaltoSalesBrief_Click, Column, OpenRecordset

Form_Open

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

Calls: Form_Open

CloseFOrm_Click

Type: Private Sub
Lines: 13

Calls: CloseFOrm_Click

Complexity Notes: - ⚠️ Contains GoTo statements

PrincipalList_AfterUpdate

Type: Private Sub
Lines: 4

Calls: PrincipalList_AfterUpdate

PrincipalList_DblClick

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

Calls: PrincipalList_DblClick

PrincipalList_KeyDown

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

Calls: WHERE, OpenRecordset, PrincipalList_KeyDown

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

SalesBriefList_KeyDown

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

Calls: WHERE, Fields, SalesBriefList_KeyDown, OpenRecordset

StrCriteria1_AfterUpdate

Type: Private Sub
Lines: 3

Calls: StrCriteria1_AfterUpdate