Skip to content

Form: Add and Edit Employee

Caption: Add and Edit Employee
Record Source: People
Has Code Behind: Yes
Source: ms_access_files\ruby\Forms\Frm Add and Edit Employee.txt

Controls (157)

Control Name Type Control Source
Calibri Label -
Calibri CommandButton -
Calibri TextBox -
Calibri ListBox -
Calibri ComboBox -
Calibri ToggleButton -
Birth Date TextBox Birth Date
Birth Date Label Label -
People ID TextBox People ID
Phys Line 1 TextBox Phys Line 1
Phys Line 1 Label Label -
Phys Line 2 TextBox Phys Line 2
Phys Line 2 Label Label -
Phys Line 3 TextBox Phys Line 3
Phys Line 3 abel Label -
Phys Postal Code TextBox Phys Postal Code
Phys Postal Code Label Label -
First Name TextBox First Name
First Name Label Label -
Middle Name TextBox Middle Name
Middle Name Label Label -
Employee Number TextBox Employee Number
Employee Number Label Label -
Title TextBox Title
Title Label Label -
Initials TextBox Initials
Initials Label Label -
Last Name TextBox Last Name
Last Name Label Label -
Email TextBox Email
Email Label Label -
Cell Number TextBox Cell Number
Cell Number Label Label -
Internal Extension TextBox Internal Extension
Internal Extension Label Label -
Race ComboBox Race
Race Label Label -
ID Number TextBox ID Number
ID Number Label Label -
Group Join Date TextBox Group Join Date
Group Join Date Label Label -
ISP Q1 TextBox ISP Q1
ISP Q1 Label Label -
ISP Q2 TextBox ISP Q2
ISP Q2 Label Label -
ISP Q3 TextBox ISP Q3
ISP Q3 Label Label -
ISP Q4 TextBox ISP Q4
ISP Q4 Label Label -
Label151 Label -
Phys Street Number TextBox Phys Street Number
Phys Street Number Label Label -
Phys Unit Number TextBox Phys Unit Number
Phys Unit Number Label Label -
Phys Complex TextBox Phys Complex
Phys Complex Label Label -
Phys Province ComboBox Phys Province
Phys Province Label Label -
Postal Add 1 TextBox Postal Add 1
Postal Add 1 Label Label -
Postal Add 2 TextBox Postal Add 2
Postal Add 2 Label Label -
Postal Add 3 TextBox Postal Add 3
Postal Add 3 Label Label -
Postal Code TextBox Postal Code
Postal Code Label Label -
Label170 Label -
Postal Street Number TextBox Postal Street Number
Postal Street Number Label Label -
Postal Unit Number TextBox Postal Unit Number
Postal Unit Number Label Label -
Postal Complex TextBox Postal Complex
Postal Complex Label Label -
Postal Province ComboBox Postal Province
Postal Province Label Label -
Postal Add Type Label Label -
Citizenship TextBox Citizenship
Citizenship Label Label -
Foreign National TextBox Foreign National
Foreign National Label Label -
Emergency Contact Name TextBox Emergency Contact Name
Emergency Contact Name Label Label -
Label189 Label -
Emergency Contact Number TextBox Emergency Contact Number
Emergency Contact Number Label Label -
Emergency Contact Address TextBox Emergency Contact Address
Emergency Contact Address Label Label -
Phys Country ComboBox Phys Country
Phys Country Label Label -
Postal Country ComboBox Postal Country
Postal Country Label Label -
CopyStreetAddress CommandButton -
Date Blacklisted TextBox Date Blacklisted
Date Blacklisted Label Label -
Reason Blacklisted TextBox Reason Blacklisted
Reason Blacklisted Label Label -
Box200 Rectangle -
ID Document File Name TextBox ID Document File Name
BrowseForFile CommandButton -
OpenFile CommandButton -
ID Document File Name Only TextBox -
ID Document File Name Only Label Label -
Passport File Name Only TextBox -
Passport File Name Only Label Label -
Drivers License File Name Only TextBox -
Drivers License File Name Only Label Label -
Matric Qualification File Name Only TextBox -
Matric Qualification File Name Only Label Label -
Tertiary Qualification File Name Only TextBox -
Tertiary Qualification File Name Only Label Label -
MIE Results File Name Only TextBox -
MIE Results File Name Only Label Label -
Passport File Name TextBox Passport File Name
Drivers License File Name TextBox Drivers License File Name
Matric Qualification File Name TextBox Matric Qualification File Name
Tertiary Qualification File Name TextBox Tertiary Qualification File Name
MIE Results File Name TextBox MIE Results File Name
SelectDoc Label Label -
Option221 OptionButton -
Option223 OptionButton -
Option225 OptionButton -
Option227 OptionButton -
Option229 OptionButton -
Option231 OptionButton -
Option237 OptionButton -
Option238 OptionButton -
Option239 OptionButton -
Option240 OptionButton -
Known As TextBox Known As
Known As Label Label -
Private Email TextBox Private Email
Private Email Label Label -
CV File Name Only TextBox -
CV File Name Only Label Label -
Contract File Name Only TextBox -
Contract File Name Only Label Label -
Cultural Compact File Name Only TextBox -
Cultural Compact File Name Only Label Label -
Dept Compact File Name Only TextBox -
Dept Compact File Name Only Label Label -
CV File Name TextBox CV File Name
Contract File Name TextBox Contract File Name
Cultural Compact File Name TextBox Cultural Compact File Name
Dept Compact File Name TextBox Dept Compact File Name
Emergency Contact Name 2 TextBox Emergency Contact Name 2
Emergency Contact Name 2 Label Label -
Label255 Label -
Emergency Contact Number 2 TextBox Emergency Contact Number 2
Emergency Contact Number 2 Label Label -
Emergency Contact Address 2 TextBox Emergency Contact Address 2
Emergency Contact Address 2 Label Label -
CloseForm CommandButton -
ExitNoSave CommandButton -
Last Modified By TextBox Last Modified By
Label138 Label -
Date Modified TextBox Date Modified
Label140 Label -

Event Procedures

  • BrowseForFile_Click
  • CloseForm_Click
  • CopyStreetAddress_Click
  • ExitNoSave_Click
  • Form_Activate
  • Form_BeforeUpdate
  • Form_Close
  • Form_Open
  • ID_Number_AfterUpdate
  • OpenFile_Click