Module: Form_Opal Scorecard Report Dialog

Type: Form
Lines of Code: 581
Source: ms_access_files\garnet\Forms\Frm Opal Scorecard Report Dialog.txt

Dependencies

Module Dependencies: - TblRecSet - QryDef - Actdatabase - RecSet

Tables Accessed: - programme - End - Temp - Qry

Forms Referenced: - Frm

External References: - Excel.Application

Type: Private Sub
Lines: 155

Calls: Year, Month, OpenRecordset, DateAdd, DateSerial, PopulateTempTable, Fields, Eval, QueryDefs, Day

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

Type: Public Sub
Lines: 379

Calls: Cells, OpenRecordset, ExportOpalScorecardToExcel, Columns, Graduation, Worksheets, CreateObject, Fields, Eval, QueryDefs

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

Type: Private Sub
Lines: 22

Calls: OKButton_Click

Complexity Notes: - ⚠️ Contains GoTo statements

Type: Private Sub
Lines: 16

Calls: IsLoaded, CancelButton_Click

Complexity Notes: - ⚠️ Contains GoTo statements