supmktg
04-29-2002, 07:53 AM
I would like to display the current time in a customers time zone ( a running clock). I have a table that includes a customer's time zone, and hours from GMT. I have been able to create an expression that calculates the customers current time based on my time, but I'm just not understanding how to display it on my form. What type of object do I want on my form, and how (and where) do I set the timer event and timer interval?
Thnx
Jack Cowley
04-29-2002, 08:31 AM
Add an unbound field to the form and call it CurrentTime. In the On Timer event put code like this:
Me![CurrentTime] = Time()
Set the Timer Interval to 1000
The CurrentTime field will show the time based on their machines clock.
supmktg
04-29-2002, 09:12 AM
Jack, I know it must be right in front of me, but I don't know how to get to the 'On timer event', or set the timer interval.
I set up a text box, and built the following expression in the control source properties:
'=Time()+6/24+[TZ]/24', where the [TZ] is the number of hours from GMT, and I am (GMT-6) hours. The display shows the proper time in the customers time zone, but it does't "run".
Thnx
Jack Cowley
04-29-2002, 09:55 AM
The On Timer event is next to last event in the Forms property sheet under the Events tab...