Skip to content

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