The Personal Information Page

Add controls to Page1 of the MultiPage control as listed in Table 4-3. These will correspond to the personal information column headings on the EmpData worksheet.

Table 4-3. HRWizard UserForm Controls

Item/Property Value

Label

Caption: TextBox Name: Label Caption: TextBox Name: Label

Caption:

TextBox

Name:

Label

Caption:

First Name txtFname Mid Init txtMidInit Last Name txtLname Date of Birth

Item/Property

Value

TextBox

Name:

txtDOB

Label

Caption:

SSN

TextBox

Name:

txtSSN

Label

Caption:

Department

ComboBox

Name:

cboDept

Label

Caption:

Job Title

TextBox

Name:

txtJobTitle

Label

Caption:

E-mail Address

TextBox

Name:

txtEmail

Resize the MultiPage control so there is room on the bottom of the UserForm for two command buttons (side by side) on the left side of the form and two command buttons (side by side) on the right side of the form. Table 4-4 lists the settings for these controls.

Table 4-4. Command Button Settings

Item/Property

Value

CommandButton

Name:

cmdPrevious

Caption:

<<<

CommandButton

Name:

cmdNext

Caption:

>>>

CommandButton

Name:

cmdSave

Caption:

Save

CommandButton

Name:

cmdCancel

Caption:

Cancel

The UserForm should now look something like Figure 4-23 in Design view.

Figure 4-23. Personal information data entry page
0 0

Post a comment