Skip to content

Module: Form_Add and Edit Applicant

Type: Form
Lines of Code: 336
Source: ms_access_files\ruby\Forms\Frm Add and Edit Applicant.txt

Dependencies

Module Dependencies: - TheSelectionBox - fso

Forms Referenced: - Frm

External References: - Scripting.FileSystemObject

Procedures

CalculateDateOfBirth

Type: Public Sub
Lines: 49

Calls: Asc, DateSerial, CalculateDateOfBirth, Int

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

PopulateFileName

Type: Public Function
Lines: 10
Parameters: PathAndFile As String
Returns: String

Calls: CreateObject, GetFileName, PopulateFileName

BrowseForFile_Click

Type: Private Sub
Lines: 43

Calls: BrowseForFile_Click, SelectedItems, FileDialog, PopulateFileName

CloseForm_Click

Type: Private Sub
Lines: 55

Calls: CloseForm_Click

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

CopyStreetAddress_Click

Type: Private Sub
Lines: 11

Calls: CopyStreetAddress_Click

ExitNoSave_Click

Type: Private Sub
Lines: 7

Calls: IsLoaded, ExitNoSave_Click

Form_Activate

Type: Private Sub
Lines: 3

Calls: Form_Activate

Form_BeforeUpdate

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

Calls: Form_BeforeUpdate

Form_Close

Type: Private Sub
Lines: 10

Calls: Form_Close, IsLoaded

Form_Open

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

Calls: PopulateFileName, Form_Open

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

ID_Number_AfterUpdate

Type: Private Sub
Lines: 3

Calls: ID_Number_AfterUpdate

OpenFile_Click

Type: Private Sub
Lines: 91

Calls: OpenFile_Click

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