Display time at run-time by the seconds 2

[np3il]

Is there a function in Access to display the Time at run-time or to view the system time including seconds?

Ex. hh:mm:ss and displaying every second like a clock.

Is there a function to do this in Access?

Thanks
Np3il

 

[PHV]

Have a look at the Now() function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PeteJohnston]

Does Access have the equivalent of VB's Timer control that can be set to wake up and send you a Timer event when a specified length of time has elapsed?

PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)

 

[ZmrAbdulla]

Access forms have a timer event

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[abaldwin]

Access forms have a Timer event. This can be used the in conjuction with a forms TimerInterval property just like in VB.

You can always create a reference in a module as well and declare a variable as a timer and thus not have to have a form as long as you are starting the code when the DB is opened.


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[abaldwin]

Sorry Zmr I got a phone call while posting. Did not mean to appear to steal your answer.


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[ZmrAbdulla]

Andy, Don't worry..

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[np3il]

ZmrAbdulla & abaldwin

Thanks for the suggestions. I used the On Timer event and set the TimerInterval to 1.

On Timer comand:

Forms!fsumParking.txtTime = Str(Time())

Thanks
Np3il