Results 1 to 2 of 2
  1. #1
    DKF is offline Novice
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    6

    Form Design/Timesheet Creation

    Hi everyone.

    I am hoping someone will have an idea how to accomplish the following form design issue I am really struggling with:

    I need to create a 2 week timesheet for employees. I work for a park district - so my employees work various days and various hours at many locations.

    I have attached a sample of the paper form we currently use - it is two sided - one side for each week.

    I am struggling with the table structure for the Timesheet - since you don't repeat fields (since I need 2 Sundays, Mondays etc.)
    I thought it would look something like:
    Timesheet ID = primary key
    Employee ID = foreign key
    Pay Period
    Day 1
    Day 2
    Day 3 etc - up to Day 14
    Vacation Time
    Sick Time
    OT

    But then I get stuck on 2 issues - which are:


    How or where do I record all the locations & time each person works each week? To then track on reports at a later date - location reports & employee reports.

    How do I program the form to auto-populate all the days of the week (actual dates) based on the pay period selected? We have 26 pay periods each year - so Pay Period 1 is 12/27/09 - 1/09/10 as an example.

    Suggestions would really be appreciated - I am so stuck! Thanks.

  2. #2
    Join Date
    May 2010
    Posts
    339
    Their are some "Time Sheet" databases I did a quick search and found this example I included some screen shots hope this helps.


    Regards,

    Richard

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2007 - Form Creation
    By p4ck3tl055 in forum Forms
    Replies: 5
    Last Post: 03-18-2010, 12:43 PM
  2. please help me to design this form..
    By saleemMSMS in forum Forms
    Replies: 1
    Last Post: 08-26-2009, 01:54 AM
  3. Design form for restaurant
    By chanlongs in forum Forms
    Replies: 1
    Last Post: 08-20-2009, 07:35 AM
  4. Timesheet template
    By meso in forum Access
    Replies: 0
    Last Post: 07-27-2009, 05:28 AM
  5. Resource/Timesheet Database Design
    By lynchoftawa in forum Database Design
    Replies: 0
    Last Post: 06-06-2009, 10:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums