Skip to content

Module: Form_Add and Edit Company Programme Year

Type: Form
Lines of Code: 151
Source: ms_access_files\garnet\Forms\Frm Add and Edit Company Programme Year.txt

Dependencies

Module Dependencies: - Actdatabase - RecSet

Tables Accessed: - Entrepreneur - RecSet

Forms Referenced: - Frm

Procedures

AddPrincipalProject_Click

Type: Private Sub
Lines: 13

Calls: AddPrincipalProject_Click

CloseFOrm_Click

Type: Private Sub
Lines: 14

Calls: CloseFOrm_Click

Complexity Notes: - ⚠️ Contains GoTo statements

Contract_Start_Date_AfterUpdate

Type: Private Sub
Lines: 5

Calls: Contract_Start_Date_AfterUpdate, DateAdd, Column

EditProgrammeYearStatus_Click

Type: Private Sub
Lines: 3

Calls: EditProgrammeYearStatus_Click

Form_BeforeInsert

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

Calls: Form_BeforeInsert

Form_Close

Type: Private Sub
Lines: 8

Calls: IsLoaded, Form_Close

Form_Open

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

Calls: Form_Open

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

Programme_Year_AfterUpdate

Type: Private Sub
Lines: 19

Calls: OpenRecordset, Programme_Year_AfterUpdate

Complexity Notes: - ⚠️ Uses SendKeys

Total_Programme_Amount_AfterUpdate

Type: Private Sub
Lines: 19

Calls: Fields, OpenRecordset, Total_Programme_Amount_AfterUpdate