Access.2007.VBA.Bibl..

FIGURE 7.9

An Access form for entering timesheet data for export to Excel.

FIGURE 7.10

A combo box list showing timesheets for employees.

After selecting an employee, the CurrentWeekEndingprocedure calculates the week ending

date (today, if it is Sunday, otherwise last Sunday) and fills the captions of the seven date labels on

the form with the correct day of the week; the Manager name is also displayed in the Manager field

(the light blue back color indicates that the text box is locked). (See Figure 7.11.)

I give locked controls a light blue background (as opposed to a white background for

editable controls) to give users a visual cue that they can’t enter or edit text in these

controls.

NOTENOTE

Working with Excel Worksheets 7