After Midnite Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 30 Nov 2005 00:03 GMT

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

Reply to this Message

Jeff Boyce - 30 Nov 2005 00:50 GMT

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>

>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
[quoted text clipped - 10 lines]
> Any direction is appreciated...Thanks
> DS

Reply to this Message

DS - 30 Nov 2005 03:04 GMT

> Have you considered using a form's Timer event to:
> 1. check to see what time it is, and
[quoted text clipped - 20 lines]
>>Any direction is appreciated...Thanks
>>DS

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

Reply to this Message

John Vinson - 30 Nov 2005 01:49 GMT

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]

Reply to this Message

DS - 30 Nov 2005 03:05 GMT

>>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
[quoted text clipped - 17 lines]
>
> John W. Vinson[MVP]

I'll give it a try!
Thanks
DS

Reply to this Message