Best design for a timesheet for a given week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Guys,

A question that I have is what do you believe is the best way to design a
timesheet for a week. The form design is to have the task on the left side
of the page and the days of the week going across the page. Should I utilise
unbound fields or use bound text boxes. ie

tasks Monday Tuesday Wednesday Thurs Fri
task 1 5 7 4 3 2
task 2 3 4 5 6 3

You can see from above what I am trying to achieve.

Each task is displayed via a combo box, with the hours for each task I am
thinking would have to be unbounded as is the date field (each of the mon,
tues wed etc)

Do you guys have any ideas or have seen such a form that already exists??

please help me

Cheers,

ian Shaw
 
Design of forms and design of tables have two different objectives. You
should first think about your table structure where I would recommend
something like:

tblWorkPerformed
=================
wopWoPID autonumber primary key
wopTskID relates to tblTasks.tskTskID
wopEmpID relates to tblEmployees.empEmpID
wopDate work date
wopHours hours worked
wopComments (may not be necessary)

tblTasks
================
tskTskID autonumber primary key
tskTitle title of task
tskStatus ...

Regarding your user interface, I would create a temporary/holding table with
a structure like:
tblTimeEntry
================
tieTiEID
tieEmpID
tieTskID
tieWeekOf Sunday's date
tieSun
tieMon
tieTue
tieWed
....

You can then use code and/or queries to create/fill tblTimeEntry and
additional code and/or queries to update tblWorkPerformed.
 
Duane that is a great idea!!

If I wanted to have the dates included for the respective hours on each
particular day I would need to update the dale design to:
tblTimeEntry
================
Click to expand...
tieTiEID
tieEmpID
tieTskID
tieWeekOf Sunday's date
tieSun
tieMon
tieTue
tieWed
dateSun
datemon
dateTues
datewed
etc

Is this correct??

Cheers,
Ian


date
 
If you know the Sunday date, then you add one for the Monday date, two for
the Tuesday date, etc so you do not need to store the dates other than one
date for the week.
 
Thanks Duane,

I shall implement those tips you have provided and I'll let you know how it
all goes!!

Cheers,

Ian
 
Hi Duane!

Do you have a sample of this database that you could email to me?

my email add is (e-mail address removed)

Thanks.
 
Hi Ian! DO you have a sample of this database that you can send me?

If you do, that will be greatly appreciated.

Thanks.
 
Back
Top