Popup Message

S

Steveo

Is there a way to create a popup in access at different times of the day.
Example:

Say at 10:30 every day I would like a popup message that would display check
new orders

Then at 12:00 every day I would like a popup message that would display
process all am orders for shipment.

Is this possible or not realistic? Any help is appreciated
 
B

Bob Quintal

Is there a way to create a popup in access at different times
of the day. Example:

Say at 10:30 every day I would like a popup message that would
display check new orders

Then at 12:00 every day I would like a popup message that
would display process all am orders for shipment.

Is this possible or not realistic? Any help is appreciated
Click to expand...
It is actually very simple The reason you don't see it used is
that it treats the users like morons. They resent that.

If you insist, for each reminder create a macro that opens a
messagebox with your reminder. Then create a shortcut to the
database. Modify the shortcut, by adding the name of the macro
after a slash e.g. /NoonRemnder

Go to control panel and click the Scheduled tasks item; follow
the instructions.

Please have mercy on your users, and don't do this.
 
L

Larry Linson

You want to do this just as a reminder to the user that it is time to do
these things? Or do you want to just run the necessary code or open the
necessary forms, displaying the new orders to be checked (if it must be done
manually), or just to perform the check?

In any case, in a Form that will be opened during application startup, set
the Timer property and provide a Timer event -- and leave the Form open in
the background...

Larry Linson
Microsoft Access MVP
 
M

missinglinq via AccessMonster.com

Here's a step-by-step for Larry's scenario:

Create a form named TimerForm

In Design View Goto Properties - Events
Set Interval Timer to 59500

Create a macro

Under Action select Open Form
Form Name = TimerForm
Window Mode = Hidden

When prompted to name the macro name it AutoExec (it *HAS* to be named this!)

Then in the code for form TimerForm

Private Sub Form_Timer()

If Format(Time, "HH:MM ampm") = "10:30 am" Then
MsgBox "Please Check New Orders"
End If

If Format(Time, "HH:MM ampm") = "12:00 pm" Then
MsgBox "Please Process All A.M. Orders for Shipment"
End If

End Sub
 
S

Steveo

This worked great. Thank You everybody for your help, comments, and
suggestions. A very good community with a ton of knowledge.
 
S

Steveo

1 More question if anyone can help.

How would I be able to make a popup by a day of the week.

Say on Thursday At 3:30pm I want a popup that says "Do daily backup"

I have this but need date help

If Format(TIME, "HH:MM ampm") = "3:30 pm" Then
MsgBox "Do daily backup"
End If
 
D

Douglas J. Steele

If Format(Time(), "hh:nn ampm") = "3:30 pm" And _
Weekday(Date()) = vbThursday Then
MsgBox "Do daily backup"
End If

You'll note I changed your original expression slightly: mm is the format
for month, not minutes (nn is for minutes)
 
M

missinglinq via AccessMonster.com

Doug,
Another Access quirk; when formatting Time, Format(Time, "HH:MM ampm") does
produce hours and minutes, just like Format(Time, "HH:NN ampm") does!
 
M

missinglinq via AccessMonster.com

And even more amazingly

format(now,"HH:MM MM/DD/YY")

will produce the correct result for both minutes and month as well!
 
D

Douglas J. Steele

I wouldn't count on that always being the case, though. They've tightened up
on syntax in other areas in the past.
 
Top