Timer (Access 2002)

Topic

New Reply

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

Reply | Quote

Replies

>>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?

Reply | Quote

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,

Reply | Quote

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 http://www.mvps.org/access/.

Reply | Quote

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( )

Reply | Quote

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.

Reply | Quote