Skip to content

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