Module: Form_Report Writer Dialog
Type: Form
Lines of Code: 368
Source: ms_access_files\purple\Forms\Frm Report Writer Dialog.txt
Dependencies
Module Dependencies: - RecSet - Actdatabase - ComRecSet
Tables Accessed: - DatabaseUsers - Principal - Delivery - Qry - IndustryLookup - Entrepreneur - Lead
Forms Referenced: - Frm
External References: - Excel.Application
Procedures
ExportTheReport
Type: Public Sub
Lines: 230
Calls: Cells, OpenRecordset, Chr, ExportTheReport, Fields, Worksheets, CreateObject, Column
Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ High branching (35 If statements) - ⚠️ Large procedure (230 lines)
ClearFilters_Click
Type: Private Sub
Lines: 25
Calls: Selected, ClearFilters_Click
Filter1_AfterUpdate
Type: Private Sub
Lines: 31
Calls: Filter1_AfterUpdate, WHERE
Complexity Notes: - ⚠️ High branching (6 If statements)
Filter2_AfterUpdate
Type: Private Sub
Lines: 31
Calls: WHERE, Filter2_AfterUpdate
Complexity Notes: - ⚠️ High branching (6 If statements)
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