Step Using the Timesheet Application

Now that you are finished writing the last part of the timesheet application, you should spend some time testing and debugging it. I suggest that you set up several breakpoints in your VBA code and step through the procedures while querying the contents of objects in the Immediate window. You may also expand this application by adding additional features.

Here are some illustrations of running the application from the user interface.

Figure 17-42:

When the timesheet data is successfully submitted, the employee receives the confirmation message.

Figure 17-41:

Entering employee timesheet data for a specific week-ending date

Figure 17-42:

When the timesheet data is successfully submitted, the employee receives the confirmation message.

Ql

mplnyeiF

_Timesheel xls

[Tfn"{"x|

A I

0 C

D_

_E_1

F o ! :H:

1

I J I

K

:

iTSheetWlEircMare EndincjDate

TolalRegularHrs

TotslOvertime

TSheetW DayOSWeedt

CalDate

Reg-iorHr:

Overtime

2

6"

Mygoret Here 8/4/2002

33

0

6 Mon

7/29/2002

7

0

■3

7

Maf garet H=ns 7/28/2002

40

31

6 Tue

7/30/20D2

_s]

_oui

i

S

Margaret Hans 8/11 I20Ü2

39

S 25

6 Wsd

7/Jl.rjClùj

7

0

S

6 Thu

8/1/2002

7

0

6

6 Fri

8/2/2002

7

0

7

6 Sat

80/2002

_oj

0

S

8 Sun

8/4/2003

0

0

9

7jMon

7/22/2002

8 0 1

10

7 Tue

7/23/2002

8 0 1

11

7 v\fed

7/24/2002

_8j

0

1?

7; Thu

7/25/2QQ2

e

3

13

7; Fri

7/26/2002

8 Û

14

7 Sat

7/27/2002

0

0

IS.

7 Sun

7/28/2002

0

0

16

6 Mon

8/5/2002

8

025

17

S! Tue

8/6/2002

7

0

18

8 Wed

8/7/2002

8 0 1

19

8 Thu

8S/2002

8 2 I

20

6 Fri

8/9/2002

_djjl

7)

_SjSat_

8/10/2002

0

3 I

22

8 Sun

8/11/2002

0

0 1

23

- I mi

H <

I > m \ timesheet >,sheetz/ Sheet3 /

Upon pressing the My Timesheets button, the user is switched to Sheet2 to view the information on his or her existing timesheets in the database. You can view information for any employee by changing the name that appears next to the Employee Name

0 0

Post a comment