garnet - Implementation Details

VBA Modules

Form_Add and Edit Company Programme Year Status (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Company Programme Year Status.txt Lines: 20

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Company Programme Year (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Company Programme Year.txt Lines: 151

Procedures

Private Sub AddPrincipalProject_Click()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Contract_Start_Date_AfterUpdate()

Private Sub EditProgrammeYearStatus_Click()

Private Sub Form_BeforeInsert(Cancel As Integer)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer) - ⚠️ High branching (6 If statements)

Private Sub Programme_Year_AfterUpdate() - ⚠️ Uses SendKeys

Private Sub Total_Programme_Amount_AfterUpdate()

Form_Add and Edit Company Status (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Company Status.txt Lines: 20

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Entrepreneur Company Sub Products (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Entrepreneur Company Sub Products.txt Lines: 23

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_Add and Edit Entrepreneur Company (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Entrepreneur Company.txt Lines: 54

Procedures

Private Sub Brief_Description_of_Business_AfterUpdate()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Form_Add and Edit Non Graduate Reason (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Non Graduate Reason.txt Lines: 70

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 Primary Tenant (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Primary Tenant.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 Principal Project (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Principal Project.txt Lines: 39

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Add and Edit Principal (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Principal.txt Lines: 29

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Add and Edit Replacement Status (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Replacement Status.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 Secondary Tenant (Form)

File: ms_access_files\garnet\Forms\Frm Add and Edit Secondary Tenant.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 Company Extra Sponsor Element (Form)

File: ms_access_files\garnet\Forms\Frm Add Company Extra Sponsor Element.txt Lines: 43

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Private Sub Principal_Project_Pillar_Sponsor_Element_ID_AfterUpdate()

Form_Add Company Monthly Billing (Form)

File: ms_access_files\garnet\Forms\Frm Add Company Monthly Billing.txt Lines: 35

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Entrepreneur_Company_Principal_Project_ID_AfterUpdate()

Private Sub Form_Close()

Form_Certificate Mail Merge (Form)

File: ms_access_files\garnet\Forms\Frm Certificate Mail Merge.txt Lines: 301

Procedures

Public Sub UpdateNumber()

Private Sub DeleteRecs_Click()

Private Sub DoTheExport_Click() - ⚠️ Contains GoTo statements; High branching (9 If statements); Large procedure (198 lines)

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Change Password (Form)

File: ms_access_files\garnet\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_Company Add Allocation List (Form)

File: ms_access_files\garnet\Forms\Frm Company Add Allocation List.txt Lines: 195

Procedures

Public Sub CalculatePartialMonthlyBillingAmount()

Private Sub Allocated_Amount_AfterUpdate()

Private Sub AllocateFrom_AfterUpdate()

Private Sub ClearFilters_Click()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Private Sub ReplacementList_AfterUpdate()

Private Sub StrCriteria1_AfterUpdate()

Private Sub UseThisPrincipalProject_Click()

Form_Company Graduating List (Form)

File: ms_access_files\garnet\Forms\Frm Company Graduating List.txt Lines: 216

Procedures

Public Sub UpdateList() - ⚠️ High branching (10 If statements)

Private Sub ClearFilters_Click()

Private Sub CompanyList_DblClick(Cancel As Integer)

Private Sub CompanyList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Dashboards_AfterUpdate() - ⚠️ High branching (12 If statements)

Private Sub Filter1_AfterUpdate()

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Form_Company Ignition List (Form)

File: ms_access_files\garnet\Forms\Frm Company Ignition List.txt Lines: 216

Procedures

Public Sub UpdateList() - ⚠️ High branching (10 If statements)

Private Sub ClearFilters_Click()

Private Sub CompanyList_DblClick(Cancel As Integer)

Private Sub CompanyList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Dashboards_AfterUpdate() - ⚠️ High branching (12 If statements)

Private Sub Filter1_AfterUpdate()

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Form_Company List (Form)

File: ms_access_files\garnet\Forms\Frm Company List.txt Lines: 236

Procedures

Public Sub UpdateList() - ⚠️ High branching (10 If statements)

Private Sub ClearFilters_Click()

Private Sub CloseFOrm_Click()

Private Sub CompanyList_AfterUpdate()

Private Sub CompanyList_DblClick(Cancel As Integer)

Private Sub CompanyStatus_AfterUpdate()

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Dashboards_AfterUpdate() - ⚠️ High branching (12 If statements)

Private Sub Filter1_AfterUpdate()

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub MaintenanceFunction_Click()

Private Sub MonthlyBillingsFunction_Click()

Private Sub PrincipalProjectList_DblClick(Cancel As Integer)

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Form_Company On Programme List (Form)

File: ms_access_files\garnet\Forms\Frm Company On Programme List.txt Lines: 218

Procedures

Public Sub UpdateList() - ⚠️ High branching (10 If statements)

Private Sub ClearFilters_Click()

Private Sub CompanyList_DblClick(Cancel As Integer)

Private Sub CompanyList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Dashboards_AfterUpdate() - ⚠️ High branching (12 If statements)

Private Sub EntrepreneurStatus_AfterUpdate()

Private Sub Filter1_AfterUpdate()

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Form_Company Raizcorpossible List (Form)

File: ms_access_files\garnet\Forms\Frm Company Raizcorpossible List.txt Lines: 191

Procedures

Public Sub UpdateList() - ⚠️ High branching (7 If statements)

Private Sub ClearFilters_Click()

Private Sub CloseFOrm_Click()

Private Sub CompanyList_DblClick(Cancel As Integer)

Private Sub CompanyStatus_AfterUpdate()

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Dashboards_AfterUpdate() - ⚠️ High branching (12 If statements)

Private Sub Filter1_AfterUpdate()

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub LumpSumAllocation_Click()

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Form_Contract Mail Merge (Form)

File: ms_access_files\garnet\Forms\Frm Contract Mail Merge.txt Lines: 401

Procedures

Public Sub UpdateNumber()

Private Sub DeleteRecs_Click()

Private Sub DoTheExport_Click() - ⚠️ Contains GoTo statements; Large procedure (296 lines)

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Delivery vs Exited Report Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Delivery vs Exited Report Dialog.txt Lines: 49

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Edit Company Allocation (Form)

File: ms_access_files\garnet\Forms\Frm Edit Company Allocation.txt Lines: 160

Procedures

Private Sub AddExtraSponsor_Click()

Private Sub AddProgrammeYear_Click()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Company_Delivery_Location_ID_AfterUpdate()

Private Sub EditCompany_Click()

Private Sub EditCompanyStatus_Click()

Private Sub ExtraSponsorList_DblClick(Cancel As Integer)

Private Sub ExtraSponsorList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Private Sub PrincipalProjectList_DblClick(Cancel As Integer)

Private Sub PrincipalProjectList_KeyDown(KeyCode As Integer, Shift As Integer) - ⚠️ High branching (6 If statements)

Form_Edit Company Extra Sponsor Element (Form)

File: ms_access_files\garnet\Forms\Frm Edit Company Extra Sponsor Element.txt Lines: 49

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Edit Company Monthly Billing (Form)

File: ms_access_files\garnet\Forms\Frm Edit Company Monthly Billing.txt Lines: 25

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Form_Edit Company Programme Year Status (Form)

File: ms_access_files\garnet\Forms\Frm Edit Company Programme Year Status.txt Lines: 167

Procedures

Private Sub Break_Start_AfterUpdate()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Company_Programme_Year_Status_ID_AfterUpdate() - ⚠️ High branching (8 If statements)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Edit Company Status (Form)

File: ms_access_files\garnet\Forms\Frm Edit Company Status.txt Lines: 130

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Company_Status_ID_AfterUpdate() - ⚠️ Uses SendKeys

Private Sub Form_Open(Cancel As Integer)

Private Sub Override_Status_Rules_AfterUpdate()

Form_Edit Email Recipient List (Form)

File: ms_access_files\garnet\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_Lump Sum Allocation Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Lump Sum Allocation Dialog.txt Lines: 79

Procedures

Private Sub Form_Close()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Lump Sum Allocation (Form)

File: ms_access_files\garnet\Forms\Frm Lump Sum Allocation.txt Lines: 246

Procedures

Public Sub UpdateNumber()

Private Sub DeleteRecs_Click()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub DoTheAllocation_Click() - ⚠️ Contains GoTo statements; High branching (16 If statements); Large procedure (169 lines)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Maintenance Menu (Form)

File: ms_access_files\garnet\Forms\Frm Maintenance Menu.txt Lines: 53

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub CompanyStatus_Click()

Private Sub CompanyYearStatus_Click()

Private Sub EmailRecipientList_Click()

Private Sub NonGraduateReason_Click()

Private Sub PrimaryTenants__PrimaryTenants__PrimaryTenants_Click()

Private Sub Principals_Click()

Private Sub ReplacementStatus_Click()

Private Sub SecondaryTenants_Click()

Form_Monthly Billings Date Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Monthly Billings Date Dialog.txt Lines: 85

Procedures

Public Sub PopulateTempEntrepreneurCompanyMonthlyBillings()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Monthly Billings Menu (Form)

File: ms_access_files\garnet\Forms\Frm Monthly Billings Menu.txt Lines: 30

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub GenerateMonthlyBillings_Click()

Private Sub ViewEditMonthlyBillings_Click()

Form_Monthly Billings (Form)

File: ms_access_files\garnet\Forms\Frm Monthly Billings.txt Lines: 203

Procedures

Public Sub UpdateNumber()

Private Sub DeleteRecs_Click()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub ExportMonthlyBillings_Click()

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Private Sub GenerateMonthlyBillings_Click() - ⚠️ Contains GoTo statements

Form_Opal Scorecard Report Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Opal Scorecard Report Dialog.txt Lines: 581

Procedures

Private Sub PopulateTempTable() - ⚠️ High branching (6 If statements); Large procedure (155 lines)

Public Sub ExportOpalScorecardToExcel() - ⚠️ Contains GoTo statements; High branching (15 If statements); Large procedure (379 lines)

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Opening Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Opening Dialog.txt Lines: 160

Procedures

Private Sub CancelButton_Click()

Private Sub Form_Open(Cancel As Integer)

Private Sub Password_AfterUpdate() - ⚠️ High branching (7 If statements)

Private Sub Username_AfterUpdate()

Form_Part Sponsorship History Reports Date Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Part Sponsorship History Reports Date Dialog.txt Lines: 50

Procedures

Private Sub Form_Close()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Principal List (Form)

File: ms_access_files\garnet\Forms\Frm Principal List.txt Lines: 104

Procedures

Public Sub UpdateList()

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)

Private Sub PrincipalProjectList_DblClick(Cancel As Integer)

Private Sub PrincipalProjectList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub StrCriteria1_AfterUpdate()

Form_Principal Project List (Form)

File: ms_access_files\garnet\Forms\Frm Principal Project List.txt Lines: 183

Procedures

Public Sub UpdateList()

Private Sub ClearFilters_Click()

Private Sub CloseFOrm_Click()

Private Sub CompanyList_AfterUpdate()

Private Sub CompanyList_DblClick(Cancel As Integer)

Private Sub CompanyStatus_AfterUpdate()

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Dashboards_AfterUpdate() - ⚠️ High branching (12 If statements)

Private Sub Filter1_AfterUpdate()

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub PrincipalProjectList_AfterUpdate()

Private Sub PrincipalProjectList_DblClick(Cancel As Integer)

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Form_Principal Project Status Report Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Principal Project Status Report Dialog.txt Lines: 45

Procedures

Private Sub Form_Close()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Principal Report Date Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Principal Report Date Dialog.txt Lines: 61

Procedures

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_Report Menu (Form)

File: ms_access_files\garnet\Forms\Frm Report Menu.txt Lines: 728

Procedures

Public Sub ExportCompanyList(TheWhereStr As String) - ⚠️ Contains GoTo statements; High branching (7 If statements)

Public Sub ExportCompanyIgnitionList(TheWhereStr As String) - ⚠️ Contains GoTo statements; Large procedure (121 lines)

Public Sub ExportCompanyRaizcorpossiblesList(TheWhereStr As String) - ⚠️ Contains GoTo statements

Public Sub ExportCompanyOnProgrammeList(TheWhereStr As String) - ⚠️ Contains GoTo statements; Large procedure (119 lines)

Public Sub ExportCompanyGraduatingList(TheWhereStr As String) - ⚠️ Contains GoTo statements

Private Sub ActiveEntrepreneurEmailReport_Click()

Private Sub ActiveEntrpreneursbyProsperator_Click()

Private Sub CertificateMailMergeExport_Click()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Companies_Needs_Replacement_Report_Click()

Private Sub CompaniesAllocated_Click()

Private Sub CompaniesIgnitedbyProduct_Click()

Private Sub CompaniesLeftProgramme_Click()

Private Sub CompaniesNeedToBeAllocated_Click()

Private Sub CompaniesStartedProgramme_Click()

Private Sub CompanyTotalsbyProsperator_Click()

Private Sub ContractMailMergeExport_Click()

Private Sub DeliveryVsExited_Click()

Private Sub EntrepreneurListReport_Click()

Private Sub ESDPrincipalSpendLetter_Click()

Private Sub ExportNewAllocationReport_Click()

Private Sub FinanceMonthlyReport_Click()

Private Sub Form_Open(Cancel As Integer)

Private Sub OpalScorecardA_Click()

Private Sub PartSponsorshipHistoryExport_Click()

Private Sub PreBillingExceptionReport_Click()

Private Sub Principal_Project_Allocation_Audit_Report_Click()

Private Sub PrincipalProjectAllocationReport_Click()

Private Sub PrincipalProjectAllocationReportFinance_Click()

Private Sub PrincipalProjectFinanceAuditReport_Click()

Private Sub PrincipalProjectTotalsbyProsperator_Click()

Private Sub QuarterlyPrincipalReport_Click()

Private Sub RAG_Report_Click()

Private Sub RaizcorpPossibilitiesReport_Click()

Private Sub ReportWriter_Click()

Private Sub SDAllocationsNotNotifiedSDMandSA_Click()

Private Sub SummarisedDeferredIncome_Click()

Form_Report Writer Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Report Writer Dialog.txt Lines: 321

Procedures

Public Sub ExportTheReport() - ⚠️ Contains GoTo statements; High branching (23 If statements); Large procedure (183 lines)

Private Sub ClearFilters_Click()

Private Sub Filter1_AfterUpdate() - ⚠️ High branching (6 If statements)

Private Sub Filter2_AfterUpdate() - ⚠️ High branching (6 If statements)

Private Sub Form_Close()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Date Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Reports Date Dialog.txt Lines: 56

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements; High branching (6 If statements)

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Print Export Dialog (Form)

File: ms_access_files\garnet\Forms\Frm Reports Print Export Dialog.txt Lines: 44

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_View and Edit Monthly Billings (Form)

File: ms_access_files\garnet\Forms\Frm View and Edit Monthly Billings.txt Lines: 89

Procedures

Public Sub UpdateList()

Private Sub AddMonthlyBilling_Click()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub CompanyList_DblClick(Cancel As Integer)

Private Sub CompanyList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Filter1_AfterUpdate()

Private Sub Form_Close()

Form_SubFrm Edit Company Principal Project (Form)

File: ms_access_files\garnet\Forms\SubFrm Edit Company Principal Project.txt Lines: 297

Procedures

Private Sub Allocated_Amount_AfterUpdate() - ⚠️ High branching (6 If statements)

Private Sub DeletePrincipalProject_Click() - ⚠️ High branching (9 If statements)

Private Sub Form_Current()

Private Sub Lump_Sum_Allocation_AfterUpdate()

Private Sub Monthly_Allocated_Amount_AfterUpdate()

Private Sub NextRecord_Click() - ⚠️ Contains GoTo statements

Private Sub PrevRecord_Click() - ⚠️ Contains GoTo statements

Private Sub Replacement_Status_AfterUpdate()

Private Sub Replacement_Status_BeforeUpdate(Cancel As Integer) - ⚠️ Uses SendKeys

Private Sub Selection_Fee_AfterUpdate()

Private Sub Selection_Fee_Type_AfterUpdate()

Form_SubFrm Entrepreneur Company Areas of Operation (Form)

File: ms_access_files\garnet\Forms\SubFrm Entrepreneur Company Areas of Operation.txt Lines: 41

Procedures

Private Sub DeleteRec_Click()

Private Sub Form_BeforeUpdate(Cancel As Integer)

Form_SubFrm Entrepreneur Company Commodities (Form)

File: ms_access_files\garnet\Forms\SubFrm Entrepreneur Company Commodities.txt Lines: 41

Procedures

Private Sub DeleteRec_Click()

Private Sub Form_BeforeUpdate(Cancel As Integer)

Form_SubFrm Entrepreneur Company Extra Sponsor Payments (Form)

File: ms_access_files\garnet\Forms\SubFrm Entrepreneur Company Extra Sponsor Payments.txt Lines: 22

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm Principal Project Pillar Sponsor Elements (Form)

File: ms_access_files\garnet\Forms\SubFrm Principal Project Pillar Sponsor Elements.txt Lines: 32

Procedures

Private Sub DeleteRec_Click()

Private Sub Element_Type_AfterUpdate()

Private Sub Form_BeforeInsert(Cancel As Integer)

Private Sub Sponsorship_Amount_AfterUpdate()

Form_SubFrm Principal Project Pillar Sub Products (Form)

File: ms_access_files\garnet\Forms\SubFrm Principal Project Pillar Sub Products.txt Lines: 24

Procedures

Private Sub DeleteRec_Click()

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_SubFrm Principal Project Pillars (Form)

File: ms_access_files\garnet\Forms\SubFrm Principal Project Pillars.txt Lines: 50

Procedures

Private Sub AddPillar_Click()

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Form_SubFrm Total Billed To Date by Company PP (Form)

File: ms_access_files\garnet\Forms\SubFrm Total Billed To Date by Company PP.txt Lines: 20

Procedures

Private Sub DeleteRec_Click()

basRelink (Standard)

File: ms_access_files\garnet\Modules\basRelink.bas Lines: 604

Procedures

Public Function RelinkODBC() As Boolean - ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (153 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

Public Sub PopulateTableList() - ⚠️ Contains GoTo statements

Mod Export Excel (Standard)

File: ms_access_files\garnet\Modules\Mod Export Excel.bas Lines: 5938

Procedures

Public Sub ExportRaizcorpPossibilitiesToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (9 If statements); Large procedure (845 lines)

Public Sub ExportPrincipalProjectTotalsByDeliveryMethodExcel() - ⚠️ Contains GoTo statements

Public Sub ExportCompanyTotalsByDeliveryMethodExcel() - ⚠️ Contains GoTo statements

Public Sub ExportPrincipalProjectProductTotalsByDeliveryLocationExcel() - ⚠️ Contains GoTo statements; Large procedure (131 lines)

Public Sub ExportPrincipalProjectAllocationToExcel() - ⚠️ Contains GoTo statements; High branching (15 If statements); Large procedure (270 lines)

Public Sub ExportPrincipalProjectAllocationFinanceToExcel() - ⚠️ Contains GoTo statements; High branching (42 If statements); Large procedure (1006 lines)

Public Sub ExportRAGToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (19 If statements); Large procedure (393 lines)

Public Sub ExportActiveEntrepreneursDeliveryMethod(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (145 lines)

Public Sub ExportNewAllocationToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (31 If statements); Large procedure (493 lines)

Public Sub ExportActiveEntrepreneurEmailReportToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (8 If statements); Large procedure (238 lines)

Public Sub ExportDeliveryVsExitedSummaryToExcel() - ⚠️ Contains GoTo statements

Public Sub ExportPrincipalQuarterlyReportsToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (6 If statements); Large procedure (152 lines)

Public Sub ExportCompaniesLeftProgrammeToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (139 lines)

Public Sub ExportCompanyNeedsReplacementToExcel() - ⚠️ Contains GoTo statements; Large procedure (106 lines)

Public Sub ExportSummarisedDeferredIncomeExcel() - ⚠️ Contains GoTo statements; Large procedure (158 lines)

Public Sub ExportPreBillingExceptionReportToExcel() - ⚠️ Contains GoTo statements; Large procedure (112 lines)

Public Sub ExportCompaniesStartedProgrammeToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (131 lines)

Public Sub ExportCompaniesAllocatedToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (135 lines)

Public Sub ExportCompaniesNeedToBeAllocatedToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (106 lines)

Public Sub ExportPrincipalProjectFinanceAuditToExcel() - ⚠️ Contains GoTo statements; High branching (43 If statements); Large procedure (979 lines)

Public Sub ExportNumberCompaniesIgnitedbyProductToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements

Public Function Nz(value, replacement As Variant) As Variant

Mod Send Outlook Message (Standard)

File: ms_access_files\garnet\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\garnet\Modules\Mod Utilities.bas Lines: 140

Procedures

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 Sub DeleteImportErrorTables()

Public Sub ObjectCounts()

SQL Queries

JB Check Company Allocations

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Principal Projects].[Replacement Status], [Entrepreneur Company Principal Projects].[Replaced By], [Entrepreneur Company Principal Projects].[Replacement For], [Entrepreneur Company Principal Projects].[Allocated Amount], [Principal Project Pillars].[BBBEE Pillar], [Principal Projects].[Project Name], Principals.Principal FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals] WHERE ((([Entrepreneur Company].[Entrepreneur Company ID])=17153))

JB Issue with Monthly Billings

Type: Select

SELECT [Entrepreneur Company Monthly Billings].[Entrepreneur Company Billings ID], [Entrepreneur Company Monthly Billings].[Principal Project Pillar ID], [Entrepreneur Company Monthly Billings].[Billing Date], [Entrepreneur Company Monthly Billings].[Billing Amount], [Entrepreneur Company].[Company Name], [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Monthly Billings].[Entrepreneur Company Principal Project , [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], [Entrepreneur Company Principal Projects].[Date Allocation Created], [Principal Project Pillars_1].[BBBEE Pillar], [Principal Projects].[Project Name], Principals.Principal FROM [Entrepreneur Company Monthly Billings], [Principal Project Pillars], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [Entrepreneur Company Programme Years], [Entrepreneur Company] WHERE ((([Principal Project Pillars].[Principal Project Pillar ID]) Is Null))

JB Qry Reverse Sept Monthly Billings

Type: Select

SELECT [Entrepreneur Company Monthly Billings].[Entrepreneur Company Billings ID], [Entrepreneur Company Monthly Billings].[Billing Date], [Entrepreneur Company Monthly Billings].[Billing Amount], [Principal] & \, [Entrepreneur Company].[Company Name], [Entrepreneur Company Programme Years].[Ignition Date], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], [Entrepreneur Company Programme Years].[Date Status Changed] FROM [Entrepreneur Company Monthly Billings], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years], [Entrepreneur Company], [Principal Project Pillars], [Principal Projects], [Principals] WHERE ((([Entrepreneur Company Monthly Billings].[Billing Date])=#9/30/2022#) AND (([E

Qry Add Allocation Principal Project List

Type: Select

-- Unable to parse query definition

Qry Application Versions

Type: Select

SELECT dbo_ApplicationVersions.[Application], dbo_ApplicationVersions.[Version] FROM [dbo_ApplicationVersions]

Qry Calcluate Extra Sponsor Element Amount Remaining

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], [Principal] & \, [Principal Project Pillar Sponsor Elements].[Principal Project Pillar Sponsor El, [Principal Project Pillar Sponsor Elements].[Element Type], [Principal Project Pillar Sponsor Elements].[Frequency of Payments], [Principal Project Pillar Sponsor Elements].[Payment Amount], [Principal Project Pillar Sponsor Elements].[Sponsorship Amount], IIf([Admin Fee]=0,[Sponsorship Amount],Int([Sponsorship Amount]/(1+[Admin Fee])), IIf(IsNull([Total Allocated]),0,[Total Allocated]), [Sponsorship Available]-[Tot Allocated] FROM [Principal Project Pillar Sponsor Elements], [Qry Sum Extra Sponsor Element Allocated], [Principal Project Pillars], [Principal Projects], [Principals]

Qry Company Entrepreneur Ignition List

Type: Select

SELECT vwGarnetCompanyEntrepreneurIgnitionList.[Entrepreneur Company ID], [First Name] & \, vwGarnetCompanyEntrepreneurIgnitionList.[Company Name], vwGarnetCompanyEntrepreneurIgnitionList.[Delivery Location], vwGarnetCompanyEntrepreneurIgnitionList.Status, [Principal] & ' - ' & [Project Name], vwGarnetCompanyEntrepreneurIgnitionList.Product, vwGarnetCompanyEntrepreneurIgnitionList.[Programme Year], vwGarnetCompanyEntrepreneurIgnitionList.[Ignition Date], vwGarnetCompanyEntrepreneurIgnitionList.Industry, vwGarnetCompanyEntrepreneurIgnitionList.[Committment Fee], vwGarnetCompanyEntrepreneurIgnitionList.[Date Contract Signed], vwGarnetCompanyEntrepreneurIgnitionList.OwnedBy, vwGarnetCompanyEntrepreneurIgnitionList.[Email Address], vwGarnetCompanyEntrepreneurIgnitionList.[Telephone Number], vwGarnetCompanyEntrepreneurIgnitionList.[Second Telephone Number] FROM [vwGarnetCompanyEntrepreneurIgnitionList]

Qry Company List

Type: Select

SELECT vwGarnetCompanyList.[Entrepreneur Company ID], vwGarnetCompanyList.[Company Name], vwGarnetCompanyList.[Company Delivery Location ID], vwGarnetCompanyList.[Delivery Location], vwGarnetCompanyList.[Company Status ID], vwGarnetCompanyList.Status, vwGarnetCompanyList.[Sort Order], vwGarnetCompanyList.[Status Change] FROM [vwGarnetCompanyList]

Qry Company Lump Sum Allocation List

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Delivery Locations].[Delivery Location], CompanyStatus.Status, Products.Product FROM [Temp Entrepreneur Company ID for Lump Sum Allocation], [Entrepreneur Company], [Delivery Locations], [CompanyStatus], [Products]

Qry Company Monthly Billing List Temp

Type: Select

SELECT [Temp Entrepreneur Company Monthly Billings].[Entrepreneur Company Principal Pro, [Entrepreneur Company].[Company Name], [Delivery Locations].[Delivery Location], [Principal] & \, [Principal Project Pillars].[BBBEE Pillar], [Temp Entrepreneur Company Monthly Billings].[Billing Amount], Round(IIf(IsNull([Total Billed]),0,[Total Billed]),2), Round([Allocated Amount]-Round(IIf(IsNull([Total Billed]),0,[Total Billed]),2),2 FROM [Temp Entrepreneur Company Monthly Billings], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years], [Entrepreneur Company], [Delivery Locations], [Principal Project Pillars], [Principal Projects], [Principals], [Qry Sum Total Billed by Company PP and Project Pillar]

Qry Company Monthly Billing List

Type: Select

SELECT [Entrepreneur Company Monthly Billings].[Entrepreneur Company Billings ID], [Entrepreneur Company Monthly Billings].[Principal Project Pillar ID], [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Delivery Locations].[Delivery Location], [Entrepreneur Company Programme Years].[Programme Year], [Principal] & \, [Principal Project Pillars].[BBBEE Pillar], [Entrepreneur Company Monthly Billings].[Billing Date], [Entrepreneur Company Monthly Billings].[Billing Amount] FROM [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years], [Entrepreneur Company], [Delivery Locations], [Principal Project Pillars], [Principal Projects], [Principals], [Entrepreneur Company Monthly Billings]

Qry Company Needs Replacement List

Type: Select

SELECT [SubQry Company Needs Replacement List].[Entrepreneur Company Principal Project , [SubQry Company Needs Replacement List].[Principal Project Pillar ID], [SubQry Company Needs Replacement List].[Replacement Status], [SubQry Company Needs Replacement List].[Company Name], [SubQry Company Needs Replacement List].[Principal Project], [SubQry Company Needs Replacement List].[BBBEE Pillar], [SubQry Company Needs Replacement List].[Allocated Amount], Round([Total Billed]), Nz(Round([Total Replacement Amount]),0)+Nz(Round([Total Selection Fee]),0), IIf(IsNull([TotalBilled]),0,[TotalBilled]), [Allocated Amount]-IIf(IsNull([TotalBilled]),0,[TotalBilled])-[TotalAllocated] FROM [SubQry Company Needs Replacement List], [Qry Sum Total Billed by Company PP and Project Pillar], [Qry Sum Replacement Amount Allocated by Replacement For]

Qry Company Principal Project List

Type: Select

SELECT vwGarnetCompanyPrincipalProjectList.[Entrepreneur Company ID], vwGarnetCompanyPrincipalProjectList.[Principal Project ID], vwGarnetCompanyPrincipalProjectList.[Company Name], vwGarnetCompanyPrincipalProjectList.[Company Delivery Location ID], vwGarnetCompanyPrincipalProjectList.[Delivery Location], vwGarnetCompanyPrincipalProjectList.[Company Status ID], vwGarnetCompanyPrincipalProjectList.[Company Programme Year Status ID], vwGarnetCompanyPrincipalProjectList.Status, vwGarnetCompanyPrincipalProjectList.[Programme Year Status], [Principal] & ' - ' & [Project Name], vwGarnetCompanyPrincipalProjectList.[Sort Order], vwGarnetCompanyPrincipalProjectList.[Year Status Change], vwGarnetCompanyPrincipalProjectList.[Status Change], vwGarnetCompanyPrincipalProjectList.[Ignition Date], vwGarnetCompanyPrincipalProjectList.Product, vwGarnetCompanyPrincipalProjectList.[Programme Year], vwGarnetCompanyPrincipalProjectList.Industry, vwGarnetCompanyPrincipalProjectList.[Contract Start Date] FROM [vwGarnetGetEPReadyforAllocationInfobyCompany], [vwGarnetCompanyPrincipalProjectList]

Qry Company Raizcorpossibles List

Type: Select

SELECT vwGarnetCompanyRaizcorpossiblesList.[Entrepreneur Company ID], vwGarnetCompanyRaizcorpossiblesList.[Process Status ID], vwGarnetCompanyRaizcorpossiblesList.[Company Name], vwGarnetCompanyRaizcorpossiblesList.[Company Delivery Location ID], vwGarnetCompanyRaizcorpossiblesList.[Company Status ID], vwGarnetCompanyRaizcorpossiblesList.Status, vwGarnetCompanyRaizcorpossiblesList.[Delivery Location], vwGarnetCompanyRaizcorpossiblesList.[Sort Order], vwGarnetCompanyRaizcorpossiblesList.[Status Change], [First Name] & \, vwGarnetCompanyRaizcorpossiblesList.Division, vwGarnetCompanyRaizcorpossiblesList.[Distribution Model], [Principal] & \, vwGarnetCompanyRaizcorpossiblesList.[Recommended Product] FROM [vwGarnetCompanyRaizcorpossiblesList]

Qry Count Active Allocated Companies by Principal Project Pillar

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com

Qry Count Companies by Principal Project Allocation Report

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], [Principal Project Pillars].[BBBEE Pillar], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Entrepreneur Company] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com

Qry Count Current Blank Year Companies by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])<>2 And ([Entrepreneur Company].[C

Qry Count Current Blank Year Entrepreneurs by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])<>2 And ([Entrepreneur Company].[C

Qry Count Current Future Year Companies by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=6)

Qry Count Current Future Year Entrepreneurs by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=6)

Qry Count Current Graduated Companies by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=2 

Qry Count Current Graduated Entrepreneurs by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=2 

Qry Count Current On Programme Companies by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=1)

Qry Count Current On Programme EPs by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=1)

Qry Count Exited Companies by Principal Project Pillar

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=2 

Qry Count Exited Need Replacement by Principal Project Pillar

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Count([Entrepreneur Company].[Entrepreneur Company ID]), [Entrepreneur Company Programme Years].[Company Programme Year Status ID] FROM [Entrepreneur Company], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status])=\"Needs Repla

Qry Count Number Months Billed by Company PP and Project Pillar

Type: Select

SELECT [Entrepreneur Company Monthly Billings].[Entrepreneur Company Principal Project , [Entrepreneur Company Monthly Billings].[Principal Project Pillar ID], Count([Entrepreneur Company Monthly Billings].[Entrepreneur Company Billings ID] FROM [Entrepreneur Company Monthly Billings], [Entrepreneur Company Principal Projects]

Qry Count Principal Projects by Company

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Entrepreneur Company Programme Years , Count([Entrepreneur Company Principal Projects].[Entrepreneur Company Principal  FROM [Entrepreneur Company Principal Projects]

Qry Count Total Companies Allocated Lump Sum 1 Principal Project

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Lump Sum Allocation], Count([Entrepreneur Company Principal Projects].[Entrepreneur Company Principal , [Principal Projects].[Principal Project ID] FROM [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects]

Qry Count Unallocated Companies by Principal Project Recommended

Type: Select

-- Unable to parse query definition

Qry Entrepreneur Company Extra Sponsor Amount List

Type: Select

SELECT [Entrepreneur Company Extra Sponsor Elements].[Entrepreneur Company Extra Sponso, [Entrepreneur Company Extra Sponsor Elements].[Entrepreneur Company ID], [Principal] & \, [Principal Project Pillar Sponsor Elements].[Element Type], [Entrepreneur Company Extra Sponsor Elements].[Extra Sponsorship Amount], IIf(IsNull([Total Paid]),0,[Total Paid]) FROM [Entrepreneur Company Extra Sponsor Elements], [Principal Project Pillar Sponsor Elements], [Principal Project Pillars], [Principal Projects], [Principals], [Qry Sum Extra Sponsor Element Payments by Company]

Qry Entrepreneur Company Sub Products

Type: Select

SELECT [Entrepreneur Company Sub Products].[Entrepreneur Company Sub Product ID], [Entrepreneur Company Sub Products].[Entrepreneur Company ID], [Sub Products].[BBBEE Pillar], [Sub Products].[Sub Product], [Principal Project Pillar Sub Products].[Sponsorship Amount], [Principal Project Pillar Sub Products].[Number of Entrepreneurs], [Entrepreneur Company Sub Products].[Sub Product Allocated Amount] FROM [Entrepreneur Company Sub Products], [Principal Project Pillar Sub Products], [Sub Products]

Qry Export Certificate Mail Merge Information

Type: Select

SELECT [Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company ID], [Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company Programme Y, vwGarnetExportCompanyInformationforCertificateMailMerge.[Company Name], vwGarnetExportCompanyInformationforCertificateMailMerge.[Entrepreneur ID], [First Name] & \, vwGarnetExportCompanyInformationforCertificateMailMerge.[Delivery Location], vwGarnetExportCompanyInformationforCertificateMailMerge.[Date Status Changed], vwGarnetExportCompanyInformationforCertificateMailMerge.[Programme Year], vwGarnetExportCompanyInformationforCertificateMailMerge.[Certificate Programme N, [Product Code] & \, vwGarnetExportCompanyInformationforCertificateMailMerge.Principal FROM [Temp Entrepreneur ID for Contract Mail Merge], [vwGarnetExportCompanyInformationforCertificateMailMerge]

Qry Export Commitment Fee Information for Invoice

Type: Select

SELECT [SubQry Export Commitment Fee Information for Notification].[Committment Fee Inv, [SubQry Export Commitment Fee Information for Notification].[Entrepreneur Compan, [SubQry Export Commitment Fee Information for Notification].[Company Name], [SubQry Export Commitment Fee Information for Notification].[Delivery Location], [SubQry Export Commitment Fee Information for Notification].[Committment Fee], [SubQry Export Commitment Fee Information for Notification].[Contract Start Date FROM [Temp Entrepreneur ID for Contract Mail Merge], [SubQry Export Commitment Fee Information for Notification]

Qry Export Contract Mail Merge Information

Type: Select

SELECT vwGarnetExportEntrepreneurInformationforContractMailMerge.[Entrepreneur ID], vwGarnetExportEntrepreneurInformationforContractMailMerge.[Email Address], [Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company ID], vwGarnetExportEntrepreneurInformationforContractMailMerge.[Entrepreneur Company , [Project Name] & \, vwGarnetExportEntrepreneurInformationforContractMailMerge.[Contract Printed], vwGarnetExportEntrepreneurInformationforContractMailMerge.[Allocated Amount], Format([Contract Start Date],\, vwGarnetExportEntrepreneurInformationforContractMailMerge.[Contract Start Date] FROM [Temp Entrepreneur ID for Contract Mail Merge], [vwGarnetExportEntrepreneurInformationforContractMailMerge]

Qry Get Amount Remaining by Principal Project Pillar

Type: Select

SELECT [Principal Project Pillars].[Principal Project Pillar ID], [Principal Project Pillars].[Amount Sponsored], [Amount Sponsored]-(IIf(IsNull([Total Sponsorship Amt]),0,[Total Sponsorship Amt FROM [Principal Project Pillars], [Qry Sum Total Sponsorship by Principal Project Pillar], [SubQry Sum Total Replaced Billed to Date by Prin Project Pillar], [SubQry Sum Total Replaced Selection Fee by Prin Project Pillar]

Qry Get Companies for Certificate Mail Merge

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID], [Entrepreneur Company Programme Years].[Certificate Printed], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], [Entrepreneur Company Programme Years].[Date Status Changed] FROM [Entrepreneur Company], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Programme Years].[Certificate Printed])=False) AND (([E

Qry Get Companies for Lump Sum Allocation

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], Entrepreneurs.[Recommended Principal Project ID], Entrepreneurs.[Recommended Product ID], [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Process Status ID] FROM [Entrepreneur Company], [Entrepreneurs] WHERE (((Entrepreneurs.[Recommended Principal Project ID])=Forms![Frm Lump Sum Allocat

Qry Get Current Contract Info by Company

Type: Select

-- Unable to parse query definition

Qry Get Division Dist Model and Rec Info by Company

Type: Select

SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID], Entrepreneurs.[Recommended Principal Project ID], Entrepreneurs.[Recommended Product ID], Entrepreneurs.[Pipeline ID] FROM [Entrepreneurs]

Qry Get Entrepreneur Recommended Information

Type: Select

SELECT Entrepreneurs.[Entrepreneur Company ID], [First Name] & \, [Principal] & \, Entrepreneurs.[Recommended BBBEE Pillar], Products.Product, Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID], [Lead Types].[Lead Type], [Lead Types].[Lead Source] FROM [Entrepreneurs], [Principal Projects], [Principals], [Products], [Lead Types]

Qry Get Entrepreneur Sourced From by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], [Principal Project Pillar Sourced From].[Entrepreneur Sourced] FROM [Principal Project Pillar Sourced From], [Principal Project Pillars]

Qry Get Entrepreneurs for Contract Mail Merge

Type: Select

SELECT Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID], [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Principal Projects].[Contract Printed], Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company Programme Years].[Contract Start Date], [Entrepreneur Company Principal Projects].[Allocated Amount] FROM [Entrepreneurs], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Principal Projects].[Contract Printed])=False) AND ((En

Qry Get Last Billing Date by EP Company Principal Project

Type: Select

SELECT [Entrepreneur Company Monthly Billings].[Entrepreneur Company Principal Project , Max([Entrepreneur Company Monthly Billings].[Billing Date]) FROM [Entrepreneur Company Monthly Billings]

Qry Get Last Note by Entrepreneur

Type: Select

-- Unable to parse query definition

Qry Get Last Note Date by Entrepreneur

Type: Select

SELECT [Entrepreneur Notes].[Entrepreneur ID], Max([Entrepreneur Notes].[Note Date]), Max([Entrepreneur Notes].[Entrepreneur Note ID]) FROM [Entrepreneur Notes]

Qry Get Last Programme Year ID by Company

Type: Select

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company ID], Max([Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years FROM [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])<>6

Qry Get Last Programme Year Info by Company

Type: Select

SELECT [Qry Get Last Programme Year ID by Company].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Qry Get Last Programme Year ID by Company], [Entrepreneur Company Programme Years], [Products], [CompanyProgrammeYearStatus], [NonGraduateReason]

Qry Get Last Programme Year Info for Report Writer

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], Entrepreneurs.[Division ID], [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], CompanyProgrammeYearStatus.[Programme Year Status], [Principal Project Pillars].[Principal Project ID], [Principal] & \, Principals.Principal, [Entrepreneur Company Principal Projects].[Selection Fee], [Entrepreneur Company Programme Years].[Product ID], Products.Product, [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Products], [Entrepreneur Company Programme Years], [Qry Sum Total Allocated Amt by Company], [Entrepreneur Company], [Entrepreneurs], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [CompanyProgrammeYearStatus], [Qry Get Last Programme Year ID by Company]

Qry Get Monthly Billing Information

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Entrepreneur Company Programme Years].[Entrepreneur Company ID], [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], [Entrepreneur Company Principal Projects].[Monthly Allocated Amount], Month([Date Status Changed]), Year([Date Status Changed]), [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], Month([Last Billing Date]), [Entrepreneur Company Principal Projects].[Lump Sum Allocation], Round(IIf(IsNull([Total Billed]),0,[Total Billed]),2), Round([Allocated Amount]-Round(IIf(IsNull([Total Billed]),0,[Total Billed]),2),2 FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Qry Get Last Billing Date by EP Company Principal Project], [Qry Sum Total Billed by Company PP and Project Pillar] WHERE ((([Entrepreneur Company Principal Projects].[Monthly Allocated Amount]) Is Not 

Qry Get Principal Projects for Finance Audit Report

Type: Select

SELECT [Principal] & \, [Principal Projects].[Principal Project ID], IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje, [Qry Sum Total Spend by Principal Project].[Lump Sum Allocation], [Qry Count Total Companies Allocated Lump Sum 1 Principal Project].[Total Compan FROM [Qry Sum Total Spend by Principal Project], [Principal Projects], [Principals], [Qry Count Total Companies Allocated Lump Sum 1 Principal Project] WHERE ((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Report Da

Qry Get Principal Projects for Finance Report

Type: Select

SELECT [SubQry Get Principal Projects for Finance Report].[Principal Project], [SubQry Get Principal Projects for Finance Report].[Principal Project ID], IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje FROM [Qry Sum Total Spend by Principal Project], [SubQry Get Principal Projects for Finance Report]

Qry Opal Scorecard Count Companies by Pgm Yr Status Not On Pgm

Type: Select

SELECT [SubQry Opal Scorecard Source].[Programme Year Status], Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Company Programme Year Status ID])<>1) AND ((

Qry Opal Scorecard Count Eligible for Graduation All Products

Type: Select

SELECT Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Eligible for Graduating])=\"yes\"))

Qry Opal Scorecard Count Graduated Off D

Type: Select

SELECT Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Programme Year])=\"D\") AND (([SubQry Opal Sc

Qry Opal Scorecard Count Graduated Off E

Type: Select

SELECT Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Programme Year])=\"E\") AND (([SubQry Opal Sc

Qry Opal Scorecard Count Graduated Off M

Type: Select

SELECT Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Programme Year])=\"M\") AND (([SubQry Opal Sc

Qry Opal Scorecard Count Graduated On E

Type: Select

SELECT Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Programme Year])=\"E\") AND (([SubQry Opal Sc

Qry Opal Scorecard Count Graduated On M

Type: Select

-- Unable to parse query definition

Qry Opal Scorecard Count Total D Eligible for Graduation

Type: Select

SELECT Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Programme Year])=\"D\") AND (([SubQry Opal Sc

Qry Opal Scorecard Count Total E Eligible for Graduation

Type: Select

SELECT Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Programme Year])=\"E\") AND (([SubQry Opal Sc

Qry Opal Scorecard Count Total Eligible for Graduation

Type: Select

SELECT Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Product ID])=2 Or ([SubQry Opal Scorecard Sou

Qry Opal Scorecard Count Total M Eligible for Graduation

Type: Select

SELECT Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Programme Year])=\"M\") AND (([SubQry Opal Sc

Qry Opal Scorecard Get Active Companies Continued

Type: Select

SELECT [Entrepreneur Company Status History].[Entrepreneur Company ID], Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID], [Entrepreneur Company].[Company Delivery Location ID], [Entrepreneur Company Status History].[Company Status ID], [Entrepreneur Company Status History].[Date Status Changed] FROM [Entrepreneurs], [Entrepreneur Company], [Entrepreneur Company Status History] WHERE (((Entrepreneurs.[Division ID])=1) AND ((Entrepreneurs.[Distribution Model ID])=

Qry Opal Scorecard Get Active Companies New

Type: Select

SELECT [Entrepreneur Company Status History].[Entrepreneur Company ID], [Entrepreneur Company Status History].[Company Status ID], Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID], [Entrepreneur Company].[Company Delivery Location ID], [Entrepreneur Company Status History].[Date Status Changed] FROM [Entrepreneurs], [Entrepreneur Company], [Entrepreneur Company Status History] WHERE ((([Entrepreneur Company Status History].[Company Status ID])=3) AND ((Entrepren

Qry Opal Scorecard Get Active Companies Stopped

Type: Select

SELECT [SubQry Opal Scorecard Get Active Companies Stopped].[Date Status Changed], [Entrepreneur Company Status History].[Entrepreneur Company ID], [Entrepreneur Company Status History].[Company Status ID], [Entrepreneur Company Status History].[Date Status Changed] FROM [SubQry Opal Scorecard Get Active Companies Stopped], [Entrepreneur Company], [Entrepreneur Company Status History] WHERE ((([Entrepreneur Company Status History].[Company Status ID])=4 Or ([Entrepreneu

Qry Opal Tag Programme Yr and Eligible for Graduation

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID], [Entrepreneur Company Programme Years].[Programme Year] FROM [Entrepreneur Company], [Entrepreneur Company Programme Years]

Qry Principal List

Type: Select

SELECT Principals.[Principal ID], Principals.Principal, Principals.[Principal Address 1], Principals.[Principal Address 2] FROM [Principals]

Qry Principal Project List Allocation

Type: Select

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID], [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Entrepreneur Company Programme Years].[Company Programme Year Status ID], [Entrepreneur Company Programme Years].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Programme Year], Products.Product, Products.[Programme Year Length], [Entrepreneur Company Programme Years].[Ignition Date], [Principal] & \, [Entrepreneur Company Principal Projects].[Allocated Amount], CompanyProgrammeYearStatus.[Programme Year Status], [Entrepreneur Company Programme Years].[Total Programme Amount], [Qry Sum Total Allocated Amt by Company].[Total Allocated Amt], [Total Programme Amount]-[Total Allocated Amt], [Total Selection Fee]-[Total Selection Amt] FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [CompanyProgrammeYearStatus], [Products], [ProgrammeYearLookup], [Qry Sum Total Allocated Amt by Company]

Qry Principal Project List Main Dashboard

Type: Select

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID], [Entrepreneur Company Programme Years].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Programme Year], Products.Product, [Entrepreneur Company Programme Years].[Ignition Date], [Principal] & \, [Entrepreneur Company Principal Projects].[Allocated Amount], CompanyProgrammeYearStatus.[Programme Year Status], ProgrammeYearLookup.[Sort Order] FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [CompanyProgrammeYearStatus], [Products], [ProgrammeYearLookup]

Qry Principal Project List

Type: Select

SELECT [Principal Projects].[Principal Project ID], Principals.Principal, [Principal] & \, [Principal Projects].[Contract Start Date] FROM [Principals], [Principal Projects], [Qry Sum Total Spend by Principal Project], [Qry Sum Total Billed by Principal Project]

Qry Principal Project Pillar List

Type: Select

SELECT [Principal Project Pillars].[Principal Project Pillar ID], [Principal] & \ FROM [Principals], [Principal Projects], [Principal Project Pillars]

Qry Principal Project Sub Products

Type: Select

SELECT [Principal Project Pillar Sub Products].[Principal Project Pillar Sub Product ID, [Principal Project Pillars].[BBBEE Pillar], [Sub Products].[Sub Product], [Principal Project Pillar Sub Products].[Sponsorship Amount], [Principal Project Pillar Sub Products].[Number of Entrepreneurs], [Principal Project Pillar Sub Products].Frequency FROM [Principals], [Principal Projects], [Principal Project Pillars], [Principal Project Pillar Sub Products], [Sub Products]

Qry Report Active Companies Email

Type: Select

SELECT [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[Distribution Model ID], [Distribution Models].[Distribution Model], Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Company Name], [First Name] & \, Entrepreneurs.[Email Address] FROM [Entrepreneurs], [Entrepreneur Company], [Distribution Models] WHERE ((([Entrepreneur Company].[Company Status ID])=3) AND ((Entrepreneurs.[Process S

Qry Report Active Entrepreneurs by Delivery Location

Type: Select

SELECT vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Distribution Model], vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Delivery Location], vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Number Active Entrepr, vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Companies Target], vwGarnetCountCurrentActiveCompaniesbyDeliveryLocation.[Number Active Companies] FROM [vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation], [vwGarnetCountCurrentActiveCompaniesbyDeliveryLocation]

Qry Report Companies Allocated Date Range

Type: Select

SELECT vwGarnetReportCompaniesAllocated.[Date Allocation Created], vwGarnetReportCompaniesAllocated.[Lump Sum Allocation], vwGarnetReportCompaniesAllocated.[Principal Project], vwGarnetReportCompaniesAllocated.[Company Name], vwGarnetReportCompaniesAllocated.[Ignition Date], vwGarnetReportCompaniesAllocated.Product, vwGarnetReportCompaniesAllocated.[Programme Year], vwGarnetReportCompaniesAllocated.[Programme Year Status], vwGarnetReportCompaniesAllocated.[BBBEE Pillar], vwGarnetReportCompaniesAllocated.[Allocated Amount], vwGarnetReportCompaniesAllocated.[Selection Fee], vwGarnetReportCompaniesAllocated.[Total Sponsorship], vwGarnetReportCompaniesAllocated.[Monthly Allocated Amount], vwGarnetReportCompaniesAllocated.[Delivery Location], vwGarnetReportCompaniesAllocated.[Ring Fence] FROM [vwGarnetReportCompaniesAllocated] WHERE (((vwGarnetReportCompaniesAllocated.[Date Allocation Created])>=[Forms]![Frm Rep

Qry Report Companies Left Programme Date Range

Type: Select

SELECT vwGarnetReportCompaniesLeftProgramme.[Date Status Changed], vwGarnetReportCompaniesLeftProgramme.[Company Programme Year Status ID], vwGarnetReportCompaniesLeftProgramme.[Lump Sum Allocation], vwGarnetReportCompaniesLeftProgramme.[Principal Project], vwGarnetReportCompaniesLeftProgramme.[Company Name], vwGarnetReportCompaniesLeftProgramme.[Company Status], vwGarnetReportCompaniesLeftProgramme.Product, vwGarnetReportCompaniesLeftProgramme.[Programme Year], vwGarnetReportCompaniesLeftProgramme.[Programme Year Status], vwGarnetReportCompaniesLeftProgramme.[Allocated Amount], vwGarnetReportCompaniesLeftProgramme.[Selection Fee], vwGarnetReportCompaniesLeftProgramme.[Total Sponsorship], vwGarnetReportCompaniesLeftProgramme.[Monthly Allocated Amount], vwGarnetReportCompaniesLeftProgramme.[Billed to Date], vwGarnetReportCompaniesLeftProgramme.[To Be Billed], vwGarnetReportCompaniesLeftProgramme.[Delivery Location], vwGarnetReportCompaniesLeftProgramme.[Ring Fence], vwGarnetReportCompaniesLeftProgramme.[Months On Programme], vwGarnetReportCompaniesLeftProgramme.[Replacement Status] FROM [vwGarnetReportCompaniesLeftProgramme] WHERE (((vwGarnetReportCompaniesLeftProgramme.[Date Status Changed])>=[Forms]![Frm Rep

Qry Report Companies Needs Replacement

Type: Select

-- Unable to parse query definition

Qry Report Companies Started Programme Date Range

Type: Select

SELECT vwGarnetReportCompaniesStartedProgramme.[Date Status Changed], vwGarnetReportCompaniesStartedProgramme.[Company Programme Year Status ID], vwGarnetReportCompaniesStartedProgramme.[Lump Sum Allocation], vwGarnetReportCompaniesStartedProgramme.[Principal Project], vwGarnetReportCompaniesStartedProgramme.[Company Name], vwGarnetReportCompaniesStartedProgramme.[Ignition Date], vwGarnetReportCompaniesStartedProgramme.[BBBEE Pillar], vwGarnetReportCompaniesStartedProgramme.Product, vwGarnetReportCompaniesStartedProgramme.[Programme Year], vwGarnetReportCompaniesStartedProgramme.[Allocated Amount], vwGarnetReportCompaniesStartedProgramme.[Selection Fee], vwGarnetReportCompaniesStartedProgramme.[Total Sponsorship], vwGarnetReportCompaniesStartedProgramme.[Monthly Allocated Amount], vwGarnetReportCompaniesStartedProgramme.[Delivery Location], vwGarnetReportCompaniesStartedProgramme.[Ring Fence] FROM [vwGarnetReportCompaniesStartedProgramme] WHERE (((vwGarnetReportCompaniesStartedProgramme.[Date Status Changed])>=[Forms]![Frm 

Qry Report Company Totals by Delivery Location

Type: Select

SELECT vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Delivery Location], vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Entrepreneur Compan, vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Company Name], Sum(vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Allocated Amoun FROM [vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects]

Qry Report Delivery vs Exited Entrepreneurs Summary

Type: Select

SELECT [Qry Report Delivery vs Exited Entrepreneurs].Status, Count([Qry Report Delivery vs Exited Entrepreneurs].[Entrepreneur ID]) FROM [Qry Report Delivery vs Exited Entrepreneurs]

Qry Report Delivery vs Exited Entrepreneurs

Type: Select

-- Unable to parse query definition

Qry Report Number Companies Ignited by Product

Type: Select

SELECT Products.Product, Count([Entrepreneur Company Programme Years].[Entrepreneur Company Programme Yea FROM [Entrepreneur Company Programme Years], [Products] WHERE ((([Entrepreneur Company Programme Years].[Ignition Date])>=[Forms]![Frm Reports

Qry Report Part Sponsorship Entrepreneurs

Type: Select

SELECT vwPurpleReportPartSponsorshipEntrepreneurs.[Entrepreneur Company ID], [First Name] & \, [Principal] & \, IIf([Profile Created]=True,\, Int(DateDiff(\, vwPurpleReportPartSponsorshipEntrepreneurs.Gender, vwPurpleReportPartSponsorshipEntrepreneurs.Location FROM [vwPurpleReportPartSponsorshipEntrepreneurs]

Qry Report Part Sponsorship History

Type: Select

SELECT vwGarnetRptPartSponsorshipHistory.[Process Status ID], vwGarnetRptPartSponsorshipHistory.[Company Status ID], vwGarnetRptPartSponsorshipHistory.[Entrepreneur Company Programme Years ID], vwGarnetRptPartSponsorshipHistory.[Delivery Location], vwGarnetRptPartSponsorshipHistory.[Company Name], vwGarnetRptPartSponsorshipHistory.Entrepreneur, vwGarnetRptPartSponsorshipHistory.Phone, vwGarnetRptPartSponsorshipHistory.[Email Address], vwGarnetRptPartSponsorshipHistory.Industry, vwGarnetRptPartSponsorshipHistory.[Brief Description of Business], vwGarnetRptPartSponsorshipHistory.Product, vwGarnetRptPartSponsorshipHistory.[Total Programme Amount], vwGarnetRptPartSponsorshipHistory.[Total Allocated], vwGarnetRptPartSponsorshipHistory.[Amount Needed], vwGarnetRptPartSponsorshipHistory.[Programme Year], vwGarnetRptPartSponsorshipHistory.[Contract Start Date] FROM [vwGarnetRptPartSponsorshipHistory] WHERE (((vwGarnetRptPartSponsorshipHistory.[Contract Start Date])>=[Forms]![Frm Part S

Qry Report Part Sponsorship

Type: Select

SELECT [SubQry Rpt Part Sponsorship].[Entrepreneur Company ID], [SubQry Rpt Part Sponsorship].[Company Programme Year Status ID], [SubQry Rpt Part Sponsorship].[Programme Year Status], [SubQry Rpt Part Sponsorship].[Company Status ID], [SubQry Rpt Part Sponsorship].[Company Status], [SubQry Rpt Part Sponsorship].[Delivery Location], [SubQry Rpt Part Sponsorship].[Company Name], [SubQry Rpt Part Sponsorship].Industry, [SubQry Rpt Part Sponsorship].[Percentage Black Owned], [SubQry Rpt Part Sponsorship].[Percentage Women Black Owned], [SubQry Rpt Part Sponsorship].[Brief Description of Business], [SubQry Rpt Part Sponsorship].Product, [SubQry Rpt Part Sponsorship].[Programme Year] FROM [SubQry Rpt Part Sponsorship]

Qry Report Principal Project Allocation Audit

Type: Select

SELECT vwGarnetRptPrincipalProjectAllocationAudit.[Principal Project ID], vwGarnetRptPrincipalProjectAllocationAudit.Status, IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status]), IIf(IsNull([ProgrammeYrSortOrder]),0,[ProgrammeYrSortOrder]), vwGarnetRptPrincipalProjectAllocationAudit.[Date Status Changed], vwGarnetRptPrincipalProjectAllocationAudit.[Replacement Status], vwGarnetRptPrincipalProjectAllocationAudit.[Company Name], vwGarnetRptPrincipalProjectAllocationAudit.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationAudit], [Qry Sum Total Spend by Principal Project] WHERE (((vwGarnetRptPrincipalProjectAllocationAudit.[Principal Project ID])=Forms![Frm

Qry Report Principal Project Allocation for Finance Blank Year

Type: Select

SELECT vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Status ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Programme Year Status I, vwGarnetRptPrincipalProjectAllocationforFinance.[Principal Project ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Delivery Location], vwGarnetRptPrincipalProjectAllocationforFinance.[Ignition Date], vwGarnetRptPrincipalProjectAllocationforFinance.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationforFinance], [Qry Sum Total Billed by Company PP and Project Pillar], [Qry Count Current Blank Year Companies by Principal Project], [Qry Count Current Blank Year Entrepreneurs by Principal Project] WHERE (((vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation])=False)

Qry Report Principal Project Allocation for Finance Future Year

Type: Select

SELECT vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Status ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Programme Year Status I, vwGarnetRptPrincipalProjectAllocationforFinance.[Principal Project ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Delivery Location], vwGarnetRptPrincipalProjectAllocationforFinance.[Ignition Date], vwGarnetRptPrincipalProjectAllocationforFinance.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationforFinance], [Qry Sum Total Billed by Company PP and Project Pillar], [Qry Count Current Future Year Companies by Principal Project], [Qry Count Current Future Year Entrepreneurs by Principal Project] WHERE (((vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation])=False)

Qry Report Principal Project Allocation for Finance Graduated

Type: Select

SELECT vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Status ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Programme Year Status I, vwGarnetRptPrincipalProjectAllocationforFinance.[Principal Project ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Delivery Location], vwGarnetRptPrincipalProjectAllocationforFinance.[Ignition Date], vwGarnetRptPrincipalProjectAllocationforFinance.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationforFinance], [Qry Sum Total Billed by Company PP and Project Pillar], [Qry Count Current Graduated Entrepreneurs by Principal Project], [Qry Count Current Graduated Companies by Principal Project] WHERE (((vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation])=False)

Qry Report Principal Project Allocation for Finance Nongraduate

Type: Select

SELECT vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Status ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Programme Year Status I, IIf([Company Programme Year Status ID]=8,IIf(IsNull([Replacement Status]),\, vwGarnetRptPrincipalProjectAllocationforFinance.[Principal Project ID], [Principal] & \, vwGarnetRptPrincipalProjectAllocationforFinance.[Company Name], vwGarnetRptPrincipalProjectAllocationforFinance.[Allocated Amount], vwGarnetRptPrincipalProjectAllocationforFinance.[Monthly Allocated Amount], IIf(IsNull([Total Billed]),0,[Total Billed]), [Allocated Amount]-[Billed to Date], vwGarnetRptPrincipalProjectAllocationforFinance.[Selection Fee], vwGarnetRptPrincipalProjectAllocationforFinance.[Selection Fee Type], IIf(IsNull([Allocated Amount]),0,[Allocated Amount])+IIf(IsNull([Selection Fee]), vwGarnetRptPrincipalProjectAllocationforFinance.[BBBEE Pillar], vwGarnetRptPrincipalProjectAllocationforFinance.[Ignition Date], vwGarnetRptPrincipalProjectAllocationforFinance.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationforFinance], [Qry Sum Total Billed by Company PP and Project Pillar] WHERE (((vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation])=False)

Qry Report Principal Project Allocation for Finance On Programme

Type: Select

SELECT vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Status ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Programme Year Status I, vwGarnetRptPrincipalProjectAllocationforFinance.[Principal Project ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Delivery Location], vwGarnetRptPrincipalProjectAllocationforFinance.[Ignition Date], vwGarnetRptPrincipalProjectAllocationforFinance.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationforFinance], [Qry Sum Total Billed by Company PP and Project Pillar], [Qry Count Current On Programme Companies by Principal Project], [Qry Count Current On Programme EPs by Principal Project] WHERE (((vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation])=False)

Qry Report Principal Project Product Totals by Delivery Location

Type: Select

SELECT [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Delivery Loc, [SubQry Sum Current On Prog by Prosperator Principal Proj Product].Principal, [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Project Name, [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Contract Sta FROM [SubQry Sum Current On Prog by Prosperator Principal Proj Product]

Qry Report Principal Project Totals by Delivery Location

Type: Select

SELECT vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Delivery Location], vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Principal Project], vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Total Spend], [SubQry Rpt EP Counts by Principal Project Delivery Location].[Number of Entrepr, Sum(vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Allocated Amoun FROM [SubQry Rpt EP Counts by Principal Project Delivery Location], [vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects]

Qry Report Principal Quarterly Reports

Type: Select

SELECT vwGarnetRptPrincipalQuarterlyReports.[Principal Project ID], vwGarnetRptPrincipalQuarterlyReports.[Process Status ID], vwGarnetRptPrincipalQuarterlyReports.[Division ID], vwGarnetRptPrincipalQuarterlyReports.[Principal Project ID], [Principal] & \ FROM [vwGarnetRptPrincipalQuarterlyReports] WHERE (((vwGarnetRptPrincipalQuarterlyReports.[Principal Project ID]) Is Not Null) AND

Qry Report Principal SD Letter New Allocation

Type: Select

SELECT [Principal Projects].[Principal Project ID], Principals.Principal, [Principal Projects].[Project Name], Principals.FYE, MonthName(Month([Principal Verified Date])), [Transformation Contact First Name] & \, Principals.[Transformation Contact Position], Principals.[Transformation Contact Email], Principals.[Transformation Contact Cell], [Procurement Contact First Name] & \, Principals.[Procurement Contact Position], Principals.[Procurement Contact Email], Principals.[Procurement Contact Cell], [DatabaseUsers].[First Name] & \, DatabaseUsers.[Email Address], [DatabaseUsers_1].[First Name] & \, DatabaseUsers_1.[Email Address], DatabaseUsers_1.[Cell Phone Number] FROM [Principal Projects], [Principals], [DatabaseUsers], [DatabaseUsers] WHERE ((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Report Da

Qry Report RAG

Type: Select

SELECT vwPurpleReportRAG.[Principal Project Pillar ID], vwPurpleReportRAG.[Principal Project Status ID], vwPurpleReportRAG.[Lump Sum Allocation], vwPurpleReportRAG.[Principal Project ID], [Principal] & \, vwPurpleReportRAG.[BBBEE Pillar], vwPurpleReportRAG.[Brief Date], vwPurpleReportRAG.[Number of Companies Required], vwPurpleReportRAG.[Entrepreneur Delivery Date], vwPurpleReportRAG.[Amount Sponsored], DateDiff(\, IIf([Entrepreneur Delivery Date]<Date(),DateDiff(\, DateDiff(\, IIf(IsNull([Total Sponsorship Amt]),0,[Total Sponsorship Amt])+IIf(IsNull([Total, [Amount Sponsored]-[Total Sponsorship], IIf([Total Days]=0,0,[Current Days]/[Total Days]), IIf([Amount Sponsored]=0,0,[Total Sponsorship]/[Amount Sponsored]), IIf(IsNull([Number Active Allocated Companies]),0,[Number Active Allocated Compa, IIf(IsNull([Number Exited Companies]),0,[Number Exited Companies]), IIf(IsNull([Unallocated Companies]),0,[Unallocated Companies]), [Number of Companies Required]-[Number Active]-[Number Exited]-[Number Unallocat, IIf(IsNull([Number of Replacements Needed]),0,[Number of Replacements Needed]) FROM [vwPurpleReportRAG], [SubQry Sum Total Replaced Billed to Date by Prin Project Pillar], [SubQry Sum Total Replaced Selection Fee by Prin Project Pillar]

Qry Report Raizcorp Possibilities

Type: Select

SELECT vwPurpleReportRaizcorpPossibilities.[Date Status Changed], DateDiff(\, vwPurpleReportRaizcorpPossibilities.[Company Status ID], vwPurpleReportRaizcorpPossibilities.Status, ProcessStatus.Status, vwPurpleReportRaizcorpPossibilities.[Delivery Location], vwPurpleReportRaizcorpPossibilities.Location, vwPurpleReportRaizcorpPossibilities.[Company Name], [First Name] & \, vwPurpleReportRaizcorpPossibilities.[Telephone Number], vwPurpleReportRaizcorpPossibilities.[Date of Birth], Int(DateDiff(\, vwPurpleReportRaizcorpPossibilities.Gender, vwPurpleReportRaizcorpPossibilities.[Email Address], vwPurpleReportRaizcorpPossibilities.Industry, vwPurpleReportRaizcorpPossibilities.[Brief Description of Business], vwPurpleReportRaizcorpPossibilities.[Percentage Black Owned], vwPurpleReportRaizcorpPossibilities.[Percentage Women Black Owned], [Principal] & \, vwPurpleReportRaizcorpPossibilities.Product, IIf([Profile Created]=True,\, vwPurpleReportRaizcorpPossibilities.[Note Date], vwPurpleReportRaizcorpPossibilities.Notes, vwPurpleReportRaizcorpPossibilities.[Product Pgm Yr], vwPurpleReportRaizcorpPossibilities.[Date Pgm Yr Status Changed] FROM [vwPurpleReportRaizcorpPossibilities], [ProcessStatus]

Qry Report Raizcorpossible Companies Email

Type: Select

SELECT [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Distribution Model ID], [Distribution Models].[Distribution Model], Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Company Name], [First Name] & \, Entrepreneurs.[Email Address] FROM [Entrepreneurs], [Entrepreneur Company], [Distribution Models] WHERE ((([Entrepreneur Company].[Company Status ID])=2 Or ([Entrepreneur Company].[Com

Qry Report SD Alocations Not Notified

Type: Select

SELECT [Principal Project Pillars].[BBBEE Pillar], [Entrepreneur Company Principal Projects].[SA SDM Notified], [Entrepreneur Company Principal Projects].[Date Allocation Created], [Entrepreneur Company].[Company Name], [Principal] & \ FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals] WHERE ((([Principal Project Pillars].[BBBEE Pillar])=\"SD\") AND (([Entrepreneur Compa

Qry Report Summarised Deferred Income

Type: Select

SELECT [Temp Principal Projects for Finance Report].[Principal Project ID], [Temp Principal Projects for Finance Report].[Principal Project], [Temp Principal Projects for Finance Report].[Total Spend], IIf(IsNull([OGB Total Selection Fee]),0,[OGB Total Selection Fee])+IIf(IsNull([O, vwGarnetReportSumDeferredIncomeOBBalance.[On P Blank Total Balance], vwGarnetReportSumDeferredIncomeSEDSpend.[SED Spend], vwGarnetReportSumDeferredIncomeFutureYearTotalSponsorship.[Future Yr Total Spons, [Total Spend]-(IIf(IsNull([On P Grad Blank Total Sponsorship]),0,[On P Grad Blan, vwGarnetReportSumDeferredIncomeBalanceNeedsReplacement.[NR Total Balance] FROM [Temp Principal Projects for Finance Report], [vwGarnetReportSumDeferredIncomeBalanceNeedsReplacement], [vwGarnetReportSumDeferredIncomeFutureYearTotalSponsorship], [vwGarnetReportSumDeferredIncomeNGSelectionFeeandBilledDate], [vwGarnetReportSumDeferredIncomeOBBalance], [vwGarnetReportSumDeferredIncomeOGBSelectionFeeandBilledDate], [vwGarnetReportSumDeferredIncomeSEDSpend], [vwGarnetReportSumDeferredIncomeTotalSponsorshipNonGraduate]

Qry Report Writer

Type: Select

SELECT Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Status ID], CompanyStatus.Status, [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Delivery Locations].[Delivery Location], IndustryLookup.Industry, [Entrepreneur Company].[Brief Description of Business], [Entrepreneur Company].[Average Monthly Turnover], [Entrepreneur Company].[Years in Business], [Qry Get Last Programme Year Info for Report Writer].Principal, [Qry Get Last Programme Year Info for Report Writer].[Principal Project], [Qry Get Last Programme Year Info for Report Writer].Product, [Entrepreneur Company].[BEE Level], [Entrepreneur Company].[Percentage Black Owned], [Entrepreneur Company].[Percentage Women Black Owned], [Qry Get Last Programme Year Info for Report Writer].[Total Programme Amount], [Qry Get Last Programme Year Info for Report Writer].[Total Selection Fee], [Qry Get Last Programme Year Info for Report Writer].[BBBEE Pillar], [Qry Get Last Programme Year Info for Report Writer].[Allocated Amount], [Qry Get Last Programme Year Info for Report Writer].[Selection Fee], [Qry Get Last Programme Year Info for Report Writer].[Total Allocated Amt], [Qry Get Last Programme Year Info for Report Writer].[Total Selection Amt], [Qry Get Last Programme Year Info for Report Writer].[Programme Year], [Qry Get Last Programme Year Info for Report Writer].[Company Programme Year Sta, [Qry Get Last Programme Year Info for Report Writer].[Programme Year Status] FROM [IndustryLookup], [Entrepreneur Company], [Delivery Locations], [Entrepreneurs], [CompanyStatus], [Qry Get Last Programme Year Info for Report Writer] WHERE (((Entrepreneurs.[Process Status ID])=91))

Qry SubFrm Principal Project Pillar Supporting Documents

Type: Select

SELECT [Principal Project Pillars].[Principal Project Pillar ID], IIf([Supporting Doc Affidavit (EME)]=True,\ FROM [Principal Project Pillars]

Qry SubRpt Companies in Principal SD Letter

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Trading As], [Entrepreneur Company].[Brief Description of Business], [Principal Project Pillars].[BBBEE Pillar], CompanyProgrammeYearStatus.[Programme Year Status], [Entrepreneur Company Principal Projects].[Replacement Status] FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [CompanyProgrammeYearStatus]

Qry SubRpt Entrepreneurs in Principal SD Letter

Type: Select

SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.Province, [First Name] & \, Entrepreneurs.[Telephone Number], Entrepreneurs.[Second Telephone Number], Entrepreneurs.[Email Address], Entrepreneurs.[Alternative Email Address] FROM [Entrepreneurs]

Qry SubRpt Principal Project Allocation Audit Replaced Companies

Type: Select

SELECT [Principal Projects].[Principal Project ID], CompanyStatus.Status, IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status]), IIf(IsNull([CompanyProgrammeYearStatus].[Sort Order]),0,[CompanyProgrammeYearSta, [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Principal Projects].[Replacement Status], [Entrepreneur Company].[Company Name], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Products], [Entrepreneur Company], [CompanyStatus], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [Qry Sum Total Spend by Principal Project], [CompanyProgrammeYearStatus], [Delivery Locations] WHERE ((([Principal Projects].[Principal Project ID])=Forms![Frm Principal Report Date

Qry SubRpt Principal Project Pillar Delivery Locations

Type: Select

SELECT [Principal Project Pillar Delivery Location].[Principal Project Pillar ID], [Delivery Locations].[Delivery Location] FROM [Principal Project Pillar Delivery Location], [Delivery Locations]

Qry Sum Extra Sponsor Element Allocated

Type: Select

SELECT [Entrepreneur Company Extra Sponsor Elements].[Principal Project Pillar Sponsor , Sum([Entrepreneur Company Extra Sponsor Elements].[Extra Sponsorship Amount]) FROM [Entrepreneur Company Extra Sponsor Elements]

Qry Sum Extra Sponsor Element Payments by Company

Type: Select

SELECT [Entrepreneur Company Extra Sponsor Payments].[Entrepreneur Company Extra Sponso, Sum([Entrepreneur Company Extra Sponsor Payments].[Payment Amount]) FROM [Entrepreneur Company Extra Sponsor Payments]

Qry Sum Replacement Amount Allocated by Replacement For

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Replacement For], Sum([Entrepreneur Company Principal Projects].[Allocated Amount]), [Entrepreneur Company Principal Projects].[Replacement Status], Sum([Entrepreneur Company Principal Projects].[Selection Fee]) FROM [Entrepreneur Company Principal Projects]

Qry Sum Total Allocated Amt by Company

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Entrepreneur Company Programme Years , Sum([Entrepreneur Company Principal Projects].[Allocated Amount]), Sum([Entrepreneur Company Principal Projects].[Selection Fee]) FROM [Entrepreneur Company Principal Projects]

Qry Sum Total Billed by Company and Project Pillar

Type: Select

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company ID], [Entrepreneur Company Monthly Billings].[Principal Project Pillar ID], Sum([Entrepreneur Company Monthly Billings].[Billing Amount]) FROM [Entrepreneur Company Monthly Billings], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years]

Qry Sum Total Billed by Company PP and Project Pillar

Type: Select

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company ID], [Entrepreneur Company Monthly Billings].[Entrepreneur Company Principal Project , [Entrepreneur Company Monthly Billings].[Principal Project Pillar ID], Sum([Entrepreneur Company Monthly Billings].[Billing Amount]) FROM [Entrepreneur Company Monthly Billings], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years]

Qry Sum Total Billed by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Sum([Entrepreneur Company Monthly Billings].[Billing Amount]) FROM [Entrepreneur Company Monthly Billings], [Principal Project Pillars]

Qry Sum Total Spend by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], [Principal Project Pillars].[Lump Sum Allocation], Sum([Principal Project Pillars].[Amount Sponsored]), Sum([Principal Project Pillars].[Number of Companies Required]) FROM [Principal Project Pillars]

Qry Sum Total Sponsorship by Principal Project Pillar

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Sum(IIf(IsNull([Allocated Amount]),0,[Allocated Amount])+IIf(IsNull([Selection F FROM [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status]) Is Null Or ([

Qry Update Certificate Printed Box

Type: Update

SELECT True FROM [Temp Entrepreneur ID for Contract Mail Merge], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Programme Years].[Certificate Printed])=False))

Qry Update Commitment Fee Invoiced Box

Type: Update

SELECT True FROM [Temp Entrepreneur ID for Contract Mail Merge], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Programme Years].[Committment Fee Invoiced])=False))

Qry Update Contract Printed Box

Type: Update

SELECT True FROM [Temp Entrepreneur ID for Contract Mail Merge], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Principal Projects].[Contract Printed])=False))

Qry Update SD Alocations Notified

Type: Update

SELECT True FROM [Qry Report SD Alocations Not Notified]

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 Company Needs Replacement List

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Principal Projects].[Replacement Status], [Entrepreneur Company].[Company Name], [Principal] & \, [Principal Project Pillars].[BBBEE Pillar], [Entrepreneur Company Principal Projects].[Allocated Amount] FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status])=\"Needs Repla

SubQry Export Commitment Fee Information for Notification

Type: Select

SELECT [Entrepreneur Company Programme Years].[Committment Fee Invoiced], [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID], [Delivery Locations].[Delivery Location], [Entrepreneur Company].[Company Name], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Entrepreneur Company], [Products], [Entrepreneur Company Programme Years], [Delivery Locations]

SubQry Get Principal Projects for Finance Report

Type: Select

-- Unable to parse query definition

SubQry Opal Scorecard Get Active Companies Stopped

Type: Select

SELECT [Entrepreneur Company Status History].[Entrepreneur Company ID], [Entrepreneur Company Status History].[Company Status ID], Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID], [Entrepreneur Company].[Company Delivery Location ID], [Entrepreneur Company Status History].[Date Status Changed] FROM [Entrepreneurs], [Entrepreneur Company], [Entrepreneur Company Status History]

SubQry Opal Scorecard Source

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], IIf([Delivery Location]=\, CompanyStatus.Status, [Entrepreneur Company].[Company Status ID], [Entrepreneur Company].[Date Status Changed], CompanyStatus_1.Status, [Temp Entrepreneur Companies for Opal Scorecard].[Date Status Changed During Ran, IIf(([Entrepreneur Company].[Date Status Changed]>=[Forms]![Frm Opal Scorecard R FROM [Temp Entrepreneur Companies for Opal Scorecard], [Entrepreneur Company], [CompanyStatus], [CompanyStatus], [Delivery Locations], [Entrepreneur Company Programme Years], [CompanyProgrammeYearStatus], [NonGraduateReason], [Products]

SubQry Rpt Companies Needs Replacement

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], [Principal Project Pillars].[Principal Project ID], [Entrepreneur Company Principal Projects].[Replacement Status], [Entrepreneur Company].[Company Name], Products.Product, [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Principal Projects].[Allocated Amount], [Principal Project Pillars].[BBBEE Pillar] FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Products], [Principal Project Pillars] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status])=\"Needs Repla

SubQry Rpt Delivery vs Exited Entrepreneurs

Type: Select

SELECT [Entrepreneur Company Status History].[Entrepreneur Company ID], [Entrepreneur Company Status History].[Company Status ID] FROM [Entrepreneur Company Status History] WHERE ((([Entrepreneur Company Status History].[Date Status Changed])>=[Forms]![Frm De

SubQry Rpt EP Counts by Principal Project Delivery Location

Type: Select

SELECT vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Principal Project ID, vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Company Delivery Loc, Sum(vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Allocated Weight FROM [vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects]

SubQry Rpt EP Names by Company by Delivery Location

Type: Select

SELECT vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Company Delivery Loc, vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Entrepreneur Company, vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.Entrepreneur FROM [vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects]

SubQry Rpt Part Sponsorship History

Type: Select

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID], Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Status ID], [Delivery Locations].[Delivery Location], [Entrepreneur Company].[Company Name], [First Name] & \, Entrepreneurs.[Telephone Number], Entrepreneurs.[Email Address], IndustryLookup.Industry, [Entrepreneur Company].[Brief Description of Business], Products.Product, [Entrepreneur Company Programme Years].[Total Programme Amount], IIf(IsNull([Total Allocated Amt]),0,[Total Allocated Amt]), [Entrepreneur Company Programme Years].[Total Programme Amount]-[Total Allocated, [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [IndustryLookup], [Entrepreneurs], [Products], [Entrepreneur Company], [Delivery Locations], [Qry Sum Total Allocated Amt by Company], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Programme Years].[Contract Start Date])>=[Forms]![Frm P

SubQry Rpt Part Sponsorship

Type: Select

SELECT vwPurpleReportPartSponsorship.[Entrepreneur Company ID], vwPurpleReportPartSponsorship.[Company Programme Year Status ID], vwPurpleReportPartSponsorship.[Programme Year Status], vwPurpleReportPartSponsorship.[Lump Sum Allocation], vwPurpleReportPartSponsorship.[Company Status ID], vwPurpleReportPartSponsorship.[Company Status], vwPurpleReportPartSponsorship.[Date Status Changed], vwPurpleReportPartSponsorship.[Status Modified By], vwPurpleReportPartSponsorship.[Company Delivery Location ID], vwPurpleReportPartSponsorship.[Delivery Location], vwPurpleReportPartSponsorship.[Company Name], vwPurpleReportPartSponsorship.Industry, vwPurpleReportPartSponsorship.[Percentage Black Owned], vwPurpleReportPartSponsorship.[Percentage Women Black Owned], vwPurpleReportPartSponsorship.[Brief Description of Business], vwPurpleReportPartSponsorship.Product, vwPurpleReportPartSponsorship.[Total Programme Amount], vwPurpleReportPartSponsorship.[Total Selection Fee], vwPurpleReportPartSponsorship.[Programme Year] FROM [Qry Sum Total Allocated Amt by Company], [vwPurpleReportPartSponsorship]

SubQry Rpt Principal Project Allocation for Finance Criteria

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Lump Sum Allocation], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Entrepreneur Company].[Date Status Changed], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], IIf([Company Programme Year Status ID]=8,IIf(IsNull([Replacement Status]),\, IIf([Ring Fencing]=True,\, [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], [Principal Projects].[Principal Project ID], [Delivery Locations].[Delivery Location], [Entrepreneur Company Programme Years].[Ignition Date], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Principal Projects], [Principals], [Products], [Principal Project Pillars], [Entrepreneur Company], [Delivery Locations], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects]

SubQry Sum Current On Prog by Prosperator Principal Proj Product

Type: Select

SELECT vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Company Delivery Lo, vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Delivery Location], vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Principal Project I, vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.Principal, vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Project Name], vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Product ID], vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Contract Start Date FROM [vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit], [vwGarnetSumTotalBilledbyPrincipalProjectDeliveryLocation]

SubQry Sum Total Replaced Billed to Date by Prin Project Pillar

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Sum([Entrepreneur Company Monthly Billings].[Billing Amount]) FROM [Entrepreneur Company Monthly Billings], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status])=\"Needs Repla

SubQry Sum Total Replaced Selection Fee by Prin Project Pillar

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Sum([Entrepreneur Company Principal Projects].[Selection Fee]) FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status])=\"Needs Repla