Module: Form_Selection Team Targets Report Dialog

Type: Form
Lines of Code: 632
Source: ms_access_files\purple\Forms\Frm Selection Team Targets Report Dialog.txt

Dependencies

Module Dependencies: - RecSet - HHRecSet - TargetRecSet - QryDef - TblRecSet - Actdatabase

Tables Accessed: - Step - Qry - Temp - Loop

Forms Referenced: - Frm

External References: - Excel.Application

Type: Public Sub
Lines: 288

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

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

Type: Public Sub
Lines: 133

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

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (133 lines)

Type: Public Sub
Lines: 62

Calls: OpenRecordset, PopulateEntrepreneurStepTable, Eval, Fields, QueryDefs

Type: Public Sub
Lines: 91

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

Complexity Notes: - ⚠️ Contains GoTo statements

Type: Private Sub
Lines: 31

Calls: OKButton_Click

Complexity Notes: - ⚠️ Contains GoTo statements

Type: Private Sub
Lines: 16

Calls: IsLoaded, CancelButton_Click

Complexity Notes: - ⚠️ Contains GoTo statements