Module: Form_Report Writer Dialog

Type: Form
Lines of Code: 321
Source: ms_access_files\garnet\Forms\Frm Report Writer Dialog.txt

Dependencies

Module Dependencies: - Actdatabase - ComRecSet - RecSet

Tables Accessed: - Principal - Delivery - Qry - IndustryLookup - Lead - Entrepreneur - DatabaseUsers

Forms Referenced: - Frm

External References: - Excel.Application

Type: Public Sub
Lines: 183

Calls: Cells, OpenRecordset, ExportTheReport, Column, Chr, Worksheets, CreateObject, Fields

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ High branching (23 If statements) - ⚠️ Large procedure (183 lines)

Type: Private Sub
Lines: 25

Calls: Selected, ClearFilters_Click

Type: Private Sub
Lines: 31

Calls: Filter1_AfterUpdate, WHERE

Complexity Notes: - ⚠️ High branching (6 If statements)

Type: Private Sub
Lines: 31

Calls: WHERE, Filter2_AfterUpdate

Complexity Notes: - ⚠️ High branching (6 If statements)

Type: Private Sub
Lines: 5

Calls: IsLoaded, Form_Close

Type: Private Sub
Lines: 18

Calls: OKButton_Click

Complexity Notes: - ⚠️ Contains GoTo statements

Type: Private Sub
Lines: 16

Calls: IsLoaded, CancelButton_Click

Complexity Notes: - ⚠️ Contains GoTo statements