Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Timer (Access 2002)

    Can someone tell me how I can put a timer in a BOUNDCOUNTROL?

    I want to put 4 BC's on a form each have a timer. When the user clicks on the BC the time is recorded to the BC field.

    Thanks
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Timer (Access 2002)

    >>Can someone tell me how I can put a timer in a BOUNDCOUNTROL?<<

    I'm not exactly sure I understand what you are asking for. When you click on the countrol, what time do you want? The current time? Or perhaps the elapsed time from some start time?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timer (Access 2002)

    Hi Mark,

    I have 4 BoundControls. I would like to set a time on each so that when the user clicks the timer stops, thereby recording either the TimeStart or TimeEnd. Currently I have the controls set to do everything I want, but the user must put in a time, I would rather they just be able to click a button below the BoundControl (which I would like to be a is a timer or clock) which would capture the time from the timer.

    I hope that makes more sense.

    Thanks Mark,
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Timer (Access 2002)

    What you want isn't exactly a timer, it's a stopwatch utility. I've seen many of them over the years. Try looking on <A target="_blank" HREF=http://www.mvps.org/access/>http://www.mvps.org/access/</A>.
    Charlotte

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Timer (Access 2002)

    I'm still not clear on the circumstances. But you can put this code in the Click event of that button you talked about, to record the current time.

    txtBoundControl1 = Time( )
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Timer (Access 2002)

    Mark's approach will work for you - this sounds like a time-card application or a sign-in/out system. One of our clients runs one we developed, so I would like to share a couple of issues with you. The time you capture is of course dependent on the accuracy of the PC capturing the data. Unfortunately, PC clocks are not very stable, and are subject to the whims of users. Our client hosts their application on a PC at the office door, and it runs on a network which should synch it's clock regularly, but it is frequently 5 to 10 minutes off. This is also a bigger problem if you want people to be able to clock in/out from their own PC.

    The logic of when a user can click a particular button is also challenging. There should normally be a set sequence of events, but what happens when someone fails to check out and then comes in the next morning. Some fun things to think about! In any event, our client loves the app in spite of the issues. Good luck.
    Wendell

Posting Permissions

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