Results 1 to 1 of 1
  1. #1
    Lounger
    Join Date
    Mar 2014
    Location
    Calgary, Alberta, Canada
    Posts
    25
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Starting Timesheet Build

    Hello,

    I can first say that I have attempted this with absolutely no success ... I am totally green when using Access 2010!

    I am trying to build a timesheet using Access that is linked to a great Project spreadsheet that was perfected by Maudable on here so I will try this site again for assistance. Although I laid out alot below, I am content with it being simplified so I don't waste your time

    Ideally I would like each employee to be able to fill in a form composing of a dropdown box of our Client's name, next if it can associate the client and only pull a list of the projects relating to it. Next it would auto fill in the start and end date of the project yet auto-generate today's date upon entry and the employee would fill in their hours. Lastly, another dropdown box containing the employee's task completed (each of the 4 employees that will be in the list have their own project tasks).

    I have seen a timesheet template online but tried for days to figure out how to tweek it with no progress and I don't need all that is in the template however the back-end employee and client information is handy. The functionality of the Reports and Invoicing is beneficial as well

    I have attached a copy of the spreadsheet that I use (less the macros because it was too big to upload) and because the template as discussed above is in Access, the format will not allow uploading so to see this please goto: http://office.microsoft.com/en-us/te...i:TC010222094| * I am using 2010 whereas this is an Access 2007 template I believe.

    The following are the colums in my spreadsheet that would pertain to the form:
    Column 6: Client Name
    Column 1: Project Location
    Column 8: Start Date
    Column 9: End Date
    Column 11: Employee

    I thank all in advance for your time and efforts!
    Greg
    Attached Files Attached Files

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •