Hi All
Got a great code that displays Good Morning / Good Afternoon / Good Evening
depending on the system time from:
http://www.microsoft-accesssolutions...me_message.htm
Looks great and the idea is brill - however it keeps displaying "Good
Evening" = regardless of the time.
The code is:
If Time() < 0.5 Then
[lblMorning].Visible = True
[lblAfternoon].Visible = False
[lblEvening].Visible = False
ElseIf Time() > 0.5 And Time() < 0.75 Then
[lblMorning].Visible = False
[lblAfternoon].Visible = True
[lblEvening].Visible = False
ElseIf Time() > 0.75 Then
[lblMorning].Visible = False
[lblAfternoon].Visible = False
[lblEvening].Visible = True
End If
End Sub
Anyone help??
Thanks
Steve