Form: Backdoor Frm Add and Edit Financial Data
Caption: Edit Submission
Record Source: Unbound
Has Code Behind: Yes
Source: ms_access_files\amber\Forms\Backdoor Frm Add and Edit Financial Data.txt
Controls (53)
| 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 Status ID | ComboBox | - |
| Process Status_Label | Label | - |
| 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 | - |
| Date Proof of Employment Collected | TextBox | - |
| Date Proof of Employment Collected 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
- Expenses_Salary_AfterUpdate
- Form_Close
- Form_Open
- Net_Asset_Value_AfterUpdate
- Other_Income_AfterUpdate
- Permanent_Staff_AfterUpdate
- Salaries_AfterUpdate
- SaveIt_Click
- Turnover_AfterUpdate