run if clock =

[shutzy]

i have a real time clock. i want to run daily tasks when the clock is x

something like

If Me.txtClock = 10:15 then
MsgBox "you have chosen to run at 10:15!", vbOKOnly, "Weldone!."

the thing i am finding is that it doesnt liek the : so i put it in "xxx" and it still didnt work. is there anyway of doing this?

 

[JHB]

Try
If TimeValue(Me.txtClock) = TimeValue("10:15") Then

 

[shutzy]

thank you. i want to use this to run daily tasks. these tasks have been the bain of my life. now i wont have to worry about them at all.

thank you

 

[JHB]

You're welcome, (now your life can move on ).