Need help with access database please - Employee Time Tracking

[Mae]

HI. Can anyone please help me..

I have an access databse with the following tables:

Employees
Projects
Cost COdes
Cost Types
Pay Types


What I want to do is have a form where an end user inputs the the manhours
for an emplyee based on project and with drop down menus for the cost
code/pay type/cost type to select as well from the tables..

How can I add a form that will allow people to input that data and then be
able to report and look up that data?

Thanks.

 

[Mae]

I know Its a stupid question and I know it's easy.. But can't anyone help?

I just can't figure out how to make it to where people can input times and
keep track of all those times in a table.. but have a pretty form for them
to input the times into.

I just need the direction to go in.. I'm computer savvy.. just not access
savvy.. just a simple "Well build this and then do this stupid" will work.

Please?

 

[Mae]

Hi Steve!

Thanks so much for your help.

Let me explain it a little better..

I understand what you're saying - but each employee may work on like 3
different projects at one time..

So lets say I have John and Jane Doe.

John is working on Project ABC. So his timesheet would be

Employee - John Doe
Project - ABC
Cost Code - 123
Cost Type - 345
Pay Type - A
Billable Hours: 10
Week Ending: 10-10-2008

And Jane would be:
Employee - John Doe
Project - CDE
Cost Code - 345
Cost Type - 678
Pay Type - A
Billable Hours: 10
Week Ending: 10-10-2008

Then because they are in a home office and working on different projects -
For week ending 10/10 they will also have other time sheets - i.e.

Another for John:
Employee - John Doe
Project - DEF
Cost Code - 123
Cost Type - 345
Pay Type - A
Billable Hours: 30
Week Ending: 10-10-2008

SO.

I have all my tables of the data... I just need to make a form (which I can
do just fine) for the manager to input their time.

So the point I'm lost at - is what my table should include or more or less
how to build a table that will feed all the individual timesheets or better
yet 'time entries" like shown above on each seperate row in the table - so i
can build reports off of it..

Does that make more sense?

Thank you so much for your help!!!!

 

[John W. Vinson]

You need another table to record the hours.

It sounds like you may have made a very common error - starting your design
with the Forms. Forms are *just windows*, tools to let you manage data in
Tables; the tables and their relationships are *absolutely basic*, and no
amount of forms work will help you if your tables aren't there!

I don't know your business model, but I would expect that you would need an
Hours table with fields for the EmployeeID (who worked), a date/time field
(when they worked), and *either* a Manhours field or - perhaps better - two
date/time fields for StartTime and EndTime. You may need fields for ProjectID
and CostCode as well, if a given bout of work needs to be attributed to a
project or a cost code.

You would then base your pretty form on this table or (perhaps more likely)
modify the form to fit the table... rather than struggling to do the reverse!

 

[John... Visio MVP]

If you need help with this, I could set it up fpr you for a modest fee.

Steve
(e-mail address removed)

These newsgroups are provided by Microsoft for FREE peer to peer support.
Steve is a known troll who offers questionable help. Even for free , his
help is over priced.

Please do nto feed the troll.

John... Visio MVP