Module: Form_Edit Financial Data

Type: Form
Lines of Code: 556
Source: ms_access_files\amber\Forms\Frm Edit Financial Data.txt

Dependencies

Module Dependencies: - RecSet - TempRecSet - Actdatabase - MonRecSet

Tables Accessed: - Submissions - Qry - Entrepreneur - SomethingChanged

Forms Referenced: - Frm

Procedures

CheckTheYTDFigures

Type: Public Sub
Lines: 136

Calls: Fields, OpenRecordset, WHERE, CheckTheYTDFigures, Column

Complexity Notes: - ⚠️ High branching (19 If statements) - ⚠️ Large procedure (136 lines)

SaveTheChanges

Type: Public Sub
Lines: 118

Calls: WriteFinancialHistoryRecord, SaveTheChanges, OpenRecordset, Fields

Complexity Notes: - ⚠️ High branching (20 If statements) - ⚠️ Large procedure (118 lines)

CloseForm_Click

Type: Private Sub
Lines: 24

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

Date_Proof_of_Employment_Collected_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Date_Proof_of_Employment_Collected_AfterUpdate

Direct_Labour_Costs_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Direct_Labour_Costs_AfterUpdate

Directors_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Directors_AfterUpdate

EnterYTDFinancials_Click

Type: Private Sub
Lines: 51

Calls: EnterYTDFinancials_Click, OpenRecordset, Fields

Expenses_Salary_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Expenses_Salary_AfterUpdate

Form_Open

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

Calls: Fields, Column, Form_Open, DateValue, OpenRecordset

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: 20

Calls: Permanent_Staff_AfterUpdate, OpenRecordset, Fields

Salaries_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Salaries_AfterUpdate

SaveIt_Click

Type: Private Sub
Lines: 8

Calls: SaveIt_Click

Turnover_AfterUpdate

Type: Private Sub
Lines: 4

Calls: Turnover_AfterUpdate

YTD_Cost_of_Sales_AfterUpdate

Type: Private Sub
Lines: 4

Calls: YTD_Cost_of_Sales_AfterUpdate

YTD_Direct_Labour_Costs_AfterUpdate

Type: Private Sub
Lines: 4

Calls: YTD_Direct_Labour_Costs_AfterUpdate

YTD_Expenses_Salary_AfterUpdate

Type: Private Sub
Lines: 4

Calls: YTD_Expenses_Salary_AfterUpdate

YTD_Net_Asset_Value_AfterUpdate

Type: Private Sub
Lines: 4

Calls: YTD_Net_Asset_Value_AfterUpdate

YTD_Other_Income_AfterUpdate

Type: Private Sub
Lines: 4

Calls: YTD_Other_Income_AfterUpdate

YTD_Salaries_AfterUpdate

Type: Private Sub
Lines: 4

Calls: YTD_Salaries_AfterUpdate

YTD_Turnover_AfterUpdate

Type: Private Sub
Lines: 4

Calls: YTD_Turnover_AfterUpdate