Best design for a timesheet for a given week

[Ian Shaw]

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

 

[Duane Hookom]

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.

 

[Ian Shaw]

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

================

tieTiEID
tieEmpID
tieTskID
tieWeekOf Sunday's date
tieSun
tieMon
tieTue
tieWed
dateSun
datemon
dateTues
datewed
etc

Is this correct??

Cheers,
Ian


date

 

[Duane Hookom]

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.

 

[Ian Shaw]

Thanks Duane,

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

Cheers,

Ian

 

[Michelle]

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.

 

[Duane Hookom]

Sorry, I don't have a sample database for this.

 

[Michelle]

Thanks Duane! Maybe Ian has a sample.

Thanks again.

 

[Michelle]

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

If you do, that will be greatly appreciated.

Thanks.

 

[Gouri]

I am looking for the DB design exactly like this can somebody share a template.
Thanks,

 

[George Nicholson]

Have you looked at the templates on the Office site?

Access (Time & Billing)
http://office.microsoft.com/en-us/templates/results.aspx?qu=Time&sc=4&av=ZAC

Excel/Word/Infopath (Timesheets)
http://office.microsoft.com/en-us/templates/CT101172771033.aspx