Skip to content

Module: Form_Import Entrepreneur Dialog

Type: Form
Lines of Code: 1626
Source: ms_access_files\purple\Forms\Frm Import Entrepreneur Dialog.txt

Dependencies

Module Dependencies: - RecSet - ProspRecSet - Actdatabase - RefRecSet - IndRecSet - ImportRecSet - TheSelectionBox

Tables Accessed: - ReferenceNumbersImported - ImportEntrepreneurs - RefRecSet - End - ImportRecSet

Forms Referenced: - Frm

Procedures

ImportShortTemplate1

Type: Public Sub
Lines: 92

Calls: ImportShortTemplate1, OpenRecordset, Fields, WHERE

Complexity Notes: - ⚠️ Contains GoTo statements

ImportShortTemplate2

Type: Public Sub
Lines: 96

Calls: ImportShortTemplate2, OpenRecordset, Fields, WHERE

Complexity Notes: - ⚠️ Contains GoTo statements

ImportLongTemplate1

Type: Public Sub
Lines: 109

Calls: WHERE, OpenRecordset, Fields, ImportLongTemplate1

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

ImportLongTemplate2

Type: Public Sub
Lines: 116

Calls: ImportLongTemplate2, OpenRecordset, Fields, WHERE

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

ImportShortTemplate1NotFormsite

Type: Public Sub
Lines: 87

Calls: ImportShortTemplate1NotFormsite, OpenRecordset, Fields

Complexity Notes: - ⚠️ Contains GoTo statements

ImportShortTemplate2NotFormsite

Type: Public Sub
Lines: 91

Calls: ImportShortTemplate2NotFormsite, OpenRecordset, Fields

Complexity Notes: - ⚠️ Contains GoTo statements

ImportLongTemplate1NotFormsite

Type: Public Sub
Lines: 104

Calls: Fields, OpenRecordset, ImportLongTemplate1NotFormsite

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

ImportLongTemplate2NotFormsite

Type: Public Sub
Lines: 111

Calls: OpenRecordset, Fields, ImportLongTemplate2NotFormsite

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

ImportShortTemplate1A

Type: Public Sub
Lines: 103

Calls: OpenRecordset, Fields, ImportShortTemplate1A, WHERE

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

ImportShortTemplate2A

Type: Public Sub
Lines: 107

Calls: ImportShortTemplate2A, OpenRecordset, Fields, WHERE

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

ImportLongTemplate1A

Type: Public Sub
Lines: 120

Calls: OpenRecordset, Fields, ImportLongTemplate1A, WHERE

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

ImportLongTemplate2A

Type: Public Sub
Lines: 127

Calls: Fields, OpenRecordset, ImportLongTemplate2A, WHERE

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

CalculateDateOfBirth

Type: Public Sub
Lines: 34
Parameters: SAIdNumber As String, DateOfBirth As Date

Calls: CalculateDateOfBirth, DateSerial, Int

Complexity Notes: - ⚠️ Contains GoTo statements

ImportPitchandPolishTemplate

Type: Public Sub
Lines: 102

Calls: ImportPitchandPolishTemplate, CalculateDateOfBirth, OpenRecordset, Fields

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

ImportPurpleREMSTemplate

Type: Public Sub
Lines: 124

Calls: ImportPurpleREMSTemplate, OpenRecordset, Fields, WHERE

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

BrowseForFile_Click

Type: Private Sub
Lines: 13

Calls: FileDialog, SelectedItems, BrowseForFile_Click

CancelButton_Click

Type: Private Sub
Lines: 3

Calls: CancelButton_Click

DoTheImport_Click

Type: Private Sub
Lines: 63

Calls: DoTheImport_Click, Column

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