Results 1 to 3 of 3
  1. #1
    vad77 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2013
    Location
    USA
    Posts
    105

    Combo box to list numbers for OT tracking


    I am currently creating a databasse to track OT hours for my department. I want to create a combo box to select the number of hours to be posted so the hours are consistant. Some users might enter 1.30 for an hour and a half instead of 1.5. So I want to create a combo box that has the hours in the following format: 1.0, 1.25, 1.50, 1.75. 2.0 and son on. Is there an easy way in somekind of VBA coding to achieve this or o I have to build a list?
    Looking forward to your responses.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    You could have users identify their StartTime and EndTime on a Form; subtract StartTime from EndTime to get the length/duration.
    This seems only a small piece of a Pay and Benefits System or HR System or Finance System. Do you have a good understanding of how your piece "fits" with the larger system(s). Just saying you could be building an island....

  3. #3
    vad77 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2013
    Location
    USA
    Posts
    105
    Thia is just a stand alone db with no ties to any other system. It's just to keep track of Ot and send bi-weekly reports to the directors. The OT is just reported in hours worked no start and stop times are recorded.

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

Similar Threads

  1. Converting list of numbers to ranges
    By thebigthing313 in forum Programming
    Replies: 5
    Last Post: 03-26-2014, 09:14 AM
  2. Replies: 4
    Last Post: 10-21-2013, 11:06 AM
  3. Replies: 1
    Last Post: 08-21-2013, 11:11 AM
  4. Replies: 1
    Last Post: 04-28-2011, 03:32 PM
  5. Check for numbers in a combo box
    By slenish in forum Programming
    Replies: 2
    Last Post: 03-17-2010, 07:03 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