Timesheet

[tigerstripes]

Hi,

I am in the process of creating a timesheet for the office. So far I have a form with drop down lists to populate Officer name, Project, client and then manually type in the date and time spent on the project.

I am working on using a pop up calendar to enter the date and have several examples from other threads to work through but I am also wondering if it is possible to enter time in hours and minutes spent on the project? At the moment the officers have to add up the time and enter it in minutes but this is causing some difficulty as they have to think about it! Is there a way to enable Access to work in 60 rather than 100?

The second question is is it possible to keep the officer name and date the same for several records so they do not need to keep entering it for every project they do in a day. So that they could enter their name and date for the first record and then for all the others they can just enter time, project and client and name and date will remain the same as the original one, but then be able to change it if they are entering several days records at once?

Hope that makes sense as I am getting quite confused working through this, it is the first database I have built and I am pretty much teaching myself.

Thanks

 

[oldaf294]

timesheet

Not sure about the open form, seems like a subform would be a better idea.
As for the time problem. If the officers are entering the time as Hrs:Min then the controls need to be formated as
hh:nn
In the detail section of the form the control can be translated to seconds by
=Left([trialtime],1)*60+Mid([trialtime],3,2)
(for up to 9hrs 59min)
in the formfooter it should be
=Sum(Left([trialtime],1)*60+Mid([trialtime],3,2))
Do not format !

good luck
jim

 

[alastair69]

Hi,

I am in the process of creating a timesheet for the office. So far I have a form with drop down lists to populate Officer name, Project, client and then manually type in the date and time spent on the project.

I am working on using a pop up calendar to enter the date and have several examples from other threads to work through but I am also wondering if it is possible to enter time in hours and minutes spent on the project? At the moment the officers have to add up the time and enter it in minutes but this is causing some difficulty as they have to think about it! Is there a way to enable Access to work in 60 rather than 100?

The second question is is it possible to keep the officer name and date the same for several records so they do not need to keep entering it for every project they do in a day. So that they could enter their name and date for the first record and then for all the others they can just enter time, project and client and name and date will remain the same as the original one, but then be able to change it if they are entering several days records at once?

Hope that makes sense as I am getting quite confused working through this, it is the first database I have built and I am pretty much teaching myself.

Thanks

Once you have finished your time sheet it maybe a good idea to submit it on the sample database section, so that if anybody else has the same problems they can use your example(s).

Regards

Alastair