Advice on developing VBA application

Indumathi Kamaraj · #1 (**permalink**) 06-23-11, 02:57

Hi to all
Am developing a tool using VBA application. In that i need to display the current time but when the user exit and login the first login time should remain the same. To display the current time i have used NOW function, I have a doubt how i can save that time and display whenever the user exit and again login?

Thanks & Regards,
K.Indu..

myle · #2 (**permalink**) 06-23-11, 19:37

there are 2 sub

Sub Auto_Open()
'will run when the file is open
End Sub

and

Sub Auto_Close()
'will run when the file is closed
End Sub

Indumathi Kamaraj · #3 (**permalink**) 06-24-11, 02:00

Hi thanks for the reply

But its not working.. time getting changed whenever i exit and again login..
Dim dtmtest As Date
dtmtest = TimeValue(Now)
TextBox1.Text = dtmtest
This is the code i have written in Private Sub UserForm_Initialize() to display the current time so when the form gets load the current time gets display but not saved so changing every time..

Thanks & Regards,
K.Indu...

healdem · #4 (**permalink**) 06-24-11, 03:50

is textbox1 bound to a data column?

Indumathi Kamaraj · #5 (**permalink**) 06-24-11, 05:54

hi
No its just an empty box used to display the time and date.

Thanks & Regards,
K.Indu...

Internet Services

Web Development

Digital Marketing

Consumer Tech