Show a From at 1:00pm

[User via AccessMonster.com]

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?

 

[Allen Browne]

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.

 

[User via AccessMonster.com]

Thanks for the help!

I used the code below:


------------------------Begin Code--------------------------------------------
-
Private Sub Form_Timer()

If Format(Now(), "hh:nn:ss") = "12:59:59" Then
stDocName = "frmWhatever"
DoCmd.OpenForm stDocName, , , stLinkCriteria

End If
End Sub
-------------------------End Code---------------------------------------------
-