Results 1 to 3 of 3
  1. #1
    wily_wolf is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Feb 2016
    Posts
    36

    Adding an Hours txt box and Mins dropdown (quarters of an hour) to a form and table

    Hello,

    I would like to create an hours and minutes field on a form so that employees can track the amount of time spent on a project.



    I would like there to be a txt box which they can freely type in however many hours they spent on the project (0, 1, 2, etc...) while next to it, they can select, from a combo box, the amount of minutes spent in quarters of an hour (00, 15, 30, 45). I also want this information to get input into a field in a table for the record. I'm hoping this information can be put in one field on the table, but understand if there needs to be two fields created in order to record that information. However, I also want to be able to add up the times (the hours and the mins fields) that these employees spent on the project.

    I'm using Access 2013 btw. Thank you!

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    when selections are to be provided - then you must have a table with the data - let's call these static lists - and then in your transaction table you set up a look up field to the static list ; either at the table level or at the form level. For instance the more common static lists are Months, States, etc...in your case you seem to need time periods.

  3. #3
    wily_wolf is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Feb 2016
    Posts
    36
    Thanks for the answer, however...

    So I created a text field for the hours and a combo box with a row source type as a value list and the row source: 00;15;30;45. Users can type in the hour and select the quarter hour intervals and input them into a table that keeps track of the separate fields (ProjectHours & ProjectMins). I was thinking of using the TimeSerial fxn to turn the values into a time and then somehow creating another calculated fxn that specifies the hours:mins. I just need to find a way to do that...

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

Similar Threads

  1. Replies: 5
    Last Post: 08-30-2015, 05:17 AM
  2. Replies: 1
    Last Post: 10-20-2013, 10:04 AM
  3. Time() and adding an hour in front or behind
    By Ruegen in forum Programming
    Replies: 4
    Last Post: 08-22-2013, 06:01 PM
  4. Replies: 4
    Last Post: 08-06-2012, 10:25 AM
  5. Replies: 2
    Last Post: 03-02-2011, 01:43 PM

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
  •  
Other Forums: Microsoft Office Forums