Show a From at 1:00pm

I have a main form that the user inputs information into.
I would like to have a window pop up to at 1:00pm as a reminder to the user.

Is this possible?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201001/1

"User via AccessMonster.com" u36225@uwe wrote in message
news:a2134b93565f9@uwe...
I have a main form that the user inputs information into.
I would like to have a window pop up to at 1:00pm as a reminder to the
user.

It i possible to use the Timer event of a hidden form to check Now() every
1000 milli-seconds to see if it's 1pm, and if so to OpenForm (or OpenReport)
to display the reminder to the user.

But the problem is probably more involved than that. If the computer is not
running at 1pm, or the database is not open, do you need the reminder to
show up as soon as it is opened after that? What about if they saw the
message at 1pm and restart the database at 1:15pm? It's now after 1pm when
it starts up but the message has already been displayed, so you probably
need to log whether the message has been shown or not.

And what about if someone else opens the database? Do they need to see the
reminder if it has already been shown to someone?

There are also other issues associated with running the Timer event in the
background (e.g. can be very frustrating if you're writing code.)

Perhaps not quite as straightforward as you may have imagined.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.