Skip to content

Module: Form_Report Writer Dialog

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

Dependencies

Module Dependencies: - Actdatabase - RecSet - ComRecSet

Tables Accessed: - Proposal - Qry

Forms Referenced: - Frm

External References: - Excel.Application

Procedures

ExportTheReport

Type: Public Sub
Lines: 249

Calls: Writer, Division, ExportTheReport, Role, Worksheets, Fields, CreateObject, Column, OpenRecordset, Cells

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

ClearFilters_Click

Type: Private Sub
Lines: 24

Calls: ClearFilters_Click, Selected

Filter1_AfterUpdate

Type: Private Sub
Lines: 12

Calls: Filter1_AfterUpdate

Form_Close

Type: Private Sub
Lines: 5

Calls: IsLoaded, Form_Close

Form_Open

Type: Private Sub
Lines: 9
Parameters: Cancel As Integer

Calls: Form_Open

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