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)