Time Sheet in Access

Like most of my demos this file is intended as a starting point for others, either to adapt to their own requirements, or to use routines from the demo in their own applications.  You can freely amend it as you wish and use it without any restrictions for any purpose you see fit.  Changing the currencies would just be a matter of changing the Format properties of controls in the forms and reports.

You might like to take a look at Timesheet.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to  amend the form design accordingly.  

If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.

This little demo file illustrates some basic methodologies for a timesheet application, and includes a number of functions for doing date/time arithmetic.  Like all my demos, it is not a template or tutorial, and assumes sufficient technical knowledge on the part of anyone consulting it to be able to adapt the techniques which it illustrates to their own applications.

There would be no need to print or email, since you could simply run the app yourself and review the data that was entered, through some forms and reports.

I wrote such timesheet application for my company, and over 20 years it has certainly had 1000 hours of development. (side note - I was listening to The Voice today where one of the contestants was singing "... I'm glad I didn't know. The way it all would end the way it all would go. Our lives are better left to chance..." - so too with this program that mushroomed in so many ways) Your requirements may be much more modest, but don't expect you can click-click put it together without a thorough knowledge of relational database design concepts, some VBA, and basic Access operations (create query, form, report).

Thanks Ken - I'd forgotten that you had a timesheet sample!

tfaucher, grab Ken's sample and study it carefully! It may not be exactly a fit to your business, but Ken is one of the Great Ones and you'll certainly benefit from this opportunity!

That's probably a pretty extensive project. Are you looking for a hired consultant,  or resources to become skilled in Access yourself, or what? I don't think you'll find a ready-to-run timesheet program that fits your business, but (with a fair bit of work!) Access is quite capable of building such a system.