Monthly Timesheet Database (1 Viewer)

woxzard

New member
Local time
Today, 19:50
Joined
Sep 16, 2013
Messages
2
Hi all. I am trying to develop a monthly timesheet database. Each employee will log on to the application and then be able to enter the number of hours they worked on a specific project per week. I have created one that records hours on a weekly basis and at the end of every week, the file is exported into excel. However, I need to make it into a monthly thing and I have no idea how to do that. Any help would be appreciated. Thanks!
 

GinaWhipp

AWF VIP
Local time
Today, 11:50
Joined
Jun 21, 2011
Messages
5,901
Well, if you are saying you need to make an export every month then set up a Form with a Combo Box that select months. Then set up your query to filter on months and export the results to Excel.

Oops, forgot the WELCOME! :D
 
Last edited:

woxzard

New member
Local time
Today, 19:50
Joined
Sep 16, 2013
Messages
2
Thanks for the suggestion, but I think one of the major problems lays in the relationships. What should I do about this? I've included the structure below. What should I do?
 

Attachments

  • saf.png
    saf.png
    51.5 KB · Views: 446

GinaWhipp

AWF VIP
Local time
Today, 11:50
Joined
Jun 21, 2011
Messages
5,901
Oh dear, yep, that's a problem. You need something like...

tblActivities
aAcivityID (PK)
aProjectID
aDate (or WeekNumber)
aHours
etc...

tblProjects
pProjectID (PK)
pProjects
pClientID (FK to tblClients)
pEmployeeID (FK to tblEmployees)
etc...

tblClients
cClientID (PK)
cCompany
etc...

tblUsers
uUserID (PK)
uFirstName
uLastName
etc...

And may I make a suggestion :D, a little reading...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html
http://www.databaseanswers.org/data_models/

Naming Conventions…
http://www.access-diva.com/d1.html

Other helpful tips…
Setting up a Model Database
http://www.access-diva.com/d11.html

My Database Standards...
http://regina-whipp.com/blog/?p=102
 

undertm

Registered User.
Local time
Tomorrow, 02:50
Joined
Jul 28, 2011
Messages
14
Hello


Did you end up getting your time sheet working.


I have been looking everywhere for a good example, but most online are either very simple or rubbish.


Can anyone help if they have an example working time sheet db system.
Enter time sheet data
Approve or reject

Reports Summary
Report Individual


I am working on mine, and have the data entry working well, but having trouble retrieving the data set for the approvals.



thanking someone in advance Terry
 

GinaWhipp

AWF VIP
Local time
Today, 11:50
Joined
Jun 21, 2011
Messages
5,901
@undertm

You should start your own thread as it will get more attention and most likely point you to some templates.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 10:50
Joined
Feb 28, 2001
Messages
27,005
Gina beat me to this one. There is no guarantee that woxzard is still monitoring this forum. Sad but true, many people come in, ask a few questions, and their need to use Access either is completed or they lose interest. I haven't seen that name in a long time, and the profile says last use was 2013. So I doubt you'll get an answer in this thread.
 

Users who are viewing this thread

Top Bottom