RUNNING CLOCK

[csegal]

How do I place a running clock into a form using access97?

 

[ajdesalvo]

Create a On Timer Event Procedure for the form. Then requery the text control at whatever interval you wish.

For example:

Place a text box control on a form with the control source being = Time. Name the control Current_Time.

In the On Timer event procedure"

Me![Current_Time].requery

Set the forms Timer Interval to 1000 (1 second).

Every second the time will change.
Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[Newposter]

Or, for simplicity, just create a text box and set the Control Source to =Now() with the Format hh:nn:ss.

For the date, a text box with the Control Source =Date() with the Format Long Date.
Newposter
"Good judgment comes from experience. Experience comes from bad judgment."

 

[THoey]

Realize that this is going to take away from your processor and slow your application down... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[Newposter]

Well, I'm running a PIII 933 MHz with 512 MB RAM, and starting it made my CPU resources spike to 7% briefly, then fall back to 1%. Database still runs very quickly. So i think it's a minimal concern. Newposter
"Good judgment comes from experience. Experience comes from bad judgment."