Module: Form_Certificate Mail Merge

Type: Form
Lines of Code: 301
Source: ms_access_files\garnet\Forms\Frm Certificate Mail Merge.txt

Dependencies

Module Dependencies: - QryRecSet - Actdatabase - CompYrRecSet - RecSet

Tables Accessed: - Certificate - Qry - QryRecSet - Temp - Entrepreneur - End - the

Forms Referenced: - Frm

External References: - Excel.Application

Type: Public Sub
Lines: 20

Calls: UpdateNumber, OpenRecordset

Type: Private Sub
Lines: 19

Calls: DeleteRecs_Click, Column, Selected

Type: Private Sub
Lines: 198

Calls: Dir, Principal, Cells, OpenRecordset, DoTheExport_Click, Worksheets, CreateObject, Fields

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

Type: Private Sub
Lines: 13

Calls: CloseFOrm_Click

Complexity Notes: - ⚠️ Contains GoTo statements

Type: Private Sub
Lines: 7

Calls: IsLoaded, Form_Close

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

Calls: Fields, Form_Open, OpenRecordset