I took an Access class a year ago and emboldened during the class, I
whipped up what I thought at the time should have been a simple task, but a
year later I have to finish it and I'm still at a loss.
My wife and I run a bingo operation once a year for a fund raiser. Our
venue grows a bit every year and there's a person in the corner scrabbling
madly to keep track of money, games, and so on for the state's and our own
needs. Seemed to me that Access could be able to help, but here's my snag:
I want to press the enter key on a running clock when the game starts,
and it stores the time. When the game is over, the next field is a running
clock also, and the enter key stores that time. Basic subtraction and I now
have what time the game starts, ends, and how long it lasts. The best I
have been able to get is using the "Now ()" function which only gives me the
time that particular record was initiated. Close, but still not there.
Can someone help me here? Thanks a bunch!

Why not have 2 text boxes, one with StartTime and the other EndTime and in
the double click events for the controls have Me.StartTime = Now() and in
the EndTime have Me.EndTime = Now(). Format the fields as Date/Time in your
table where you add these. The third control on the form should be unbound
textbox where you will calculate the differece from the 2 times.


"carl mciver" <cmciver (AT) mindspring (DOT) com> wrote

f you still need this, send me an e-mail and I'll send you a little db
with a little form that does what you want in the time department.

It uses buttons: Start and Done
Using the enter key is tricky.
It does not display. It can be done, but it is not worth the effort.
It would be easy in VB, but VBA lacks some time functions.
When you press done you see the end tme and the elapsed in the form of
minutes.
So if it was 3 minutes and 30 seconds you would see 3.5.

isolomon (AT) solomonltd (DOT) com
Ira Solomon
On Fri, 18 Aug 2006 01:28:44 GMT, "carl mciver"
<cmciver (AT) mindspring (DOT) com> wrote: