After Midnite Problem

[DS]

I have Menus that I want to come up a certain times of the day. The
problem is I can't seem to make the thing work when a Menu goes past
midnite into the next day. Is there any solutins out there that can be
implemented.
I have this in the table...

MenuID
StartDay
StartTime
EndDay
EndTime

Any direction is appreciated...Thanks
DS

 

[Jeff Boyce]

Have you considered using a form's Timer event to:
1. check to see what time it is, and
2. if it is after midnight, set the Menu (I can't tell if you mean a
form with a menu or a menu bar).

Regards

Jeff Boyce
<Office/Access MVP>

 

[John Vinson]

I have Menus that I want to come up a certain times of the day. The
problem is I can't seem to make the thing work when a Menu goes past
midnite into the next day. Is there any solutins out there that can be
implemented.
I have this in the table...

MenuID
StartDay
StartTime
EndDay
EndTime

Any direction is appreciated...Thanks
DS

Access Date/Time values hold both dates and times in the same field;
as you have seen, programming gets more complicated when you separate
them. I'd suggest just two fields - StartTime (e.g. #11/29/2005
11:30pm#) and EndTime (e.g. #11/30/2005 2:15am#).

John W. Vinson[MVP]

 

[DS]

Have you considered using a form's Timer event to:
1. check to see what time it is, and
2. if it is after midnight, set the Menu (I can't tell if you mean a
form with a menu or a menu bar).

Regards

Jeff Boyce
<Office/Access MVP>

Its an actual form, not a menu bar. Sorry.
I do check the computer time, It's the after Midnite thing, especially
on the weekends when it goes from Saturday to Sunday!
Thanks
DS

 

[DS]

Access Date/Time values hold both dates and times in the same field;
as you have seen, programming gets more complicated when you separate
them. I'd suggest just two fields - StartTime (e.g. #11/29/2005
11:30pm#) and EndTime (e.g. #11/30/2005 2:15am#).

John W. Vinson[MVP]

I'll give it a try!
Thanks
DS