Skip to content

Module: Form_Lead Detail Report Date Dialog

Type: Form
Lines of Code: 298
Source: ms_access_files\purple\Forms\Frm Lead Detail Report Date Dialog.txt

Dependencies

Module Dependencies: - RecSet - Actdatabase - QryDef - NoteRecSet

Tables Accessed: - Entrepreneur - Temp - If

Forms Referenced: - Frm

External References: - Excel.Application

Procedures

ExportEntrepreneursByLeadTypetoExcel

Type: Public Sub
Lines: 202

Calls: Columns, Cells, OpenRecordset, Eval, ExportEntrepreneursByLeadTypetoExcel, Fields, Worksheets, QueryDefs, CreateObject

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

OKButton_Click

Type: Private Sub
Lines: 62

Calls: OKButton_Click, OpenRecordset, Fields, Column

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ High branching (7 If statements)

CancelButton_Click

Type: Private Sub
Lines: 16

Calls: IsLoaded, CancelButton_Click

Complexity Notes: - ⚠️ Contains GoTo statements

ReportType_AfterUpdate

Type: Private Sub
Lines: 9

Calls: ReportType_AfterUpdate