Skip to content

Form: Edit Financial Data

Caption: Edit Submission
Record Source: Unbound
Has Code Behind: Yes
Source: ms_access_files\amber\Forms\Frm Edit Financial Data.txt

Controls (87)

Control Name Type Control Source
MS Sans Serif CommandButton -
MS Sans Serif ToggleButton -
Submission Year TextBox -
Company Name Label Label -
Submission Month ComboBox -
Submission Month Label Label -
TopLabel TextBox -
Submission ID TextBox -
Turnover TextBox -
Label41 Label -
Cost of Sales TextBox -
Label42 Label -
Expenses No Salary TextBox =IIf(IsNull([Expenses Salary]),0,[Expenses Salary])-IIf(IsNull([Salaries]),0,[Sa
Label43 Label -
Other Income TextBox -
Label44 Label -
Salaries TextBox -
Label45 Label -
Net Asset Value TextBox -
Label46 Label -
Directors TextBox -
Label47 Label -
Permanent Staff TextBox -
Label48 Label -
Contract Staff TextBox -
Label49 Label -
Expenses Salary TextBox -
Label51 Label -
Gross Profit TextBox =IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of Sal
Label53 Label -
Net Profit Loss TextBox =(IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of Sa
Label55 Label -
Total Staff TextBox =IIf(IsNull([Directors]),0,[Directors])+IIf(IsNull([Permanent Staff]),0,[Permane
Label57 Label -
Direct Labour Costs TextBox -
Label62 Label -
Cost of Sales ex Direct Labour TextBox =IIf(IsNull([Cost of Sales]),0,[Cost of Sales])-IIf(IsNull([Direct Labour Costs]
Label64 Label -
Total Salaries Paid TextBox =IIf(IsNull([Direct Labour Costs]),0,[Direct Labour Costs])+IIf(IsNull([Salaries
Label66 Label -
Box67 Rectangle -
Box68 Rectangle -
Entrepreneur Company ID TextBox -
Line70 Line -
Line71 Line -
Line72 Line -
Line73 Line -
EnterYTDFinancials CommandButton -
Label75 Label -
YTD Label Label -
YTD Turnover TextBox -
YTD Turnover Label Label -
YTD Cost of Sales TextBox -
YTD Cost of Sales Label Label -
YTD Expenses No Salary TextBox =IIf(IsNull([YTD Expenses Salary]),0,[YTD Expenses Salary])-IIf(IsNull([YTD Sala
YTD Expenses No Salary Label Label -
YTD Other Income TextBox -
YTD Other Income Label Label -
YTD Salaries TextBox -
YTD Salaries Label Label -
YTD Net Asset Value TextBox -
YTD Net Asset Value Label Label -
YTD Expenses Salary TextBox -
YTD Expenses Salary Label Label -
YTD Gross Profit TextBox =IIf(IsNull([YTD Turnover]),0,[YTD Turnover])-IIf(IsNull([YTD Cost of Sales]),0,
YTD Gross Profit Label Label -
YTD Net Profit Loss TextBox =(IIf(IsNull([YTD Turnover]),0,[YTD Turnover])-IIf(IsNull([YTD Cost of Sales]),0
YTD Net Profit Loss Label Label -
YTD Direct Labour Costs TextBox -
YTD Direct Labour Costs Label Label -
YTD Cost of Sales ex Direct Labour TextBox =IIf(IsNull([YTD Cost of Sales]),0,[YTD Cost of Sales])-IIf(IsNull([YTD Direct L
YTD Cost of Sales ex Direct Labour Label Label -
YTD Total Salaries Paid TextBox =IIf(IsNull([YTD Direct Labour Costs]),0,[YTD Direct Labour Costs])+IIf(IsNull([
YTD Total Salaries Paid Label Label -
YTD Box 1 Rectangle -
YTD Box 2 Rectangle -
YTD Line 1 Line -
YTD Line 2 Line -
YTD Line 3 Line -
YTD Line 4 Line -
Issue YTD Does Not Match CheckBox -
Issue YTD Does Not Match Label Label -
Issue New Permanent Staff CheckBox -
Issue New Permanent Staff Label Label -
YTD Message Label Label -
CloseForm CommandButton -
SaveIt CommandButton -

Event Procedures

  • CloseForm_Click
  • Contract_Staff_AfterUpdate
  • Cost_of_Sales_AfterUpdate
  • Date_Proof_of_Employment_Collected_AfterUpdate
  • Direct_Labour_Costs_AfterUpdate
  • Directors_AfterUpdate
  • EnterYTDFinancials_Click
  • Expenses_Salary_AfterUpdate
  • Form_Open
  • Net_Asset_Value_AfterUpdate
  • Other_Income_AfterUpdate
  • Permanent_Staff_AfterUpdate
  • Salaries_AfterUpdate
  • SaveIt_Click
  • Turnover_AfterUpdate
  • YTD_Cost_of_Sales_AfterUpdate
  • YTD_Direct_Labour_Costs_AfterUpdate
  • YTD_Expenses_Salary_AfterUpdate
  • YTD_Net_Asset_Value_AfterUpdate
  • YTD_Other_Income_AfterUpdate
  • YTD_Salaries_AfterUpdate
  • YTD_Turnover_AfterUpdate