Access.2007.VBA.Bibl..

ErrorHandler:

MsgBox “Error No: “ & Err.Number _

& “; Description: “ & Err.Description

Resume ErrorHandlerExit

End Sub

The frmSelectedTimesheet form is a simplified version of the frmWeeklyTimesheet (see Figure 7.15).

FIGURE 7.15

A form for editing a selected timesheet.

The hours can be edited on this form, and when you are done you can either delete this timesheet

record by clicking the “Clear This Timesheet” button, or save the record to the regular

tblWeeklyTimesheets table. Clicking the “Send Timesheets to Excel” button reopens the

fdlgTimesheets dialog, with updated data.

Clicking the OK button on fdlgTimesheets runs the CreateExcelTimesheetsprocedure,

which creates one Excel worksheet for each timesheet listed in the dialog; one of these timesheets

is shown in Figure 7.16.

Working with Excel Worksheets 7