Skip to content

Module: Form_Add and Edit Sales Brief

Type: Form
Lines of Code: 1131
Source: ms_access_files\emerald\Forms\Frm Add and Edit Sales Brief.txt

Dependencies

Module Dependencies: - Actdatabase - RecSet - ConRecSet

Tables Accessed: - Candidates - Channel - Paid - SA - SD - SED - RecSet - Sales - Qry - SkD - LkUp - ED

Forms Referenced: - Frm

Procedures

GETTestParms

Type: Public Function
Lines: 8
Parameters: SBriefID As Long

Calls: GETTestParms, Nz, Val, DCount

UpdateCandidatesSourcedFromED

Type: Public Sub
Lines: 15

Calls: UpdateCandidatesSourcedFromED

UpdateCandidatesSourcedFromSD

Type: Public Sub
Lines: 15

Calls: UpdateCandidatesSourcedFromSD

UpdateCandidatesSourcedFromSED

Type: Public Sub
Lines: 15

Calls: UpdateCandidatesSourcedFromSED

UpdateCandidatesSourcedFromSkD

Type: Public Sub
Lines: 15

Calls: UpdateCandidatesSourcedFromSkD

Additional_Marketing_Costs_AfterUpdate

Type: Private Sub
Lines: 5

Calls: Additional_Marketing_Costs_AfterUpdate, WriteRevisionHistoryRecord

AddPrincipal_Click

Type: Private Sub
Lines: 4

Calls: AddPrincipal_Click

Channel_Partner_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Channel_Partner_AfterUpdate

Channel_Partner_Approver_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Channel_Partner_Approver_AfterUpdate

Channel_Partner_Percentage_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Channel_Partner_Percentage_AfterUpdate

CloseFOrm_Click

Type: Private Sub
Lines: 22

Calls: CloseFOrm_Click

Complexity Notes: - ⚠️ Contains GoTo statements

Contract_Duration_AfterUpdate

Type: Private Sub
Lines: 10

Calls: WriteRevisionHistoryRecord, Contract_Duration_AfterUpdate

Contract_Duration_Other_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Contract_Duration_Other_AfterUpdate

Contract_End_Date_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Contract_End_Date_AfterUpdate

Contract_Payment_Terms_AfterUpdate

Type: Private Sub
Lines: 35

Calls: WriteRevisionHistoryRecord, Contract_Payment_Terms_AfterUpdate

Contract_Start_Date_AfterUpdate

Type: Private Sub
Lines: 23

Calls: WriteRevisionHistoryRecord, DateAdd, Contract_Start_Date_AfterUpdate

Contract_Type_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Contract_Type_AfterUpdate

Date_Principal_Needs_Spend_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Date_Principal_Needs_Spend_AfterUpdate

EditViewStatus_Click

Type: Private Sub
Lines: 8

Calls: EditViewStatus_Click

Efficacy_Non_Standard_Elements_AfterUpdate

Type: Private Sub
Lines: 10

Calls: WriteRevisionHistoryRecord, Efficacy_Non_Standard_Elements_AfterUpdate

Entity_Contracted_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Entity_Contracted_AfterUpdate

Form_AfterInsert

Type: Private Sub
Lines: 18

Calls: Fields, Form_AfterInsert, OpenRecordset

Form_BeforeInsert

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

Calls: Form_BeforeInsert

Form_BeforeUpdate

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

Calls: Form_BeforeUpdate

Form_Close

Type: Private Sub
Lines: 5

Calls: IsLoaded, Form_Close

Form_Open

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

Calls: Client, Nz, Database, Form_Open, Management, Campaign, Fields, Architect, OpenRecordset, Conference

Complexity Notes: - ⚠️ High branching (68 If statements) - ⚠️ Large procedure (555 lines)

Manual_Entry_AfterUpdate

Type: Private Sub
Lines: 9

Calls: Manual_Entry_AfterUpdate

Funding_Fee_Added_to_Programme_Fee_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Funding_Fee_Added_to_Programme_Fee_AfterUpdate

Funding_Fee_Percentage_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Funding_Fee_Percentage_AfterUpdate

How_Lead_Generated_AfterUpdate

Type: Private Sub
Lines: 113

Calls: Client, Database, WriteRevisionHistoryRecord, How_Lead_Generated_AfterUpdate, Management, Campaign, Architect, Conference

Complexity Notes: - ⚠️ High branching (8 If statements) - ⚠️ Large procedure (113 lines)

Ignition_Description_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Ignition_Description_AfterUpdate

Invoice_Day_of_Month_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Invoice_Day_of_Month_AfterUpdate

Invoice_Day_of_Month_Other_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Invoice_Day_of_Month_Other_AfterUpdate

Lead_Report_Frequency_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Lead_Report_Frequency_AfterUpdate

Non_Standard_Bookkeeping_Process_AfterUpdate

Type: Private Sub
Lines: 10

Calls: WriteRevisionHistoryRecord, Non_Standard_Bookkeeping_Process_AfterUpdate

Notes_AfterUpdate

Type: Private Sub
Lines: 5

Calls: Notes_AfterUpdate, WriteRevisionHistoryRecord

NotifySolutionsArchitect_Click

Type: Private Sub
Lines: 36

Calls: NotifySolutionsArchitect_Click, SendOutlookMessage, Fields, Column, OpenRecordset

Once_Off_Invoice_Date_AfterUpdate

Type: Private Sub
Lines: 5

Calls: Once_Off_Invoice_Date_AfterUpdate, WriteRevisionHistoryRecord

Pricing_Mode_AfterUpdate

Type: Private Sub
Lines: 11

Calls: WriteRevisionHistoryRecord, Pricing_Mode_AfterUpdate

Principal_Verified_Date_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Principal_Verified_Date_AfterUpdate

Relationship_Manager_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Relationship_Manager_AfterUpdate

Procurement_Commit_to_Meeting_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Procurement_Commit_to_Meeting_AfterUpdate

Project_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Project_AfterUpdate

Reporting_Frequency_ID_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Reporting_Frequency_ID_AfterUpdate

Sales_Manager_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Sales_Manager_AfterUpdate

Solutions_Architect_AfterUpdate

Type: Private Sub
Lines: 8

Calls: WriteRevisionHistoryRecord, Solutions_Architect_AfterUpdate

Standard_Ignition_Apply_AfterUpdate

Type: Private Sub
Lines: 10

Calls: WriteRevisionHistoryRecord, Standard_Ignition_Apply_AfterUpdate

Total_Stipend_Costs_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Total_Stipend_Costs_AfterUpdate

VA_Pack_Date_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, VA_Pack_Date_AfterUpdate

Verification_Agency_Name_AfterUpdate

Type: Private Sub
Lines: 5

Calls: WriteRevisionHistoryRecord, Verification_Agency_Name_AfterUpdate