Results 1 to 4 of 4
  1. #1
    zero3ree is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2010
    Posts
    39

    Creating a Form to input time on a weekly basis by employee

    I am trying to create a form that an employee would click their name from a combo box and week ending date so it only shows records for the selected week and only their hours.

    And from this form they could input records. I have a table called Work Hours and a Query called Work Hours Extended. Basically the Work Hours are imputed from the form to Work Hours table



    and then the query adds the week ending date depending on the date for the hours worked. I cant figure out how to set this up in a form.

    I know this is lacking some information but if any one could help point me in the right direction I would be very thankful.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    See if this gives you ideas http://www.youtube.com/watch?v=sCXM7JAv7gE
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    zero3ree is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2010
    Posts
    39
    That seems to be a good application but I am adding this to my already existing DB. I put together a test DB to show where I am trying to get.

    With the form I want the EASI ID, when entered, to only show items that reflect that ID. On top of that I would like a second parameter to only show records of

    the selected week ending date. And if there are no records that it just shows blank so they can add to it. Then I am going to venture into how I can make this

    to where they can close it and bring it right back up without completing the time sheet. Any suggestions would be appreciated. Feel free to alter the DB also.

    TimeEntryTest.zip

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    The DSum expression in Total Hours is wrong syntax. Domain aggregate functions must refer to table or query, not form, as data source, and would need filter criteria.
    =DSum("[Hours]","timetemp","EASIID='" & [EASIID] & "' AND [Week Ending]=#" & [Week Ending] & "#")

    Textbox for WeekEnding on main form has ControlSource of field not in the form's RecordSource. Change to timequery. This textbox is disabled - how to select week?

    To synchronize the subform with main form, set Master/Child links properties to the EASIID fields and also the WeekEnding fields (compound link) if you want.

    The autonumber ID field in Employees is set as primary key but saving the EASIID value in timetemp table. Either change the PK to EASIID or save the ID as foreign key in timetemp.

    Do not save employee name in timetemp.

    Suggest use shortcut keys. Place & character in front of alpha character in button caption and then can press Alt+character to activate the button. Don't have to take hand from keyboard to mouse.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 8
    Last Post: 06-04-2012, 05:14 PM
  2. Creating employee clock in/out application
    By robertmarkdudley95 in forum Access
    Replies: 2
    Last Post: 03-30-2012, 02:31 AM
  3. Creating a Database to track Employee Training
    By osolaru in forum Database Design
    Replies: 9
    Last Post: 08-25-2011, 01:29 PM
  4. Creating a input form...?
    By DarrenReeder in forum Access
    Replies: 4
    Last Post: 01-07-2011, 03:26 PM
  5. Replies: 1
    Last Post: 08-14-2009, 03:53 AM

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