Display Date and Time

[Nishikawa]

Is there anyway that I can display date and time (that is running) on an access form. The time() function only shows the current time and freezes.

 

[boblarson]

There is, and I don't recommend doing it as it does use up computer resources while doing it, but if you still insist -

1. Go to the Form's properties dialog and in the TimerInterval put 1000 (1000 is milliseconds, so 1000 milliseconds is 1 second)

2. and then select the dropdown in the On Timer event and select Event Procedure, then click the elipsis (...) that appears next to it. That should open the code window.

3. If you want a text box to display it, type in
Me.YourTextBoxName = Now

Or, if you want it on the form's caption set it to
Me.Caption = Now

 

[Nishikawa]

Thanks for your help! There will not be any need to worry about computer resources as this database will be running on a server.

 

[boblarson]

Thanks for your help! There will not be any need to worry about computer resources as this database will be running on a server.

So you are going to have people physically go to the server and log into it and stand there using the server instead of opening the program from their computers?

Because if they are opening the Access file from their computers, regardless of where the mdb file is, the processing for Access is done on THEIR computer, not the server.

 

[Nishikawa]

Well, I don't think so. The database will later be uploaded on the net. I do hope that the time function will not take up too much resources.

 

[gemma-the-husky]

why do you need a time function - its just that using the timer sometimes seems to produce some unwanted side effects

 

[Nishikawa]

Oh, On my form, i need to show a few different time zone for a few countries. That's all