F27QQ22 in .NET

Maker Code 128A in .NET F27QQ22

Because you asked the wizard to sort by the LastName field, it placed that field first on the data access page. It makes more sense to display the fields in the sequence Employee Number, 1043

27

Figure 27-23. A wizard-generated data access page with a group filter drop-down list and a customized record-navigation control.

27

27

As you can see, the recordset label actually has two parts, separated by a semicolon. The record navigation control uses the first part when you have set the section to display one record at a time. It uses the second part when you set the group-level properties to display more than one or all records. In this case, you should change tblDepartmentsWiz in both parts to Employees. When you switch to Page view, your page should now look like Figure 27-23.

27

27

27

Microsoft Office Access 2003 Inside Out First Name, Middle Name, and Last Name. To rearrange the controls, switch back to Design view and follow these steps:

27 27 27 27 27 27

1 Click the Last Name text box and drag it to the right to move it out of the way. 2 Click the Employee Number text box to select it and then hold down the Shift key and

3 Click one of the selected text box controls and move all three to the top of the tblDepartmentsWiz area. Notice that unlike a form, you cannot hold down the Shift key as you start to drag to lock the movement horizontally or vertically. You ll fix the alignment in a later step.

controlling element the sizing boxes around one of them are white. If not, click either Photo or Email Name to make it the controlling element.

that unlike forms, it s the white-highlighted element that controls the alignment. So, even if Employee Number, First Name, Middle Name, and Last Name are to the left of Email Name or Photo, aligning left on Email Name or Photo moves the out-of-line controls to the right. Your data access page should now look like Figure 27-24.

Now that you ve moved the controls, the tab sequence won t be correct, so you should fix the TabIndex property of each text box control. The bad news is data access pages don t have a 1044

Building Data Access Pages Tab Order command on the View menu to fix the problem graphically. You know you moved Last Name after Middle Name, so you need to fix Employee Number, First Name, Middle Name, and Last Name one at a time. Click away from the multiple selected controls to cancel the selection, then click on the Employee Number text box and choose the Other tab in the Properties window. If you followed the previous steps exactly, the TabIndex value for this control should be 31. Change the value to 30 and then click the First Name text box. Change the TabIndex property for the First Name text box to 31, for the Middle Name text box to 32, and finally for the Last Name text box to 33. Be sure to save your work before going on to the next section.

When you asked the wizard to group your records, the page it created isn t updatable. However, you can change some properties to allow the user to update the employee information. In order to make the employees section updatable, you need to perform the following steps:

1 2 3 4

In Design view, open the property sheet. Click on the Data tab in the property sheet. Click on the tblDepartmentWiz section header bar. In the UniqueTable property, choose tblEmployees from the drop-down list. The Properties window should now look like Figure 27-25.