Module: Form_Product List

Type: Form
Lines of Code: 3754
Source: ms_access_files\vanadium\Forms\Frm Product List.txt

Dependencies

Module Dependencies: - RecSet - ActDatabase - Bookmarks - NewRecSet

Tables Accessed: - the - Start - NewRecSet - Products - RecSet - Product - Qry - End - variables

Forms Referenced: - Frm

External References: - Word.Application

Type: Public Sub
Lines: 52

Calls: Column, UpdateList

Complexity Notes: - ⚠️ High branching (8 If statements)

Type: Public Sub
Lines: 588

Calls: OpenRecordset, Item, PrintTheProductSheet, CreateObject, Column, Month, Chr, Fields, Dir

Complexity Notes: - ⚠️ High branching (113 If statements) - ⚠️ Large procedure (588 lines)

Type: Public Sub
Lines: 177

Calls: OpenRecordset, PrintSelectionMOU, Item, CreateObject, Column, Str, Fields, Dir

Complexity Notes: - ⚠️ High branching (19 If statements) - ⚠️ Large procedure (177 lines)

Type: Public Sub
Lines: 926

Calls: OpenRecordset, Item, CreateObject, Column, session, Chr, PrintSelectionServiceProviderAgreement, Fields, Dir, WHERE

Complexity Notes: - ⚠️ High branching (79 If statements) - ⚠️ Large procedure (926 lines)

Type: Public Sub
Lines: 668

Calls: OpenRecordset, services, Item, PrintSalesAgreement, CreateObject, Column, session, Chr, Fields, Dir (+1 more)

Complexity Notes: - ⚠️ High branching (55 If statements) - ⚠️ Large procedure (668 lines)

Type: Public Sub
Lines: 1190

Calls: OpenRecordset, CreateRevisedProduct, Fields

Complexity Notes: - ⚠️ High branching (40 If statements) - ⚠️ Large procedure (1190 lines)

Type: Private Sub
Lines: 3

Calls: AddProduct_Click

Type: Private Sub
Lines: 13

Calls: CloseFOrm_Click

Complexity Notes: - ⚠️ Contains GoTo statements