Module: Form_Report Writer Dialog Sales
Type: Form
Lines of Code: 289
Source: ms_access_files\purple\Forms\Frm Report Writer Dialog Sales.txt
Dependencies
Module Dependencies: - RecSet - Actdatabase - ComRecSet
Tables Accessed: - IndustryLookup - Entrepreneur - Qry
Forms Referenced: - Frm
External References: - Excel.Application
Procedures
ExportTheReport
Type: Public Sub
Lines: 201
Calls: Cells, OpenRecordset, Chr, ExportTheReport, Fields, Worksheets, CreateObject, Column
Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ High branching (20 If statements) - ⚠️ Large procedure (201 lines)
ClearFilters_Click
Type: Private Sub
Lines: 24
Calls: Selected, ClearFilters_Click
Filter1_AfterUpdate
Type: Private Sub
Lines: 14
Calls: Filter1_AfterUpdate
Form_Close
Type: Private Sub
Lines: 5
Calls: IsLoaded, Form_Close
OKButton_Click
Type: Private Sub
Lines: 18
Calls: OKButton_Click
Complexity Notes: - ⚠️ Contains GoTo statements
CancelButton_Click
Type: Private Sub
Lines: 16
Calls: IsLoaded, CancelButton_Click
Complexity Notes: - ⚠️ Contains GoTo statements