emerald - Implementation Details
VBA Modules
Form_Add and Edit Appendices (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Appendices.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit BBBEE Pillar (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit BBBEE Pillar.txt
Lines: 35
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Candidates Sourced From (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Candidates Sourced From.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Channel Partner (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Channel Partner.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Client Tender Brief Meeting (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Client Tender Brief Meeting.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Contact Type (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Contact Type.txt
Lines: 60
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Contract Currency (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Contract Currency.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Contract Duration (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Contract Duration.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Contract Type (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Contract Type.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Country (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Country.txt
Lines: 20
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Delivery Location Sales (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Delivery Location Sales.txt
Lines: 72
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Distribution Model Proposal (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Distribution Model Proposal.txt
Lines: 35
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Distribution Model Type (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Distribution Model Type.txt
Lines: 72
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Divisions Proposal (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Divisions Proposal.txt
Lines: 35
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Entity Contracted (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Entity Contracted.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Expected Payment Frequency (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Expected Payment Frequency.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit External Service Providers (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit External Service Providers.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Feasibility Study Length (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Feasibility Study Length.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Funding Amount Administered By (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Funding Amount Administered By.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Funding Solution (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Funding Solution.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Growth Stage (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Growth Stage.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Impact Statistic Type (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Impact Statistic Type.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Industry Charter (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Industry Charter.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Industry Sales (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Industry Sales.txt
Lines: 35
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Info Session Type (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Info Session Type.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Invoice Day (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Invoice Day.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Language (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Language.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Lead Generated Method (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Lead Generated Method.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Lead Report Frequency (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Lead Report Frequency.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Other Frameworks (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Other Frameworks.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Other Solutions for Appendix (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Other Solutions for Appendix.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Paid For Database (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Paid For Database.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Payment Terms (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Payment Terms.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Pillar Proposal (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Pillar Proposal.txt
Lines: 35
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit PR Type (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit PR Type.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Principal Sales (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Principal Sales.txt
Lines: 62
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Close()
Form_Add and Edit Product Proposal (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Product Proposal.txt
Lines: 28
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Close()
Form_Add and Edit Product Sales (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Product Sales.txt
Lines: 64
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
Form_Add and Edit Proposal Delivery Regions (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Proposal Delivery Regions.txt
Lines: 53
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Distribution_Model_ID_AfterUpdate()
Private Sub Existing_or_New_AfterUpdate()
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Form_Close()
Private Sub Form_Open(Cancel As Integer)
Form_Add and Edit Proposal Department Dates (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Proposal Department Dates.txt
Lines: 164
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Uses On Error Resume Next; Contains GoTo statements; High branching (11 If statements); Large procedure (134 lines)
Private Sub Date_Proposal_Needed_AfterUpdate()
Private Sub Latest_Date_to_Client_AfterUpdate()
Private Sub Proposal_Provided_In_Advance_AfterUpdate()
Form_Add and Edit Proposal Lost Reason (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Proposal Lost Reason.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Proposal Opportunity Owner Dates (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Proposal Opportunity Owner Dates.txt
Lines: 114
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements; High branching (9 If statements)
Private Sub Latest_Date_to_Client_AfterUpdate()
Private Sub Signoff_Send_Date_AfterUpdate()
Form_Add and Edit Proposal Products (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Proposal Products.txt
Lines: 50
Procedures
Private Sub AddToProposal_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Close()
Form_Add and Edit Proposal Status (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Proposal Status.txt
Lines: 35
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Proposal Type of Document (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Proposal Type of Document.txt
Lines: 72
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Proposal (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Proposal.txt
Lines: 2321
Procedures
Public Sub DisplayCountryInfo()
- ⚠️ High branching (12 If statements); Large procedure (115 lines)
Private Sub Access_to_Market_Info_AfterUpdate()
Private Sub Access_to_Market_Info_Included_AfterUpdate()
Private Sub AddPrincipal_Click()
Private Sub AddRegion_Click()
Private Sub Anticipated_Spend_Date_AfterUpdate()
Private Sub BBBEE_Section_Comments_AfterUpdate()
Private Sub BBBEE_Section_Included_AfterUpdate()
Private Sub BDS_Amount_AfterUpdate()
Private Sub BDS_Funding_split_AfterUpdate()
Private Sub Budget_Amount_AfterUpdate()
Private Sub Budget_Type_AfterUpdate()
Private Sub CEO_Needs_to_be_Consulted_AfterUpdate()
Private Sub Changes_to_Monitoring_and_Reporting_AfterUpdate()
Private Sub Changes_to_Monitoring_and_Reporting_Included_AfterUpdate()
Private Sub Client_Pay_EP_Committment_Fee_AfterUpdate()
Private Sub Client_Tender_Brief_Meeting_AfterUpdate()
Private Sub Client_Tender_Brief_Meeting_Comments_AfterUpdate()
Private Sub Client_Tender_Brief_Meeting_Date_AfterUpdate()
Private Sub Client_Tender_Brief_Meeting_Time_AfterUpdate()
Private Sub Client_Tender_Brief_Meeting_Venue_AfterUpdate()
Private Function ExternalProvidersBlank() As Boolean
Private Function ExternalProvidersOther() As Boolean
Private Function FeasibilityStudyRequiredBlank() As Boolean
Private Function FundingSolutionBlank() As Boolean
Private Function FundingSolutionOther() As Boolean
Private Function OtherAppendixSolutionsBlank() As Boolean
Private Function AppendixSolutionsOther() As Boolean
Private Function ImpactStatisticsTypeBlank() As Boolean
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements; High branching (44 If statements); Large procedure (111 lines)
Private Sub Commercial_Buyer_AfterUpdate()
Private Sub Commercial_Buyer_Engaged_AfterUpdate()
Private Sub Contract_Duration_AfterUpdate()
Private Sub Contract_Duration_Other_AfterUpdate()
Private Sub Contract_Type_AfterUpdate()
Private Sub COO_Needs_to_be_Consulted_AfterUpdate()
Private Sub Delivery_Region_Comments_AfterUpdate()
Private Sub DeliveryRegionsList_DblClick(Cancel As Integer)
Private Sub DeliveryRegionsList_KeyDown(KeyCode As Integer, Shift As Integer)
Private Sub Eastern_Cape_Areas_Impacted_AfterUpdate()
Private Sub Eastern_Cape_Impacted_AfterUpdate()
Private Sub EditProposalProducts_Click()
Private Sub EditViewStatus_Click()
Private Sub Email_Submission_Address_AfterUpdate()
Private Sub Email_Submission_AfterUpdate()
Private Sub Email_Submission_Comments_AfterUpdate()
Private Sub Email_Submission_Number_Copies_AfterUpdate()
Private Sub Email_Submit_a_Bid_Comments_AfterUpdate()
Private Sub Email_Submit_a_Bid_Sent_AfterUpdate()
Private Sub Entity_Contracted_AfterUpdate()
Private Sub Entrepreneur_Stipend_AfterUpdate()
Private Sub Entrepreneur_Stipend_Included_AfterUpdate()
Private Sub EP_Success_Stories_Comments_AfterUpdate()
Private Sub EP_Success_Stories_Needed_AfterUpdate()
Private Sub External_Service_Providers_Included_AfterUpdate()
Private Sub External_Service_Providers_Other_AfterUpdate()
Private Sub Feasibility_Study_Comments_AfterUpdate()
Private Sub Feasibility_Study_Required_AfterUpdate()
Private Sub Form_AfterInsert()
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Form_Close()
Private Sub Form_Open(Cancel As Integer)
- ⚠️ High branching (50 If statements); Large procedure (392 lines)
Private Sub Free_State_Areas_Impacted_AfterUpdate()
Private Sub Free_State_Impacted_AfterUpdate()
Private Sub Funding_Amount_Administered_By_AfterUpdate()
Private Sub Funding_Amount_Administered_By_Other_AfterUpdate()
Private Sub Funding_Amount_AfterUpdate()
Private Sub Funding_Amount_Includes_Admin_Fee_AfterUpdate()
Private Sub Funding_Solution_Other_AfterUpdate()
Private Sub Gauteng_Areas_Impacted_AfterUpdate()
Private Sub Gauteng_Impacted_AfterUpdate()
Private Sub Growth_Stage_Comments_AfterUpdate()
Private Sub Impact_Guarantee_Applies_AfterUpdate()
Private Sub Impact_Statistics_Comments_AfterUpdate()
Private Sub Impact_Statistics_Needed_AfterUpdate()
Private Sub Include_PR_and_Marketing_Offerings_AfterUpdate()
Private Sub Include_PR_and_Marketing_Offerings_Comments_AfterUpdate()
Private Sub Include_SD_Manager_Offerings_AfterUpdate()
Private Sub Include_SD_Manager_Offerings_Comments_AfterUpdate()
Private Sub Infographic_Comments_AfterUpdate()
Private Sub Infographic_Needed_AfterUpdate()
Private Sub Intention_Submit_Deadline_Comments_AfterUpdate()
Private Sub Intention_Submit_Deadline_Exists_AfterUpdate()
Private Sub Intention_Submit_Deadline_Sent_AfterUpdate()
Private Sub Key_Account_Manager_AfterUpdate()
Private Sub KwaZulu_Natal_Areas_Impacted_AfterUpdate()
Private Sub KwaZulu_Natal_Impacted_AfterUpdate()
Private Sub Limpopo_Areas_Impacted_AfterUpdate()
Private Sub Limpopo_Impacted_AfterUpdate()
Private Sub Marketing_Manager_Needs_to_be_Consulted_AfterUpdate()
Private Sub Mpumalanga_Areas_Impacted_AfterUpdate()
Private Sub Mpumalanga_Impacted_AfterUpdate()
Private Sub New_Product_or_Recipe_AfterUpdate()
Private Sub New_Product_or_Recipe_Required_AfterUpdate()
Private Sub Northern_Cape_Areas_Impacted_AfterUpdate()
Private Sub Northern_Cape_Impacted_AfterUpdate()
Private Sub Northwest_Areas_Impacted_AfterUpdate()
Private Sub Northwest_Impacted_AfterUpdate()
Private Sub NotifyTeam_Click()
- ⚠️ High branching (6 If statements)
Private Sub Opportunity_Owner_AfterUpdate()
Private Sub OpportunityOwnerWillWrite_Click()
Private Sub Other_Custom_Aspects_Comments_AfterUpdate()
Private Sub Other_Custom_Aspects_Needed_AfterUpdate()
Private Sub Other_Frameworks_AfterUpdate()
Private Sub Other_Impacted_AfterUpdate()
Private Sub Other_Impacted_Comments_AfterUpdate()
Private Sub Other_Solutions_for_Appendix_Needed_AfterUpdate()
Private Sub Outstanding_Queries_Comments_AfterUpdate()
Private Sub Outstanding_Queries_Remaining_AfterUpdate()
Private Sub Photographs_Comments_AfterUpdate()
Private Sub Photographs_Needed_AfterUpdate()
Private Sub Physical_Submission_Address_AfterUpdate()
Private Sub Physical_Submission_AfterUpdate()
Private Sub Physical_Submission_Comments_AfterUpdate()
Private Sub Physical_Submission_Number_Copies_AfterUpdate()
Private Sub Prequalification_Criteria_AfterUpdate()
Private Sub Prequalification_Unknown_Comments_AfterUpdate()
Private Sub Project_Delivery_Timeline_Comments_AfterUpdate()
Private Sub Project_Delivery_Timeline_Included_AfterUpdate()
Private Sub Proposal_Brief_Completed_AfterUpdate()
Private Sub Proposal_Date_Submitted_AfterUpdate()
Private Sub Proposal_Drive_Location_AfterUpdate()
Private Sub Proposal_Due_Date_AfterUpdate()
Private Sub Proposal_Pricing_Comments_AfterUpdate()
Private Sub Proposal_Pricing_Included_AfterUpdate()
Private Sub Proposal_Proofread_and_QC_Complete_AfterUpdate()
Private Sub Proposal_Submission_Type_AfterUpdate()
Private Sub Proposal_Turnaround_Time_Comments_AfterUpdate()
Private Sub Proposal_Type_of_Document_ID_AfterUpdate()
Private Sub Proposal_Type_of_Document_ID_B_AfterUpdate()
Private Sub ProposalDeptWillWrite_Click()
Private Sub Prosperator_Opportunity_Originated_AfterUpdate()
Private Sub Raizcorp_Admin_Fee_Percentage_AfterUpdate()
Private Sub Raizcorp_Person_Attending_Brief_Meeting_AfterUpdate()
Private Sub Replacement_Guarantee_Applies_AfterUpdate()
Private Sub S2S_Role_Required_AfterUpdate()
Private Sub S2S_Role_Required_Comments_AfterUpdate()
Private Sub Selection_Process_Modifications_AfterUpdate()
Private Sub Selection_Process_Modifications_Needed_AfterUpdate()
Private Sub Showcase_Previous_Experience_AfterUpdate()
Private Sub Showcase_Previous_Experience_Comments_AfterUpdate()
Private Sub Specific_Number_of_Entrepreneurs_AfterUpdate()
Private Sub Specific_Number_of_Entrepreneurs_Required_AfterUpdate()
Private Sub SubFrm_Proposal_Appendices_Enter()
Private Sub SubFrm_Proposal_Client_Needs_Enter()
Private Sub SubFrm_Proposal_Commodities_Enter()
Private Sub SubFrm_Proposal_External_Service_Providers_Enter()
Private Sub SubFrm_Proposal_Feasibility_Study_Enter()
Private Sub SubFrm_Proposal_Funding_Solution_Enter()
Private Sub SubFrm_Proposal_Growth_Stages_Enter()
Private Sub SubFrm_Proposal_Other_Solutions_for_Appendix_Enter()
Private Sub SubFrm_Proposal_Pillars_Enter()
Private Sub SubFrm_Proposal_Sourcing_and_Selection_Enter()
Private Sub SubFrm_Proposal_Top_Priorities_Enter()
Private Sub SubFrm_Proposal_Tried_So_Far_Enter()
Private Sub SubFrm_Proposal_Who_Is_Reading_Enter()
Private Sub Technical_Buyer_AfterUpdate()
Private Sub Technical_Buyer_Engaged_AfterUpdate()
Private Sub Technical_Queries_Deadline_AfterUpdate()
Private Sub Technical_Queries_Deadline_Exists_AfterUpdate()
Private Sub Technical_Queries_Deadline_How_Send_AfterUpdate()
Private Sub Technical_Queries_Deadline_Raizcorp_Staff_Liaise_AfterUpdate()
Private Sub Technical_Queries_to_be_Sent_AfterUpdate()
Private Sub Tender_Closing_Date_AfterUpdate()
Private Sub Tender_Competitors_AfterUpdate()
Private Sub Tender_Contract_Number_AfterUpdate()
Private Sub Tender_Contract_TC_Exists_AfterUpdate()
Private Sub Tender_Contract_TC_Given_FD_AfterUpdate()
Private Sub Tender_Duration_of_Contract_AfterUpdate()
Private Sub Tender_Evaluation_Info_AfterUpdate()
Private Sub Tender_Pricing_Format_Comments_AfterUpdate()
Private Sub Tender_Pricing_Format_Exists_AfterUpdate()
Private Sub Tender_Project_Plan_Created_AfterUpdate()
Private Sub Tender_Project_Title_AfterUpdate()
Private Sub Tender_Sourcing_AfterUpdate()
Private Sub Tender_Validity_Period_AfterUpdate()
Private Sub Website_Submission_AfterUpdate()
Private Sub Website_Submission_Comments_AfterUpdate()
Private Sub Website_Submission_Login_Details_AfterUpdate()
Private Sub Western_Cape_Areas_Impacted_AfterUpdate()
Private Sub Western_Cape_Impacted_AfterUpdate()
Private Sub White_Label_Product_AfterUpdate()
Private Sub White_Label_Product_Needed_AfterUpdate()
Private Sub Who_Will_Sign_Off_AfterUpdate()
Form_Add and Edit Roles (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Roles.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Sales Brief Status (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Sales Brief Status.txt
Lines: 35
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Sales Brief (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Sales Brief.txt
Lines: 1131
Procedures
Public Function GETTestParms(SBriefID As Long)
Public Sub UpdateCandidatesSourcedFromED()
Public Sub UpdateCandidatesSourcedFromSD()
Public Sub UpdateCandidatesSourcedFromSED()
Public Sub UpdateCandidatesSourcedFromSkD()
Private Sub Additional_Marketing_Costs_AfterUpdate()
Private Sub AddPrincipal_Click()
Private Sub Channel_Partner_AfterUpdate()
Private Sub Channel_Partner_Approver_AfterUpdate()
Private Sub Channel_Partner_Percentage_AfterUpdate()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Contract_Duration_AfterUpdate()
Private Sub Contract_Duration_Other_AfterUpdate()
Private Sub Contract_End_Date_AfterUpdate()
Private Sub Contract_Payment_Terms_AfterUpdate()
Private Sub Contract_Start_Date_AfterUpdate()
Private Sub Contract_Type_AfterUpdate()
Private Sub Date_Principal_Needs_Spend_AfterUpdate()
Private Sub EditViewStatus_Click()
Private Sub Efficacy_Non_Standard_Elements_AfterUpdate()
Private Sub Entity_Contracted_AfterUpdate()
Private Sub Form_AfterInsert()
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Form_Close()
Private Sub Form_Open(Cancel As Integer)
- ⚠️ High branching (68 If statements); Large procedure (555 lines)
Private Sub Manual_Entry_AfterUpdate()
Private Sub Funding_Fee_Added_to_Programme_Fee_AfterUpdate()
Private Sub Funding_Fee_Percentage_AfterUpdate()
Private Sub How_Lead_Generated_AfterUpdate()
- ⚠️ High branching (8 If statements); Large procedure (113 lines)
Private Sub Ignition_Description_AfterUpdate()
Private Sub Invoice_Day_of_Month_AfterUpdate()
Private Sub Invoice_Day_of_Month_Other_AfterUpdate()
Private Sub Lead_Report_Frequency_AfterUpdate()
Private Sub Non_Standard_Bookkeeping_Process_AfterUpdate()
Private Sub Notes_AfterUpdate()
Private Sub NotifySolutionsArchitect_Click()
Private Sub Once_Off_Invoice_Date_AfterUpdate()
Private Sub Pricing_Mode_AfterUpdate()
Private Sub Principal_Verified_Date_AfterUpdate()
Private Sub Relationship_Manager_AfterUpdate()
Private Sub Procurement_Commit_to_Meeting_AfterUpdate()
Private Sub Project_AfterUpdate()
Private Sub Reporting_Frequency_ID_AfterUpdate()
Private Sub Sales_Manager_AfterUpdate()
Private Sub Solutions_Architect_AfterUpdate()
Private Sub Standard_Ignition_Apply_AfterUpdate()
Private Sub Total_Stipend_Costs_AfterUpdate()
Private Sub VA_Pack_Date_AfterUpdate()
Private Sub Verification_Agency_Name_AfterUpdate()
Form_Add and Edit Sourcing and Selection (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Sourcing and Selection.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Sub Products Sales (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Sub Products Sales.txt
Lines: 71
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_AfterInsert()
Private Sub NewRecord_Click()
Form_Add and Edit Supply Chain Requirements (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Supply Chain Requirements.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Tender Brief Meeting (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Tender Brief Meeting.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Tender Sources (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Tender Sources.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Top Priorities (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Top Priorities.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Users (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Users.txt
Lines: 40
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Writer Role (Form)
File: ms_access_files\emerald\Forms\Frm Add and Edit Writer Role.txt
Lines: 58
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add Sales Brief Procurement Commit to Meeting (Form)
File: ms_access_files\emerald\Forms\Frm Add Sales Brief Procurement Commit to Meeting.txt
Lines: 25
Procedures
Private Sub NoButton_Click()
Private Sub OKButton_Click()
Private Sub YesButton_Click()
Form_Change Password (Form)
File: ms_access_files\emerald\Forms\Frm Change Password.txt
Lines: 138
Procedures
Private Sub CancelButton_Click()
Private Sub CurrentPassword_AfterUpdate()
Private Sub Form_Open(Cancel As Integer)
Private Sub NewPassword_AfterUpdate()
Private Sub OKButton_Click()
Form_Edit Email Recipient List (Form)
File: ms_access_files\emerald\Forms\Frm Edit Email Recipient List.txt
Lines: 62
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Close()
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Edit Proposal Status (Form)
File: ms_access_files\emerald\Forms\Frm Edit Proposal Status.txt
Lines: 95
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Open(Cancel As Integer)
Private Sub Proposal_Status_ID_AfterUpdate()
Form_Edit Sales Brief Status (Form)
File: ms_access_files\emerald\Forms\Frm Edit Sales Brief Status.txt
Lines: 192
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements; High branching (6 If statements)
Private Sub Form_Open(Cancel As Integer)
Private Sub Sales_Brief_Status_ID_AfterUpdate()
- ⚠️ High branching (13 If statements)
Form_Maintenance Menu (Form)
File: ms_access_files\emerald\Forms\Frm Maintenance Menu.txt
Lines: 224
Procedures
Private Sub Appendices_Click()
Private Sub BBBEEPillar_Click()
Private Sub CandidatesSourcedFrom_Click()
Private Sub ChannelPartner_Click()
Private Sub ClientTenderBriefMeeting_Click()
Private Sub ClientTiers_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ContactType_Click()
Private Sub ContractCurrency_Click()
Private Sub ContractDuration_Click()
Private Sub ContractType_Click()
Private Sub Country_Click()
Private Sub Delivery_Location_Click()
Private Sub DistributionModels_Click()
Private Sub DistributionModelType_Click()
Private Sub Divisions_Click()
Private Sub EditPrincipals_Click()
Private Sub EmailRecipientList_Click()
Private Sub EntityContracted_Click()
Private Sub ExpectedPaymentFrequency_Click()
Private Sub ExternalServiceProviders_Click()
Private Sub FeasibilityStudyLength_Click()
Private Sub FundingAmountAdministeredBy_Click()
Private Sub FundingSolution_Click()
Private Sub GrowthStage_Click()
Private Sub ImpactStatisticTypes_Click()
Private Sub Industry_Click()
Private Sub IndustryCharter_Click()
Private Sub InfoSessionType_Click()
Private Sub InvoiceDay_Click()
Private Sub Language_Click()
Private Sub LeadGeneratedMethod_Click()
Private Sub LeadReportFrequency_Click()
Private Sub PaymentTerms_Click()
Private Sub OtherFrameworks_Click()
Private Sub OtherSolutionsAppendix_Click()
Private Sub PaidForDatabase_Click()
Private Sub PillarsProposal_Click()
Private Sub ProductsProposal_Click()
Private Sub ProductsSales_Click()
Private Sub ProposalLostReasons_Click()
Private Sub ProposalStatus_Click()
Private Sub ProposalTypeofDocument_Click()
Private Sub PRType_Click()
Private Sub SalesBriefStatus_Click()
Private Sub SourcingAndSelection_Click()
Private Sub SubProductsSales_Click()
Private Sub SupplyChainRequirements_Click()
Private Sub TenderBriefMeeting_Click()
Private Sub TenderSources_Click()
Private Sub TopPriorities_Click()
Private Sub WriterRoles_Click()
Form_Opening Dialog (Form)
File: ms_access_files\emerald\Forms\Frm Opening Dialog.txt
Lines: 107
Procedures
Private Sub CancelButton_Click()
Private Sub Form_Open(Cancel As Integer)
Private Sub Password_AfterUpdate()
- ⚠️ High branching (6 If statements)
Private Sub Username_AfterUpdate()
Form_Principal List (Form)
File: ms_access_files\emerald\Forms\Frm Principal List.txt
Lines: 157
Procedures
Public Sub UpdateList()
Private Sub AddPrincipal_Click()
Private Sub AddPrincipaltoSalesBrief_Click()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub PrincipalList_AfterUpdate()
Private Sub PrincipalList_DblClick(Cancel As Integer)
Private Sub PrincipalList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub SalesBriefList_KeyDown(KeyCode As Integer, Shift As Integer)
Private Sub StrCriteria1_AfterUpdate()
Form_Product List Proposal (Form)
File: ms_access_files\emerald\Forms\Frm Product List Proposal.txt
Lines: 80
Procedures
Private Sub AddProduct_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ProductList_AfterUpdate()
Private Sub ProductList_DblClick(Cancel As Integer)
Private Sub ProductList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (7 If statements)
Form_Proposal List (Form)
File: ms_access_files\emerald\Forms\Frm Proposal List.txt
Lines: 227
Procedures
Public Sub UpdateList()
- ⚠️ High branching (9 If statements)
Private Sub AddProposal_Click()
Private Sub ChangePassword_Click()
Private Sub ClearFilters_Click()
Private Sub CloseFOrm_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
Private Sub Filter1_AfterUpdate()
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
Private Sub MaintenanceFunction_Click()
Private Sub ProposalList_DblClick(Cancel As Integer)
Private Sub ProposalList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub ProposalStatus_AfterUpdate()
Private Sub ReportMenu_Click()
Private Sub StrCriteria1_AfterUpdate()
Form_Report Menu Proposal (Form)
File: ms_access_files\emerald\Forms\Frm Report Menu Proposal.txt
Lines: 30
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ExportTATToExcel_Click()
Private Sub ReportWriter_Click()
Form_Report Writer Dialog (Form)
File: ms_access_files\emerald\Forms\Frm Report Writer Dialog.txt
Lines: 345
Procedures
Public Sub ExportTheReport()
- ⚠️ Contains GoTo statements; High branching (27 If statements); Large procedure (249 lines)
Private Sub ClearFilters_Click()
Private Sub Filter1_AfterUpdate()
Private Sub Form_Close()
Private Sub Form_Open(Cancel As Integer)
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Reports Date Dialog (Form)
File: ms_access_files\emerald\Forms\Frm Reports Date Dialog.txt
Lines: 52
Procedures
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Sales Brief List (Form)
File: ms_access_files\emerald\Forms\Frm Sales Brief List.txt
Lines: 956
Procedures
Public Sub UpdateList()
- ⚠️ High branching (10 If statements)
Public Sub CreateRevisedSalesBrief()
- ⚠️ High branching (23 If statements); Large procedure (679 lines)
Private Sub AddSalesBrief_Click()
Private Sub ChangePassword_Click()
Private Sub ClearFilters_Click()
Private Sub CloseFOrm_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
Private Sub Filter1_AfterUpdate()
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
Private Sub MaintenanceFunction_Click()
Private Sub PrintSalesBrief_Click()
Private Sub ReportMenu_Click()
Private Sub ReviseSalesBrief_Click()
Private Sub SalesBriefList_DblClick(Cancel As Integer)
Private Sub SalesBriefList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (8 If statements)
Private Sub SalesBriefStatus_AfterUpdate()
Private Sub StrCriteria1_AfterUpdate()
Form_SubFrm Product Distribution Models (Form)
File: ms_access_files\emerald\Forms\SubFrm Product Distribution Models.txt
Lines: 20
Procedures
Private Sub DeleteRec_Click()
Form_SubFrm Product Divisions (Form)
File: ms_access_files\emerald\Forms\SubFrm Product Divisions.txt
Lines: 20
Procedures
Private Sub DeleteRec_Click()
Form_SubFrm Proposal Appendices (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Appendices.txt
Lines: 29
Procedures
Private Sub Candidates_Sourced_From_AfterUpdate()
Private Sub DeleteRec_Click()
Form_SubFrm Proposal Client Needs (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Client Needs.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Proposal_Client_Need_AfterUpdate()
Form_SubFrm Proposal Commodities (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Commodities.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Proposal_Commodity_AfterUpdate()
Form_SubFrm Proposal Divisions (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Divisions.txt
Lines: 37
Procedures
Private Sub DeleteRec_Click()
Private Sub Division_ID_AfterUpdate()
Form_SubFrm Proposal External Service Providers (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal External Service Providers.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_External_Service_Provider_AfterUpdate()
Form_SubFrm Proposal Feasibility Study (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Feasibility Study.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_Feasibility_Study_AfterUpdate()
Form_SubFrm Proposal Funding Solution (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Funding Solution.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_Funding_Solution_AfterUpdate()
Form_SubFrm Proposal Growth Stages (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Growth Stages.txt
Lines: 32
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_Growth_Stage_AfterUpdate()
Form_SubFrm Proposal Impact Statistics Types (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Impact Statistics Types.txt
Lines: 32
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_Impact_Statistic_Type_AfterUpdate()
Form_SubFrm Proposal Non South African Regions (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Non South African Regions.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_Other_Solution_for_Appendix_AfterUpdate()
Form_SubFrm Proposal Other Solutions for Appendix (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Other Solutions for Appendix.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_Other_Solution_for_Appendix_AfterUpdate()
Form_SubFrm Proposal Pillars (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Pillars.txt
Lines: 38
Procedures
Private Sub DeleteRec_Click()
Private Sub Pillar_ID_AfterUpdate()
Private Sub Pillar_Other_AfterUpdate()
Form_SubFrm Proposal Products (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Products.txt
Lines: 23
Procedures
Private Sub DeleteRec_Click()
Form_SubFrm Proposal Sourcing and Selection (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Sourcing and Selection.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_Sourcing_and_Selection_AfterUpdate()
Form_SubFrm Proposal Stakeholders Other (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Stakeholders Other.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_Other_Solution_for_Appendix_AfterUpdate()
Form_SubFrm Proposal Time Tracking (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Time Tracking.txt
Lines: 27
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Proposal Top Priorities (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Top Priorities.txt
Lines: 54
Procedures
Private Sub DeleteRec_Click()
Private Sub Proposal_Top_Priority_AfterUpdate()
Private Sub Proposal_Top_Priority_Ranking_AfterUpdate()
Form_SubFrm Proposal Tried So Far (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Tried So Far.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Proposal_Tried_So_Far_AfterUpdate()
Form_SubFrm Proposal Who Is Reading (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Who Is Reading.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Proposal_Who_is_Reading_AfterUpdate()
Form_SubFrm Proposal Writers (Form)
File: ms_access_files\emerald\Forms\SubFrm Proposal Writers.txt
Lines: 50
Procedures
Private Sub DeleteRec_Click()
Private Sub Writer_Name_AfterUpdate()
Private Sub Writer_Name_Other_AfterUpdate()
Private Sub Writer_Role_AfterUpdate()
Private Sub Writer_Role_Other_AfterUpdate()
Form_SubFrm Sales Brief Bookkeeping Process Description (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Bookkeeping Process Description.txt
Lines: 36
Procedures
Private Sub Bookkeeping_Process_Description_AfterUpdate()
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Sales Brief Contract Numbers (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Contract Numbers.txt
Lines: 36
Procedures
Private Sub Contract_Number_AfterUpdate()
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Sales Brief Efficacy Non Standard Elements (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Efficacy Non Standard Elements.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Efficacy_Non_Standard_Elements_Description_AfterUpdate()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Sales Brief Extra Sponsor Elements (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Extra Sponsor Elements.txt
Lines: 95
Procedures
Private Sub BBBEE_Pillar_AfterUpdate()
Private Sub DeleteRec_Click()
Private Sub Element_Type_AfterUpdate()
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Frequency_of_Payments_AfterUpdate()
Private Sub Monthly_Day_of_Month_AfterUpdate()
Private Sub Number_of_Entrepreneurs_AfterUpdate()
Private Sub Once_Off_Payment_Date_AfterUpdate()
Private Sub Payment_Amount_AfterUpdate()
Private Sub Sponsorship_Amount_AfterUpdate()
Form_SubFrm Sales Brief Finance Distribution Model Type Fees (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Finance Distribution Model Type Fees.txt
Lines: 47
Procedures
Private Sub DeleteRec_Click()
Private Sub Distribution_Model_Type_ID_AfterUpdate()
Private Sub Management_Fee_AfterUpdate()
Private Sub Operational_Expenses_AfterUpdate()
Private Sub Set_up_Fee_AfterUpdate()
Form_SubFrm Sales Brief Finance Invoice Month (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Finance Invoice Month.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Sales_Brief_Finance_Invoice_Month_AfterUpdate()
Form_SubFrm Sales Brief Finance Special Payment Terms (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Finance Special Payment Terms.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Sales_Brief_Special_Payment_Terms_Item_AfterUpdate()
Form_SubFrm Sales Brief Guiding Deliverables Bespoke (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Guiding Deliverables Bespoke.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Sales_Brief_Guiding_Deliverables_Bespoke_Item_AfterUpdate()
Form_SubFrm Sales Brief Guiding Towards (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Guiding Towards.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Sales_Brief_Guiding_Towards_Item_AfterUpdate()
Form_SubFrm Sales Brief Learning Deliverables Bespoke (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Learning Deliverables Bespoke.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Sales_Brief_Learning_Deliverables_Bespoke_Item_AfterUpdate()
Form_SubFrm Sales Brief Learning Guides Notified (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Learning Guides Notified.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Sales_Brief_Learning_Guides_Notified_Item_AfterUpdate()
Form_SubFrm Sales Brief Marketing ED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Marketing ED.txt
Lines: 109
Procedures
Private Sub Info_Session_Type_AfterUpdate()
Private Sub Launch_Required_AfterUpdate()
Private Sub Marketing_Campaign_Required_AfterUpdate()
Private Sub PR_Type_AfterUpdate()
Private Sub Principal_Campaign_Branded_AfterUpdate()
- ⚠️ High branching (6 If statements)
Private Sub Principal_Launch_Budget_AfterUpdate()
Private Sub Raizcorp_Launch_Budget_AfterUpdate()
Private Sub Who_Arranges_Launch_AfterUpdate()
Form_SubFrm Sales Brief Marketing SD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Marketing SD.txt
Lines: 143
Procedures
Private Sub Info_Session_Type_AfterUpdate()
Private Sub Launch_Required_AfterUpdate()
Public Sub UpdateCandidatesSourcedFromSD()
Private Sub Marketing_Campaign_Required_AfterUpdate()
Private Sub Marketing_Contact_Email_AfterUpdate()
Private Sub Marketing_Contact_Name_AfterUpdate()
Private Sub Marketing_Contact_Phone_AfterUpdate()
Private Sub PR_Type_AfterUpdate()
Private Sub Principal_Campaign_Branded_AfterUpdate()
- ⚠️ High branching (6 If statements)
Private Sub Principal_Launch_Budget_AfterUpdate()
Private Sub Raizcorp_Launch_Budget_AfterUpdate()
Private Sub Who_Arranges_Launch_AfterUpdate()
Form_SubFrm Sales Brief Marketing SED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Marketing SED.txt
Lines: 143
Procedures
Private Sub Info_Session_Type_AfterUpdate()
Private Sub Launch_Required_AfterUpdate()
Public Sub UpdateCandidatesSourcedFromSED()
Private Sub Marketing_Campaign_Required_AfterUpdate()
Private Sub Marketing_Contact_Email_AfterUpdate()
Private Sub Marketing_Contact_Name_AfterUpdate()
Private Sub Marketing_Contact_Phone_AfterUpdate()
Private Sub PR_Type_AfterUpdate()
Private Sub Principal_Campaign_Branded_AfterUpdate()
- ⚠️ High branching (6 If statements)
Private Sub Principal_Launch_Budget_AfterUpdate()
Private Sub Raizcorp_Launch_Budget_AfterUpdate()
Private Sub Who_Arranges_Launch_AfterUpdate()
Form_SubFrm Sales Brief Marketing SkD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Marketing SkD.txt
Lines: 143
Procedures
Private Sub Info_Session_Type_AfterUpdate()
Private Sub Launch_Required_AfterUpdate()
Public Sub UpdateCandidatesSourcedFromSkD()
Private Sub Marketing_Campaign_Required_AfterUpdate()
Private Sub Marketing_Contact_Email_AfterUpdate()
Private Sub Marketing_Contact_Name_AfterUpdate()
Private Sub Marketing_Contact_Phone_AfterUpdate()
Private Sub PR_Type_AfterUpdate()
Private Sub Principal_Campaign_Branded_AfterUpdate()
- ⚠️ High branching (6 If statements)
Private Sub Principal_Launch_Budget_AfterUpdate()
Private Sub Raizcorp_Launch_Budget_AfterUpdate()
Private Sub Who_Arranges_Launch_AfterUpdate()
Form_SubFrm Sales Brief Principal Contacts (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Principal Contacts.txt
Lines: 136
Procedures
Private Sub Contact_Email_AfterUpdate()
Private Sub Contact_First_Name_AfterUpdate()
Private Sub Contact_Phone_AfterUpdate()
Private Sub Contact_Position_AfterUpdate()
Private Sub Contact_Surname_AfterUpdate()
Private Sub Contact_Type_AfterUpdate()
Private Sub DeleteRec_Click()
- ⚠️ High branching (7 If statements)
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub VA_Pack_Addressee_AfterUpdate()
- ⚠️ Uses SendKeys
Form_SubFrm Sales Brief Principal Countries (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Principal Countries.txt
Lines: 49
Procedures
Private Sub Country_ID_AfterUpdate()
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Sales Brief Principal Languages (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Principal Languages.txt
Lines: 38
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Sales Brief Principal Priorities (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Principal Priorities.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Principal_Priority_AfterUpdate()
Form_SubFrm Sales Brief Principal Referral Contacts (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Principal Referral Contacts.txt
Lines: 60
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Principal_Contact_Email_AfterUpdate()
Private Sub Principal_Contact_EOI_Business_Name_AfterUpdate()
Private Sub Principal_Contact_First_Name_AfterUpdate()
Private Sub Principal_Contact_Surname_AfterUpdate()
Private Sub Principal_Contact_Telephone_Number_AfterUpdate()
Form_SubFrm Sales Brief Principal (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Principal.txt
Lines: 118
Procedures
Private Sub Client_Tier_ID_AfterUpdate()
Private Sub Company_Website_AfterUpdate()
Private Sub Country_ID_AfterUpdate()
Private Sub Financial_Year_End_AfterUpdate()
Private Sub Industry_Charter_AfterUpdate()
Private Sub Language_AfterUpdate()
Private Sub Physical_Address_1_AfterUpdate()
Private Sub Physical_Address_2_AfterUpdate()
Private Sub Physical_Address_3_AfterUpdate()
Private Sub Physical_Address_4_AfterUpdate()
Private Sub Principal_AfterUpdate()
Private Sub Principal_Industry_AfterUpdate()
Form_SubFrm Sales Brief SD Initiatives (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief SD Initiatives.txt
Lines: 36
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Sales_Brief_SD_Initiatives_Item_AfterUpdate()
Form_SubFrm Sales Brief Selection Candidates Sourced From ED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Candidates Sourced From ED.txt
Lines: 29
Procedures
Private Sub Candidates_Sourced_From_AfterUpdate()
Private Sub DeleteRec_Click()
Form_SubFrm Sales Brief Selection Candidates Sourced From SD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Candidates Sourced From SD.txt
Lines: 29
Procedures
Private Sub Candidates_Sourced_From_AfterUpdate()
Private Sub DeleteRec_Click()
Form_SubFrm Sales Brief Selection Candidates Sourced From SED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Candidates Sourced From SED.txt
Lines: 29
Procedures
Private Sub Candidates_Sourced_From_AfterUpdate()
Private Sub DeleteRec_Click()
Form_SubFrm Sales Brief Selection Candidates Sourced From SkD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Candidates Sourced From SkD.txt
Lines: 29
Procedures
Private Sub Candidates_Sourced_From_AfterUpdate()
Private Sub DeleteRec_Click()
Form_SubFrm Sales Brief Selection Client Supply Chain Req SD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Client Supply Chain Req SD.txt
Lines: 36
Procedures
Private Sub Client_Supply_Chain_Requirement_AfterUpdate()
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Sales Brief Selection Commodities ED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Commodities ED.txt
Lines: 29
Procedures
Private Sub Commodity_AfterUpdate()
Private Sub DeleteRec_Click()
Form_SubFrm Sales Brief Selection Commodities SD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Commodities SD.txt
Lines: 29
Procedures
Private Sub Commodity_AfterUpdate()
Private Sub DeleteRec_Click()
Form_SubFrm Sales Brief Selection ED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection ED.txt
Lines: 130
Procedures
Private Sub Cohort_Ignition_Qtr_AfterUpdate()
Private Sub Cohort_Ignition_Year_AfterUpdate()
Private Sub Minimum_Companies_Required_AfterUpdate()
Private Sub Principal_Approve_Candidate_AfterUpdate()
Private Sub Principal_Approve_Candidate_Leads_AfterUpdate()
Private Sub Principal_Subsidise_Assessment_Fee_AfterUpdate()
Private Sub Subsidised_Assessment_Amount_AfterUpdate()
Private Sub Supporting_Doc_Affidavit__EME__AfterUpdate()
Private Sub Supporting_Doc_BEE_Certificate_AfterUpdate()
Private Sub Supporting_Doc_Certified_ID_Copy_AfterUpdate()
Private Sub Supporting_Doc_CK1_Document_AfterUpdate()
Private Sub Supporting_Doc_EMP201_AfterUpdate()
Private Sub Supporting_Doc_Employee_Payslips_AfterUpdate()
Private Sub Supporting_Doc_IRP5_AfterUpdate()
Private Sub Supporting_Doc_Other_AfterUpdate()
Private Sub Supporting_Doc_Other_Text_AfterUpdate()
Private Sub Supporting_Doc_Proof_of_Turnover_AfterUpdate()
Private Sub Supporting_Doc_Tax_Clearance_Certificate_AfterUpdate()
Private Sub Supporting_Doc_VAT_Registration_AfterUpdate()
Form_SubFrm Sales Brief Selection Marketing Products (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Marketing Products.txt
Lines: 194
Procedures
Private Sub BBBEE_Pillar_AfterUpdate()
Private Sub DeleteRec_Click()
- ⚠️ High branching (10 If statements)
Private Sub Form_AfterInsert()
Private Sub Form_AfterUpdate()
Private Sub Product_ID_AfterUpdate()
Private Sub Sponsorship_Amount_AfterUpdate()
Form_SubFrm Sales Brief Selection SD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection SD.txt
Lines: 141
Procedures
Private Sub Cohort_Ignition_Qtr_AfterUpdate()
Private Sub Cohort_Ignition_Year_AfterUpdate()
Private Sub Minimum_Companies_Required_AfterUpdate()
Private Sub Principal_Approve_Candidate_AfterUpdate()
Private Sub Principal_Approve_Candidate_Leads_AfterUpdate()
Private Sub Principal_Subsidise_Assessment_Fee_AfterUpdate()
Private Sub Subsidised_Assessment_Amount_AfterUpdate()
Private Sub Supporting_Doc_Affidavit__EME__AfterUpdate()
Private Sub Supporting_Doc_BEE_Certificate_AfterUpdate()
Private Sub Supporting_Doc_Certified_ID_Copy_AfterUpdate()
Private Sub Supporting_Doc_CK1_Document_AfterUpdate()
Private Sub Supporting_Doc_EMP201_AfterUpdate()
Private Sub Supporting_Doc_Employee_Payslips_AfterUpdate()
Private Sub Supporting_Doc_IRP5_AfterUpdate()
Private Sub Supporting_Doc_Other_AfterUpdate()
Private Sub Supporting_Doc_Other_Text_AfterUpdate()
Private Sub Supporting_Doc_Proof_of_Turnover_AfterUpdate()
Private Sub Supporting_Doc_Tax_Clearance_Certificate_AfterUpdate()
Private Sub Supporting_Doc_VAT_Registration_AfterUpdate()
Private Sub Supply_Chain_Requirement_AfterUpdate()
Form_SubFrm Sales Brief Selection SED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection SED.txt
Lines: 130
Procedures
Private Sub Cohort_Ignition_Qtr_AfterUpdate()
Private Sub Cohort_Ignition_Year_AfterUpdate()
Private Sub Minimum_Companies_Required_AfterUpdate()
Private Sub Principal_Approve_Candidate_AfterUpdate()
Private Sub Principal_Approve_Candidate_Leads_AfterUpdate()
Private Sub Principal_Subsidise_Assessment_Fee_AfterUpdate()
Private Sub Subsidised_Assessment_Amount_AfterUpdate()
Private Sub Supporting_Doc_Affidavit__EME__AfterUpdate()
Private Sub Supporting_Doc_BEE_Certificate_AfterUpdate()
Private Sub Supporting_Doc_Certified_ID_Copy_AfterUpdate()
Private Sub Supporting_Doc_CK1_Document_AfterUpdate()
Private Sub Supporting_Doc_EMP201_AfterUpdate()
Private Sub Supporting_Doc_Employee_Payslips_AfterUpdate()
Private Sub Supporting_Doc_IRP5_AfterUpdate()
Private Sub Supporting_Doc_Other_AfterUpdate()
Private Sub Supporting_Doc_Other_Text_AfterUpdate()
Private Sub Supporting_Doc_Proof_of_Turnover_AfterUpdate()
Private Sub Supporting_Doc_Tax_Clearance_Certificate_AfterUpdate()
Private Sub Supporting_Doc_VAT_Registration_AfterUpdate()
Form_SubFrm Sales Brief Selection Selection Criteria ED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Selection Criteria ED.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Selection_Criteria_AfterUpdate()
Form_SubFrm Sales Brief Selection Selection Criteria SD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Selection Criteria SD.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Selection_Criteria_AfterUpdate()
Form_SubFrm Sales Brief Selection Selection Criteria SED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Selection Criteria SED.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Selection_Criteria_AfterUpdate()
Form_SubFrm Sales Brief Selection Selection Criteria SkD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Selection Criteria SkD.txt
Lines: 29
Procedures
Private Sub DeleteRec_Click()
Private Sub Selection_Criteria_AfterUpdate()
Form_SubFrm Sales Brief Selection SkD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection SkD.txt
Lines: 130
Procedures
Private Sub Cohort_Ignition_Qtr_AfterUpdate()
Private Sub Cohort_Ignition_Year_AfterUpdate()
Private Sub Minimum_Companies_Required_AfterUpdate()
Private Sub Principal_Approve_Candidate_AfterUpdate()
Private Sub Principal_Approve_Candidate_Leads_AfterUpdate()
Private Sub Principal_Subsidise_Assessment_Fee_AfterUpdate()
Private Sub Subsidised_Assessment_Amount_AfterUpdate()
Private Sub Supporting_Doc_Affidavit__EME__AfterUpdate()
Private Sub Supporting_Doc_BEE_Certificate_AfterUpdate()
Private Sub Supporting_Doc_Certified_ID_Copy_AfterUpdate()
Private Sub Supporting_Doc_CK1_Document_AfterUpdate()
Private Sub Supporting_Doc_EMP201_AfterUpdate()
Private Sub Supporting_Doc_Employee_Payslips_AfterUpdate()
Private Sub Supporting_Doc_IRP5_AfterUpdate()
Private Sub Supporting_Doc_Other_AfterUpdate()
Private Sub Supporting_Doc_Other_Text_AfterUpdate()
Private Sub Supporting_Doc_Proof_of_Turnover_AfterUpdate()
Private Sub Supporting_Doc_Tax_Clearance_Certificate_AfterUpdate()
Private Sub Supporting_Doc_VAT_Registration_AfterUpdate()
Form_SubFrm Sales Brief Selection Sourced From ED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Sourced From ED.txt
Lines: 34
Procedures
Private Sub DeleteRec_Click()
Private Sub Delivery_Location_ID_AfterUpdate()
Private Sub Delivery_Location_Other_AfterUpdate()
Form_SubFrm Sales Brief Selection Sourced From SD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Sourced From SD.txt
Lines: 35
Procedures
Private Sub DeleteRec_Click()
Private Sub Delivery_Location_ID_AfterUpdate()
Private Sub Delivery_Location_Other_AfterUpdate()
Form_SubFrm Sales Brief Selection Sourced From SED (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Sourced From SED.txt
Lines: 35
Procedures
Private Sub DeleteRec_Click()
Private Sub Delivery_Location_ID_AfterUpdate()
Private Sub Delivery_Location_Other_AfterUpdate()
Form_SubFrm Sales Brief Selection Sourced From SkD (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Selection Sourced From SkD.txt
Lines: 35
Procedures
Private Sub DeleteRec_Click()
Private Sub Delivery_Location_ID_AfterUpdate()
Private Sub Delivery_Location_Other_AfterUpdate()
Form_SubFrm Sales Brief Sub Products (Form)
File: ms_access_files\emerald\Forms\SubFrm Sales Brief Sub Products.txt
Lines: 61
Procedures
Private Sub BBBEE_Pillar_AfterUpdate()
Private Sub DeleteRec_Click()
Private Sub Form_AfterInsert()
Private Sub Number_of_Entrepreneurs_AfterUpdate()
Private Sub Sponsorship_Amount_AfterUpdate()
Private Sub Sub_Product_ID_AfterUpdate()
basRelink (Standard)
File: ms_access_files\emerald\Modules\basRelink.bas
Lines: 562
Procedures
Public Function RelinkODBC() As Boolean
- ⚠️ Contains GoTo statements; High branching (8 If statements); Large procedure (148 lines)
Public Function Update_zstblODBC() As Boolean
- ⚠️ Contains GoTo statements
Public Function RelinkTablesLocal() As Boolean
- ⚠️ Contains GoTo statements
Public Function CompactTablesMain() As Boolean
- ⚠️ Contains GoTo statements
Public Function CompactTablesLocal() As Boolean
- ⚠️ Contains GoTo statements
Public Function TableExists(ByVal pstrTableName As String) As Boolean
- ⚠️ Uses On Error Resume Next
Global (Standard)
File: ms_access_files\emerald\Modules\Global.bas
Lines: 4
Mod Export to Excel (Standard)
File: ms_access_files\emerald\Modules\Mod Export to Excel.bas
Lines: 312
Procedures
Public Sub ExportProposalTATExcel()
- ⚠️ Contains GoTo statements; High branching (14 If statements); Large procedure (310 lines)
Mod Send Outlook Message (Standard)
File: ms_access_files\emerald\Modules\Mod Send Outlook Message.bas
Lines: 53
Procedures
Public Sub SendOutlookMessage(Recip As String, Optional fileName As String, Optional SubText As String, Optional BodyText As String, Optional CCText As String)
Mod Utilities (Standard)
File: ms_access_files\emerald\Modules\Mod Utilities.bas
Lines: 220
Procedures
Public Sub WriteProposalRevisionHistoryRecord(PropID As Long, FldName As String)
Public Sub WriteRevisionHistoryRecord(SalesBr As Long, FldName As String)
Public Function GetXofY(f As Form)
- ⚠️ Uses On Error Resume Next
Public Function IsLoaded(ByVal strFormName As String) As Boolean
Public Function StringsSameCase(X As String, Y As String) As Boolean
Public Function CheckForUpper(CheckString As String)
Public Function CheckForSpecial(CheckString As String)
Public Function CheckForNumber(CheckString As String)
Public Function CalcWorkdays(StartDate, EndDate) As Integer
- ⚠️ Contains GoTo statements
Public Sub ObjectCounts()
Public Sub UpdateMarketing()
Module1 (Standard)
File: ms_access_files\emerald\Modules\Module1.bas
Lines: 1
Module2 (Standard)
File: ms_access_files\emerald\Modules\Module2.bas
Lines: 341
Procedures
Public Sub ExportAllCode()
Public Sub ExportAllCodeToFolder(outputFolder As String, Optional includeQueries As Boolean = True)
Private Function ExportModules(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportForms(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportReports(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportMacros(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportQueries(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportTableSchemas(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function GetFieldTypeName(fieldType As Integer) As String
Private Function SanitizeFileName(fileName As String) As String
Private Sub CreateFolderIfNotExists(folderPath As String)
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function BrowseForFolder(prompt As String) As String
Module3 (Standard)
File: ms_access_files\emerald\Modules\Module3.bas
Lines: 1
SQL Queries
aa1
Type: Select
SELECT [Sales Brief].[Sales Brief ID], [Sales Brief].[Sales Brief Number], [Sales Brief].[Version Number], [Sales Brief].Project, [Sales Brief Status].[Sales Brief Status], [Sales Brief].[Date Created], Count([Sales Brief Selection Marketing].[Sales Brief ID]), Min([Sales Brief Selection Marketing].[BBBEE Pillar]), Min([Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID]), Max([Sales Brief Selection Marketing].[BBBEE Pillar]), Max([Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID]) FROM [Sales Brief], [Sales Brief Selection Marketing], [Sales Brief Status]
aa2
Type: Select
SELECT [Sales Brief].[Sales Brief ID], [Sales Brief].[Sales Brief Number], [Sales Brief].[Version Number], Max([Sales Brief Selection Marketing_1].[Sales Brief Selection Marketing ID]), Max([Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID]), Max([Sales Brief Selection Marketing_2].[Sales Brief Selection Marketing ID]) FROM [Sales Brief], [Sales Brief Selection Marketing], [Sales Brief Selection Marketing], [Sales Brief Selection Marketing] WHERE ((([Sales Brief Selection Marketing_1].[BBBEE Pillar])='ED' Or ([Sales Brief Sel
Find duplicates for Sales Brief Selection Marketing
Type: Select
SELECT [Sales Brief Selection Marketing].[Sales Brief ID], [Sales Brief Selection Marketing].[BBBEE Pillar], [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID] FROM [Sales Brief Selection Marketing] WHERE ((([Sales Brief Selection Marketing].[Sales Brief ID]) In (SELECT [Sales Brief I
JB Check it
Type: Select
SELECT [Sales Brief].[Store Standard Marketing Budget], [Sales Brief].[Sales Brief ID], [Sales Brief].[Sales Brief Status ID], [Sales Brief].[Date Created] FROM [Sales Brief] WHERE ((([Sales Brief].[Store Standard Marketing Budget]) Is Not Null))
JB Convert Delete Extra Records
Type: Select
SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [Sales Brief Selection Marketing Products].[Sales Brief Selection Marketing ID] FROM [Sales Brief Selection Marketing], [Sales Brief Selection Marketing Products]
JB Qry Append Proposal Writers
Type: Delete
SELECT Proposal.[Writer Name], Proposal.[Writer Name Other], Proposal.[Writer Role], Proposal.[Writer Role Other], Proposal.[Proposal ID] FROM [Proposal] WHERE (((Proposal.[Writer Name]) Is Not Null))
JB Qry Append Selection Marketing Products
Type: Delete
SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [Sales Brief Selection Marketing].[Sales Brief ID], [Sales Brief Selection Marketing].[Product ID], [Sales Brief Selection Marketing].[Sponsorship Amount], [Sales Brief Selection Marketing].[BBBEE Pillar] FROM [Sales Brief Selection Marketing]
JB Qry Check Sales Brief Selection Marketing Products
Type: Select
SELECT [Sales Brief Selection Marketing].[Sales Brief ID], [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [Sales Brief Selection Marketing].[BBBEE Pillar], [Sales Brief Selection Marketing].[Minimum Companies Required], [Sales Brief Selection Marketing Products].[Sales Brief Selection Marketing ID], [Sales Brief Selection Marketing Products].[Product ID], [Sales Brief Selection Marketing Products].[Sponsorship Amount], [Sales Brief Selection Marketing Products].[Sales Brief ID] FROM [Sales Brief Selection Marketing], [Sales Brief Selection Marketing Products]
JB Qry Check the conversion
Type: Select
SELECT [Sales Brief].[Date Created], [Principals Sales].Principal, [Sales Brief].[Sales Brief Number], [Sales Brief Selection Marketing].[Sales Brief ID], [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [Sales Brief Selection Marketing].[BBBEE Pillar], [Products Sales_1].Product, [Sales Brief Selection Marketing Products].[Sponsorship Amount], [Sales Brief Selection Marketing Products].[Product ID] FROM [Sales Brief], [Sales Brief Selection Marketing], [Sales Brief Selection Marketing Products], [Products Sales], [Principals Sales]
JB Qry Update Principal Countries
Type: Delete
SELECT [Principals Sales].[Principal ID], [Principals Sales].[Country ID] FROM [Principals Sales] WHERE ((([Principals Sales].[Country ID]) Is Not Null))
JB Qry Update Principal Languages
Type: Delete
SELECT [Principals Sales].[Principal ID], [Principals Sales].Language FROM [Principals Sales] WHERE ((([Principals Sales].Language) Is Not Null))
Qry Application Versions
Type: Select
-- Unable to parse query definition
Qry Calculate Standard Marketing Budget by Sales Brief
Type: Select
SELECT [Qry Sum Total Programme Fee by Sales Brief].[Sales Brief ID], [Qry Sum Total Programme Fee by Sales Brief].[Total Programme Fee], [Sales Brief].[Sales Brief Status ID], IIf(IsNull([Total Programme Fee]),0,[Total Programme Fee])*0.024 FROM [Qry Sum Total Programme Fee by Sales Brief], [Sales Brief] WHERE ((([Sales Brief].[Sales Brief Status ID])=1))
Qry Get Date Sales Brief Submitted to Business
Type: Select
SELECT [Sales Brief Status History].[Sales Brief ID], [Sales Brief Status History].[Sales Brief Status ID], [Sales Brief Status History].[Date Status Changed] FROM [Sales Brief Status History] WHERE ((([Sales Brief Status History].[Sales Brief Status ID])=5))
Qry Get Emerald Users
Type: Select
SELECT DatabaseUsers.Username, DatabaseUsers.[Email Address], DatabaseUsers.Department, [DatabaseUsers Module Permissions].[Module Permission], [DatabaseUsers Module Permissions].LEVEL, [DatabaseUsers Module Permissions].Role FROM [DatabaseUsers], [DatabaseUsers Module Permissions] WHERE ((([DatabaseUsers Module Permissions].[Module Permission])=\"Emerald\"))
Qry Get Principal Marketing Contact by Sales Brief
Type: Select
SELECT [Sales Brief].[Sales Brief ID], [Principals Sales Contacts].[Contact Type ID], [Contact First Name] & \, [Principals Sales Contacts].[Contact Email], [Principals Sales Contacts].[Contact Phone] FROM [Sales Brief], [Principals Sales], [Principals Sales Contacts] WHERE ((([Principals Sales Contacts].[Contact Type ID])=5))
Qry Get Unique Proposal Divisions
Type: Select
SELECT [Proposal Delivery Regions].[Proposal ID], [Divisions Proposal].Division FROM [Proposal Delivery Regions], [Divisions Proposal]
Qry Principal List
Type: Select
SELECT [Principals Sales].[Principal ID], [Principals Sales].Principal, [Principals Sales].[Physical Address 1], [Principals Sales].[Physical Address 2] FROM [Principals Sales]
Qry Product Distribution Models Proposal
Type: Select
SELECT [Product Distribution Models Proposal].[Product Distribution Model ID], [Product Distribution Models Proposal].[Product ID], [Distribution Models Proposal].[Distribution Model] FROM [Product Distribution Models Proposal], [Distribution Models Proposal]
Qry Product Divisions Proposal
Type: Select
SELECT [Product Divisions Proposal].[Product Division ID], [Product Divisions Proposal].[Product ID], [Divisions Proposal].Division FROM [Product Divisions Proposal], [Divisions Proposal]
Qry Product List Proposal
Type: Select
SELECT [Products Proposal].[Product ID], [Products Proposal].Product, IIf([Active]=False,\ FROM [Products Proposal]
Qry Products NOT in Proposal
Type: Select
SELECT [Products Proposal].[Product ID], [Products Proposal].Product, [Products Proposal].Active FROM [SubQry Products NOT in Proposal], [Products Proposal] WHERE ((([Products Proposal].Active)=True) AND (([SubQry Products NOT in Proposal].[Pr
Qry Proposal Delivery Regions List
Type: Select
SELECT [Proposal Delivery Regions].[Delivery Region ID], [Proposal Delivery Regions].[Proposal ID], [Divisions Proposal].Division, [Distribution Models Proposal].[Distribution Model], IIf([Existing or New]=1,\, IIf([Existing or New]=1,[Delivery Location],[New Delivery Location]), [Proposal Delivery Regions].[Geographic Area], [Distribution Models Proposal].[Distribution Model ID] FROM [Proposal Delivery Regions], [Distribution Models Proposal], [Divisions Proposal], [Delivery Locations Sales]
Qry Proposal List
Type: Select
SELECT Proposal.[Proposal ID], Proposal.[Date Created], Proposal.[Version Number], [Principals Sales].Principal, Proposal.[Opportunity Owner], Proposal.[Proposal Status ID], [Proposal Status].[Proposal Status] FROM [Principals Sales], [Proposal], [Proposal Status]
Qry Proposal Product List
Type: Select
SELECT [Proposal Products].[Proposal Products ID], [Proposal Products].[Proposal ID], [Products Proposal].Product, [Proposal Products].[Product ID] FROM [Proposal Products], [Products Proposal]
Qry Proposals Assigned to Principal List
Type: Select
SELECT [Principals Sales].[Principal ID], Proposal.[Date Created], Proposal.[Opportunity Owner], [Proposal Status].[Proposal Status] FROM [Principals Sales], [Proposal], [Proposal Status]
Qry Report Proposal TAT Non Standard
Type: Select
SELECT Proposal.[Proposal ID], Proposal.[Date Created], Proposal.[Proposal Status ID], Proposal.[Proposal Type of Document ID], [Proposal Type of Document LkUp].[Proposal Type of Document], [Principals Sales].Principal, Proposal.[Proposal Brief Completed], Proposal.[Proposal Due Date], Proposal.[Proposal Date Submitted], IIf(IsNull([Proposal Brief Completed]) Or IsNull([Proposal Date Submitted]),Null, [Proposal Type of Document LkUp].[Proposal Max TAT], [Proposal Max TAT]-[Actual TAT], IIf([Proposal Date Submitted]=[Proposal Due Date],\, Proposal.[Opportunity Owner], Proposal.[Proposal Turnaround Time Comments], IIf(IsNull([Total Minutes]),0,[Total Minutes]), IIf(IsNull([Total Minutes]),0,IIf([Total Minutes]<60,[Total Minutes] & \ FROM [Principals Sales], [Proposal], [Proposal Status], [Proposal Type of Document LkUp], [Qry Sum Time Tracker Minutes by Proposal] WHERE (((Proposal.[Proposal Status ID])=8 Or (Proposal.[Proposal Status ID])=9 Or (Pro
Qry Report Proposal TAT Standard
Type: Select
SELECT Proposal.[Date Created], Proposal.[Proposal ID], Proposal.[Proposal Status ID], Proposal.[Proposal Type of Document ID], [Proposal Type of Document LkUp].[Proposal Type of Document], [Principals Sales].Principal, Proposal.[Proposal Brief Completed], Proposal.[Proposal Due Date], Proposal.[Proposal Date Submitted], IIf(IsNull([Proposal Brief Completed]) Or IsNull([Proposal Date Submitted]),Null, [Proposal Type of Document LkUp].[Proposal Max TAT], [Proposal Max TAT]-[Actual TAT], IIf([Proposal Date Submitted]=[Proposal Due Date],\, Proposal.[Opportunity Owner], Proposal.[Proposal Turnaround Time Comments], IIf(IsNull([Total Minutes]),0,[Total Minutes]), IIf(IsNull([Total Minutes]),0,IIf([Total Minutes]<60,[Total Minutes] & \ FROM [Principals Sales], [Proposal], [Proposal Status], [Proposal Type of Document LkUp], [Qry Sum Time Tracker Minutes by Proposal] WHERE (((Proposal.[Proposal Status ID])=8 Or (Proposal.[Proposal Status ID])=9 Or (Pro
Qry Report Sales Brief
Type: Select
SELECT [Sales Brief].[Sales Brief ID], [Sales Brief].[Sales Brief Number], [Sales Brief].[Principal ID], [Sales Brief].[Sales Brief Number], [Sales Brief].[Version Number], [Qry Get Date Sales Brief Submitted to Business].[Date Submitted to Business], [Sales Brief].[Date Created], [Sales Brief Status].[Sales Brief Status], [Sales Brief].[Date Status Changed], [Sales Brief].[Status Modified By], [Sales Brief].[Solutions Architect], [Sales Brief].[Key Account Manager], [Sales Brief].[Sales Manager], [Sales Brief].[Contract Type], [Sales Brief].[Contract Duration], [Sales Brief].[Contract Duration Other], [Sales Brief].[How Lead Generated], [Sales Brief].[Client (Lead Generated)], [Sales Brief].[Conference (Lead Generated)], [Sales Brief].[Solution Architect (Lead Generated)], [Sales Brief].[Marketing Campaign (Lead Generated)], [Sales Brief].[Which Database (Lead Generated)], [Sales Brief].[Raizcorp Management (Lead Generated)], [Sales Brief].[Lead Report Frequency], [Sales Brief].[Verification Agency Name], [Sales Brief].[Principal Verified Date], [Sales Brief].[VA Pack Date], IIf([Non Standard Bookkeeping Process]=1,\, IIf([Efficacy Non Standard Elements]=1,\, IIf([Standard Ignition Apply]=1,\, [Sales Brief].[Ignition Description], [Reporting Frequency].[Reporting Frequency], [Reporting Frequency].[Reporting Frequency Description], IIf(IsNull([Total Programme Fee]),0,[Total Programme Fee]), IIf(IsNull([Total Sub Product Fee]),0,[Total Sub Product Fee]), IIf(IsNull([Total Dist Model Fee]),0,[Total Dist Model Fee]), [Tot Programme Fee]*0.025, IIf(IsNull([Additional Marketing Costs]),0,[Additional Marketing Costs]), IIf(IsNull([Total Stipend Costs]),0,[Total Stipend Costs]), [Tot Programme Fee]+[Tot Sub Product Fee]+[Tot Dist Model Fee]+[Add Marketing Co, [Sales Brief].[Contract Payment Terms], [Sales Brief].[Invoice Day of Month], [Sales Brief].[Invoice Day of Month Other], [Sales Brief].[Once Off Invoice Date], [Sales Brief].[Entity Contracted], [Sales Brief].[Channel Partner], [Sales Brief].[Channel Partner Percentage], [Total Programme Fee]*[Channel Partner Percentage], [Sales Brief].[Channel Partner Approver], [Sales Brief].Notes, [Sales Brief].[Modified By], [Sales Brief].[Date Modified], [Sales Brief].Project, [Sales Brief].[Contract Start Date] FROM [Sales Brief], [Sales Brief Status], [Reporting Frequency], [Qry Sum Total Distribution Model Fees by Sales Brief], [Qry Sum Total Programme Fee by Sales Brief], [Qry Sum Total Extra Sponsor Elements by Sales Brief], [Qry Get Date Sales Brief Submitted to Business], [Qry Sum Total Sub Product Fee by Sales Brief] WHERE ((([Sales Brief].[Sales Brief ID])=[Forms]![Frm Sales Brief List]![SalesBriefLis
Qry Report Writer
Type: Select
SELECT Proposal.[Proposal ID], Proposal.[Date Created], [Principals Sales].Principal, Proposal.[Proposal Status ID], [Proposal Status].[Proposal Status], Proposal.[Proposal Brief Completed], Proposal.[Proposal Date Submitted], Proposal.[Contract Type], [Proposal Type of Document LkUp].[Proposal Type of Document], \, \, \, Proposal.[Budget Amount], Proposal.[Opportunity Owner], \, \, [Delivery Locations Sales].[Delivery Location], Proposal.[Tender Sourcing], IIf(IsNull([Total Minutes]),0,[Total Minutes]), IIf(IsNull([Total Minutes]),0,Round([Total Minutes]/60,2)) FROM [Proposal], [Principals Sales], [Proposal Status], [Proposal Type of Document LkUp], [Delivery Locations Sales], [Qry Sum Time Tracker Minutes by Proposal]
Qry Rpt Sales Brief Past In Progress No Contract Number
Type: Select
SELECT [Sales Brief].[Date Created], [Sales Brief].[Sales Brief ID], [Sales Brief Contract Numbers].[Sales Brief ID], [Sales Brief].[Sales Brief Status ID], [Sales Brief Status].[Sales Brief Status], [Principals Sales].Principal, [Sales Brief].Project, [Sales Brief].[Contract FYE], [Sales Brief].[Verification Year], [Sales Brief].[Contract Start Date] FROM [Sales Brief], [Sales Brief Contract Numbers], [Sales Brief Status], [Principals Sales], [Client Tiers] WHERE ((([Sales Brief Contract Numbers].[Sales Brief ID]) Is Null) AND (Not ([Sales Br
Qry Sales Brief List
Type: Select
SELECT [Sales Brief].[Sales Brief ID], [Sales Brief].[Date Created], [Sales Brief].[Version Number], [Principal] & IIf(Not IsNull([Project]),\, [Sales Brief].[Solutions Architect], [Sales Brief].[Key Account Manager], [Sales Brief].[Sales Brief Status ID], [Sales Brief Status].[Sales Brief Status], [Sales Brief].[Sales Brief Number] FROM [Sales Brief], [Sales Brief Status], [Principals Sales]
Qry Sales Briefs Assigned to Principal List
Type: Select
SELECT [Principals Sales].[Principal ID], [Sales Brief].[Date Created], [Sales Brief].[Solutions Architect], [Sales Brief Status].[Sales Brief Status] FROM [Principals Sales], [Sales Brief], [Sales Brief Status]
Qry SubRpt Corhort Ignition Qty Year by Sales Brief
Type: Select
SELECT [Sales Brief Selection Marketing].[Sales Brief ID], [Sales Brief Selection Marketing].[BBBEE Pillar], [Sales Brief Selection Marketing].[Cohort Ignition Qtr], [Sales Brief Selection Marketing].[Cohort Ignition Year], IIf(Not IsNull([Cohort Ignition Qtr]),[Cohort Ignition Qtr] & \ FROM [Sales Brief Selection Marketing]
Qry SubRpt Extra Sponsor Elements
Type: Select
SELECT [Sales Brief Extra Sponsor Elements].[Sales Brief ID], [Sales Brief Extra Sponsor Elements].[BBBEE Pillar], [Sales Brief Extra Sponsor Elements].[Element Type], [Sales Brief Extra Sponsor Elements].[Sponsorship Amount], [Sales Brief Extra Sponsor Elements].[Admin Fee], [Sales Brief Extra Sponsor Elements].[Number of Entrepreneurs], [Sales Brief Extra Sponsor Elements].[Frequency of Payments], [Sales Brief Extra Sponsor Elements].[Once Off Payment Date], [Sales Brief Extra Sponsor Elements].[Monthly Day of Month], [Sales Brief Extra Sponsor Elements].[Payment Amount] FROM [Sales Brief Extra Sponsor Elements]
Qry SubRpt Finance Distribution Model Type Fees
Type: Select
SELECT [Sales Brief Finance Distribution Model Type Fees].[Sales Brief ID], [Distribution Model Types].[Distribution Model Type], [Distribution Model Types].[Floor Size], [Distribution Model Types].Capacity, [Sales Brief Finance Distribution Model Type Fees].[Set-up Fee], [Sales Brief Finance Distribution Model Type Fees].[Management Fee], [Sales Brief Finance Distribution Model Type Fees].[Operational Expenses] FROM [Sales Brief Finance Distribution Model Type Fees], [Distribution Model Types]
Qry SubRpt Finance Programme Fees
Type: Select
SELECT [Sales Brief Selection Marketing Products].[Sales Brief ID], [Sales Brief Selection Marketing Products].[BBBEE Pillar], [Products Sales].Product, [Sales Brief Selection Marketing Products].[Sponsorship Amount] FROM [Sales Brief Selection Marketing Products], [Products Sales]
Qry SubRpt Principals Sales Contacts
Type: Select
SELECT [Principals Sales Contacts].[Principal ID], [Contact Type LkUp].[Contact Type], [Contact First Name] & \, [Principals Sales Contacts].[Contact Position], [Principals Sales Contacts].[Contact Email], [Principals Sales Contacts].[Contact Phone], [Principals Sales Contacts].[Contact Cell Phone] FROM [Principals Sales Contacts], [Contact Type LkUp]
Qry SubRpt Principals Sales Countries
Type: Select
SELECT [Principals Sales Countries].[Principal ID], CountryLookup.Country FROM [CountryLookup], [Principals Sales Countries]
Qry SubRpt Principals Sales
Type: Select
SELECT [Principals Sales].[Principal ID], [Principals Sales].Principal, [Physical Address 1] & IIf(IsNull([Physical Address 2]),\, [Principals Sales].[Company Website], IndustryLookupSales.Industry, [Principals Sales].[Industry Charter] FROM [Principals Sales], [Client Tiers], [IndustryLookupSales]
Qry SubRpt Sales Brief Marketing
Type: Select
SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [Sales Brief Selection Marketing].[Sales Brief ID], [Sales Brief Selection Marketing].[BBBEE Pillar], IIf([Marketing Campaign Required]=1,\, IIf([Principal Campaign Branded]=1,\, [Qry Get Principal Marketing Contact by Sales Brief].[Marketing Contact Name], [Qry Get Principal Marketing Contact by Sales Brief].[Marketing Contact Email], [Qry Get Principal Marketing Contact by Sales Brief].[Marketing Contact Phone], IIf([Launch Required]=1,\, IIf([Who Arranges Launch]=1,\, [Sales Brief Selection Marketing].[Raizcorp Launch Budget], [Sales Brief Selection Marketing].[Principal Launch Budget], [Sales Brief Selection Marketing].[PR Type], [Sales Brief Selection Marketing].[Info Session Type] FROM [Sales Brief Selection Marketing], [Qry Get Principal Marketing Contact by Sales Brief]
Qry SubRpt Sales Brief Selection Marketing Sourced From
Type: Select
SELECT [Sales Brief Selection Marketing Sourced From].[Sales Brief Selection Marketing , [Delivery Locations Sales].[Delivery Location], [Sales Brief Selection Marketing Sourced From].[Delivery Location Other] FROM [Sales Brief Selection Marketing Sourced From], [Delivery Locations Sales]
Qry SubRpt Sales Brief Selection
Type: Select
SELECT [Sales Brief Selection Marketing].[Sales Brief ID], [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [Sales Brief Selection Marketing].[BBBEE Pillar], [Sales Brief Selection Marketing].[Minimum Companies Required], IIf([Principal Approve Candidate Leads]=1,\, IIf([Principal Approve Candidate]=1,\, IIf([Principal Subsidise Assessment Fee]=1,\, [Sales Brief Selection Marketing].[Subsidised Assessment Amount], IIf(Not IsNull([Cohort Ignition Qtr]),[Cohort Ignition Qtr] & \, IIf([Supporting Doc Affidavit (EME)]=True,\, [Sales Brief Selection Marketing].[Supply Chain Requirement] FROM [Sales Brief Selection Marketing] WHERE ((([Sales Brief Selection Marketing].[Minimum Companies Required]) Is Not Null))
Qry SubRpt Sales Brief Status and Revision History
Type: Select
SELECT [Sales Brief Status History].[Sales Brief Status History ID], [Sales Brief].[Sales Brief Number], [Sales Brief].[Version Number], [Sales Brief Status].[Sales Brief Status], [Sales Brief Status History].[Date Status Changed], [Sales Brief Status History].[Status Modified By], [Sales Brief Status].[Sort Order] FROM [Sales Brief], [Sales Brief Status History], [Sales Brief Status]
Qry SubRpt Sub Products
Type: Select
SELECT [Sales Brief Sub Products].[Sales Brief ID], [Sales Brief Sub Products].[BBBEE Pillar], [Sub Products Sales].[Sub Product], [Sales Brief Sub Products].[Sponsorship Amount], [Sales Brief Sub Products].[Number of Entrepreneurs], [Sales Brief Sub Products].Frequency FROM [Sales Brief Sub Products], [Sub Products Sales]
Qry Sum Time Tracker Minutes by Proposal
Type: Select
SELECT [Proposal Time Tracking].[Proposal ID], Sum([Proposal Time Tracking].[Time Tracking Time]) FROM [Proposal Time Tracking]
Qry Sum Total Distribution Model Fees by Sales Brief
Type: Select
SELECT [Sales Brief Finance Distribution Model Type Fees].[Sales Brief ID], Sum(IIf(IsNull([Set-up Fee]),0,[Set-up Fee])+IIf(IsNull([Management Fee]),0,[Man FROM [Sales Brief Finance Distribution Model Type Fees]
Qry Sum Total Extra Sponsor Elements by Sales Brief
Type: Select
SELECT [Sales Brief Extra Sponsor Elements].[Sales Brief ID], Sum([Sales Brief Extra Sponsor Elements].[Sponsorship Amount]) FROM [Sales Brief Extra Sponsor Elements]
Qry Sum Total Programme Fee by Sales Brief
Type: Select
SELECT [Sales Brief Selection Marketing Products].[Sales Brief ID], Sum([Sales Brief Selection Marketing Products].[Sponsorship Amount]) FROM [Sales Brief Selection Marketing Products]
Qry Sum Total Sub Product Fee by Sales Brief
Type: Select
SELECT [Sales Brief Sub Products].[Sales Brief ID], Sum([Sales Brief Sub Products].[Sponsorship Amount]) FROM [Sales Brief Sub Products]
qryLinkODBC
Type: Select
SELECT zstblODBC_db.Driver, zstblODBC_db.ServerName, zstblODBC_db.DBName, zstblODBC_db.Authentication, zstblODBC_db.UID, zstblODBC_db.PWD, zstblODBC_tables.Hidden, zstblODBC_tables.TableName, zstblODBC_tables.SourceTableName, zstblODBC_tables.AfterDDL FROM [zstblODBC_db], [zstblODBC_tables] WHERE (((zstblODBC_db.SelectDB)=True) AND ((zstblODBC_tables.Link)=True))
SubQry Products NOT in Proposal
Type: Select
SELECT [Proposal Products].[Proposal ID], [Proposal Products].[Product ID] FROM [Proposal Products] WHERE ((([Proposal Products].[Proposal ID])=[Forms]![Frm Add and Edit Proposal Product