Results 1 to 9 of 9
  1. #1
    revival786 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2014
    Location
    Pakistan
    Posts
    6

    Combo box based timer

    Greetings. I am trying to design a combo box based timer in access using vba. My combo box has 0-12 values list where


    0 indicates timer is deactivated
    1 indicates timer is activated and start time for it is recorded in text box for stage 1

    On selecting 2, time interval between stage 1 and 2 will be recorded in text box for stage 2 and rest is the case with all stages till 12.
    All selections must be consecutive from 1-12 and there is such a timer-stage thing in each record of a database so each record having separate stage selections and corresponding time interval recordings


    Currently , I have found these resources

    http://www.rogersaccesslibrary.com/f..._topic612.html

    http://support.microsoft.com/kb/325238

    But I need to use combo box to reset , activate , track , pause time rather than buttons. Check out the image attached. I need thing like it Click image for larger version. 

Name:	1.png 
Views:	7 
Size:	36.6 KB 
ID:	16443Click image for larger version. 

Name:	1.png 
Views:	7 
Size:	36.6 KB 
ID:	16443

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Combo Based Timer

    How is your db structured? Are you using a Date/Time field for your start and end times? Just curious, is this something that could work for you per screenshot?
    Attached Thumbnails Attached Thumbnails DailyTimeClock.png  

  3. #3
    revival786 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2014
    Location
    Pakistan
    Posts
    6
    Can u send me the db. Let me check it out . hope that it may work and date/time field

  4. #4
    revival786 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2014
    Location
    Pakistan
    Posts
    6
    but i need consecutive selections and corresponding time interval readings

  5. #5
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    So, that won't work for you?

  6. #6
    revival786 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2014
    Location
    Pakistan
    Posts
    6
    I think it would . do send me asap

  7. #7
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Combo Based Timer

    Here is an Example that maybe you could adapt to suit your needs.

    HTH
    Attached Files Attached Files

  8. #8
    revival786 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2014
    Location
    Pakistan
    Posts
    6
    But there is no combo box based thing

  9. #9
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    I didn't say their was. Design it.

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

Similar Threads

  1. Replies: 4
    Last Post: 10-21-2013, 11:06 AM
  2. Replies: 3
    Last Post: 07-03-2013, 10:38 AM
  3. Replies: 3
    Last Post: 12-11-2012, 09:12 AM
  4. Replies: 1
    Last Post: 10-30-2012, 10:29 AM
  5. Replies: 1
    Last Post: 07-11-2012, 08:36 AM

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