Module: Form_Edit Submission

Type: Form
Lines of Code: 340
Source: ms_access_files\amber\Forms\Frm Edit Submission.txt

Dependencies

Module Dependencies: - RecSet - TempRecSet - Actdatabase - HisRecSet

Tables Accessed: - End - Temp - Submission - Submissions - HisRecSet

Forms Referenced: - Frm

Procedures

SaveTheChanges

Type: Public Sub
Lines: 98

Calls: SaveTheChanges, OpenRecordset, Fields

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

Bookkeeper_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Bookkeeper_AfterUpdate

CloseForm_Click

Type: Private Sub
Lines: 22

Calls: CloseForm_Click

Complexity Notes: - ⚠️ Contains GoTo statements

Contract_Staff_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Contract_Staff_AfterUpdate

Cost_of_Sales_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Cost_of_Sales_AfterUpdate

Directors_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Directors_AfterUpdate

Expenses_No_Salary_AfterUpdate

Type: Private Sub
Lines: 8

Calls: Expenses_No_Salary_AfterUpdate

Expenses_Salary_AfterUpdate

Type: Private Sub
Lines: 8

Calls: Expenses_Salary_AfterUpdate

EditFinancialData_Click

Type: Private Sub
Lines: 3

Calls: EditFinancialData_Click

Form_Open

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

Calls: Fields, WHERE, Column, FormatPercent, Form_Open, DateValue, OpenRecordset

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

Net_Asset_Value_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Net_Asset_Value_AfterUpdate

Other_Income_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Other_Income_AfterUpdate

Permanent_Staff_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Permanent_Staff_AfterUpdate

QualityScore_AfterUpdate

Type: Private Sub
Lines: 4

Calls: QualityScore_AfterUpdate

Reviewed_by_Guide_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Reviewed_by_Guide_AfterUpdate

Salaries_AfterUpdate

Type: Private Sub
Lines: 13

Calls: Salaries_AfterUpdate

SaveIt_Click

Type: Private Sub
Lines: 8

Calls: SaveIt_Click

Submission_Month_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Submission_Month_AfterUpdate

Submission_Status_ID_AfterUpdate

Type: Private Sub
Lines: 18

Calls: Submission_Status_ID_AfterUpdate

Submission_Status_Notes_AfterUpdate

Type: Private Sub
Lines: 9

Calls: Submission_Status_Notes_AfterUpdate

Submission_Year_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Submission_Year_AfterUpdate

Turnover_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Turnover_AfterUpdate