time and Date open the forms

[mathanraj76]

Hi..I need help
Each time when i open the forms it's must show the system time and system date as log in time and log in date at same time must shows how many hours and seconds the forms is open

I have three textbox
First textbox for use for log in time , second textbox is used for log in date and the third textbox is used to show the how many hours and seconds the forms is open


Can i know show the username who is used the forms on the top of the forms..

Thanks
Mathanraj

[June7]

Save the date/time value when form is opened and the date/time value when form is closed. Then calculate the difference when need to know the elapsed time.

Yes, can show username.

Create a public function in a general code module:

Function GetUser()
GetUser = Environ("USERNAME")
End Function

Call the function from a textbox: =GetUser()

[mathanraj76]

can you give some sample on date and time .
I want it to show how many hours and minutes does the users open the forms and display on the forms..while the forms is open.

Thanks
Mathanraj

[June7]

Review
http://support.microsoft.com/kb/233275
http://www.blueclaw-db.com/access_ev...ming/timer.htm
http://www.databasedev.co.uk/clock.html