Time data entry restriction

[Gina Whipp]

All,

I am trying to restrict TimeOut field to the times indicated below.
Obviously it is not working and I can't see why. The formating on that
field is Medium Time.

If Me.txtTimeOut >= "12:00 AM" And Me.txtTimeOut <= "05:00 AM" Then
MsgBox "You MUST enter a time between 6:00 am and 11:59 PM!",
vbInformation, "AM/PM"
Me.txtTimeOut = Null
End If
Exit Sub


Thanks in Advance!
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

 

[Marshall Barton]

I am trying to restrict TimeOut field to the times indicated below.
Obviously it is not working and I can't see why. The formating on that
field is Medium Time.

If Me.txtTimeOut >= "12:00 AM" And Me.txtTimeOut <= "05:00 AM" Then
MsgBox "You MUST enter a time between 6:00 am and 11:59 PM!",
vbInformation, "AM/PM"
Me.txtTimeOut = Null
End If

Literal date/time value must be enclosed in # signs, not
quotes:

If Me.txtTimeOut >= #12:00 AM# And Me.txtTimeOut <= #05:00
AM# Then

 

[Gina Whipp]

I hate when the obvious is staring at me... HUGH Thank you!

 

[Gina Whipp]

Marshall,

Can you tell why entering 10:15 AM generates my message?

 

[Jim Burke in Novi]

If you want times to be limited to >= 6 AM use

If Me.txtTimeOut < #06:00:00 AM# Then

 

[Gina Whipp]

Thank you! I guess I was over thinking!

 

[Marshall Barton]

Can you tell why entering 10:15 AM generates my message?

I can't reproduce that effect.

Are you sure the field (in the table) is a Date type field?

 

[Gina Whipp]

I got it thanks... and yes it was a date field.

 

[david]

I hate it when I see 12:00 AM.

Not because I'm picky, just because there is no agreement, and
no reference. I have to figure it out every time I see that. One of
my Internet Providers has unrestricted Access from 12:00 PM to
12:00 AM. What does that mean? Can you look it up on the
Internet? Good luck at that: you have to figure it out.

In this case, I already know how time is represented in Access,
so I could just say

If Me.txtTimeOut <= #05:00 AM# Then

Conversely, if I didn't know how time was represented in Access,
I would certainly never do time comparisons at all.

(david)

 

[Gina Whipp]

Thanks for you input but as you can by previous posts this answered...