Popup Message

[Guest]

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

 

[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

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.

 

[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

 

[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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

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

 

[Guest]

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

 

[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)

 

[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!

 

[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!

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!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[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.