Module: Form_Report Menu
Type: Form
Lines of Code: 728
Source: ms_access_files\garnet\Forms\Frm Report Menu.txt
Dependencies
Module Dependencies: - Actdatabase - RecSet
Tables Accessed: - Qry
Forms Referenced: - Frm
External References: - Excel.Application
Procedures
ExportCompanyList
Type: Public Sub
Lines: 100
Parameters: TheWhereStr As String
Calls: ExportCompanyList, Cells, OpenRecordset, Columns, Worksheets, CreateObject, Fields
Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ High branching (7 If statements)
ExportCompanyIgnitionList
Type: Public Sub
Lines: 121
Parameters: TheWhereStr As String
Calls: Cells, OpenRecordset, Columns, Worksheets, CreateObject, Fields, ExportCompanyIgnitionList
Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (121 lines)
ExportCompanyRaizcorpossiblesList
Type: Public Sub
Lines: 85
Parameters: TheWhereStr As String
Calls: ExportCompanyRaizcorpossiblesList, Cells, OpenRecordset, Columns, Worksheets, CreateObject, Fields
Complexity Notes: - ⚠️ Contains GoTo statements
ExportCompanyOnProgrammeList
Type: Public Sub
Lines: 119
Parameters: TheWhereStr As String
Calls: ExportCompanyOnProgrammeList, Cells, OpenRecordset, Columns, Worksheets, CreateObject, Fields
Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (119 lines)
ExportCompanyGraduatingList
Type: Public Sub
Lines: 93
Parameters: TheWhereStr As String
Calls: Cells, OpenRecordset, Columns, Worksheets, ExportCompanyGraduatingList, CreateObject, Fields
Complexity Notes: - ⚠️ Contains GoTo statements
ActiveEntrepreneurEmailReport_Click
Type: Private Sub
Lines: 3
Calls: ExportActiveEntrepreneurEmailReportToExcel, ActiveEntrepreneurEmailReport_Click
ActiveEntrpreneursbyProsperator_Click
Type: Private Sub
Lines: 3
Calls: ExportActiveEntrepreneursDeliveryMethod, ActiveEntrpreneursbyProsperator_Click
CertificateMailMergeExport_Click
Type: Private Sub
Lines: 4
Calls: CertificateMailMergeExport_Click
CloseFOrm_Click
Type: Private Sub
Lines: 13
Calls: CloseFOrm_Click
Complexity Notes: - ⚠️ Contains GoTo statements
Companies_Needs_Replacement_Report_Click
Type: Private Sub
Lines: 3
Calls: Companies_Needs_Replacement_Report_Click
CompaniesAllocated_Click
Type: Private Sub
Lines: 6
Calls: CompaniesAllocated_Click
CompaniesIgnitedbyProduct_Click
Type: Private Sub
Lines: 6
Calls: CompaniesIgnitedbyProduct_Click
CompaniesLeftProgramme_Click
Type: Private Sub
Lines: 6
Calls: CompaniesLeftProgramme_Click
CompaniesNeedToBeAllocated_Click
Type: Private Sub
Lines: 3
Calls: ExportCompaniesNeedToBeAllocatedToExcel, CompaniesNeedToBeAllocated_Click
CompaniesStartedProgramme_Click
Type: Private Sub
Lines: 6
Calls: CompaniesStartedProgramme_Click
CompanyTotalsbyProsperator_Click
Type: Private Sub
Lines: 3
Calls: CompanyTotalsbyProsperator_Click
ContractMailMergeExport_Click
Type: Private Sub
Lines: 4
Calls: ContractMailMergeExport_Click
DeliveryVsExited_Click
Type: Private Sub
Lines: 6
Calls: DeliveryVsExited_Click
EntrepreneurListReport_Click
Type: Private Sub
Lines: 13
Calls: ExportCompanyOnProgrammeList, ExportCompanyList, ExportCompanyRaizcorpossiblesList, ExportCompanyGraduatingList, EntrepreneurListReport_Click, ExportCompanyIgnitionList
ESDPrincipalSpendLetter_Click
Type: Private Sub
Lines: 6
Calls: ESDPrincipalSpendLetter_Click
ExportNewAllocationReport_Click
Type: Private Sub
Lines: 3
Calls: ExportNewAllocationToExcel, ExportNewAllocationReport_Click
FinanceMonthlyReport_Click
Type: Private Sub
Lines: 3
Calls: FinanceMonthlyReport_Click
Form_Open
Type: Private Sub
Lines: 12
Parameters: Cancel As Integer
Calls: Form_Open
OpalScorecardA_Click
Type: Private Sub
Lines: 4
Calls: OpalScorecardA_Click
PartSponsorshipHistoryExport_Click
Type: Private Sub
Lines: 4
Calls: PartSponsorshipHistoryExport_Click
PreBillingExceptionReport_Click
Type: Private Sub
Lines: 3
Calls: PreBillingExceptionReport_Click
Principal_Project_Allocation_Audit_Report_Click
Type: Private Sub
Lines: 8
Calls: Principal_Project_Allocation_Audit_Report_Click
PrincipalProjectAllocationReport_Click
Type: Private Sub
Lines: 8
Calls: PrincipalProjectAllocationReport_Click
PrincipalProjectAllocationReportFinance_Click
Type: Private Sub
Lines: 3
Calls: PrincipalProjectAllocationReportFinance_Click
PrincipalProjectFinanceAuditReport_Click
Type: Private Sub
Lines: 5
Calls: PrincipalProjectFinanceAuditReport_Click
PrincipalProjectTotalsbyProsperator_Click
Type: Private Sub
Lines: 3
Calls: PrincipalProjectTotalsbyProsperator_Click
QuarterlyPrincipalReport_Click
Type: Private Sub
Lines: 8
Calls: QuarterlyPrincipalReport_Click
RAG_Report_Click
Type: Private Sub
Lines: 4
Calls: RAG_Report_Click
RaizcorpPossibilitiesReport_Click
Type: Private Sub
Lines: 3
Calls: ExportRaizcorpPossibilitiesToExcel, RaizcorpPossibilitiesReport_Click
ReportWriter_Click
Type: Private Sub
Lines: 4
Calls: ReportWriter_Click
SDAllocationsNotNotifiedSDMandSA_Click
Type: Private Sub
Lines: 4
Calls: SDAllocationsNotNotifiedSDMandSA_Click
SummarisedDeferredIncome_Click
Type: Private Sub
Lines: 3
Calls: SummarisedDeferredIncome_Click