Skip to content

Module: Form_Training Module and Session List

Type: Form
Lines of Code: 253
Source: ms_access_files\ruby\Forms\Frm Training Module and Session List.txt

Dependencies

Module Dependencies: - RecSet - Actdatabase

Tables Accessed: - Training - Job

Forms Referenced: - Frm

Procedures

UpdateList

Type: Public Sub
Lines: 31

Calls: Chr, UpdateList

AddModuleSession_Click

Type: Private Sub
Lines: 38

Calls: AddModuleSession_Click

ClearFilter_Click

Type: Private Sub
Lines: 5

Calls: ClearFilter_Click

CloseForm_Click

Type: Private Sub
Lines: 13

Calls: CloseForm_Click

Complexity Notes: - ⚠️ Contains GoTo statements

DisplayBy_AfterUpdate

Type: Private Sub
Lines: 3

Calls: DisplayBy_AfterUpdate

Form_Open

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

Calls: Form_Open

ModuleSessionList_DblClick

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

Calls: Fields, ModuleSessionList_DblClick, OpenRecordset

ModuleSessionList_KeyDown

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

Calls: ModuleSessionList_KeyDown, OpenRecordset

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

StrCriteria1_AfterUpdate

Type: Private Sub
Lines: 3

Calls: StrCriteria1_AfterUpdate