Reminder Timer 1

[aw23]

I need to create a reminder function in my program. Like Outlooks. In the Access program I have been working on Tthere is a form where the user enters the action he would like to do to a client. Ex- call, Email, etc. I need to create functionality so that the user can enter an action and set a reminder where in 2 hours, or 2 days, etc a popup will remind him. I am trying to figure out how to work this and I need some help getting started. Let's say I want a reminder on Monday at 2:00. Is there a way to do this or do I need to set a timer so that I calculate how much time will elapse util that day and that hour and set a reminder then?

Thanks for any help.

 

[aw23]

Is there anyway to do this?

Thanks

 

[aw23]

The only way I can think of is to calculate how many minutes or seconds there are between now and when the reminder should go, set a timer and the a msgbox when the timer is done. Is there a better way?

 

[TonyJollans]

Hi aw23,

I don't know anything about Outlook reminders, but a couple of points:

1. Presumably you can invoke them from Access so is there a reason you don't want to do that?

2. Can you really be sure your Access session will run constantly for 2 days or more all the time? If not, you need to store details of the reminders (in a table I guess) and periodically check them rather than relying on timers.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[aw23]

I was thinking about that and so I realized a timer would not work because although I am storeing the values in a db, the program will be shut everyday and then the timer will not continue?
I guess it makes sense to use Outlook reminders if I can through Access. I juat don't know anything about them

 

[aw23]

Maybe this will work,
I can store the date and time and set a timer. Everytime the user opens the program I will check the date and calculate the minutes from now and reset the timer.
Any thoughts on this?
Thanks

 

[TonyJollans]

Hi aw23,

I have just had a quick play and set up an appointment from Access with this code - and been reminded. I daresay you will want to do it a little bit more tidily, but if you are using Outlook I would think this is the way to go ..

[blue]Dim objOutlook As Outlook.Application
Set objOutlook = CreateObject("Outlook.Application")
Dim objAppointment As AppointmentItem
Set objAppointment = objOutlook.CreateItem(olAppointmentItem)
With objAppointment
.Start = Now + TimeValue("00:11:00")
.ReminderSet = True
.ReminderMinutesBeforeStart = 10
.Save
End With
Set objAppointment = Nothing
Set objOutlook = Nothing[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[aw23]

If I set a reminder with Outlook will the reminder popup i Outlook or can I have it pop up in my program in Access?

Thanks

 

[aw23]

Thanks, I tried your code and nothing happened.
I am really stuck.

 

[TonyJollans]

It's an Outlook reminder - it will pop up in Outlook, but it does play a sound. Seems a small price for not having to code all the logic yourself

I know nothing about this - I don't know what else may be possible.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[aw23]

I have several users using the same program. Whoever sets the reminder (curentUser) I need the reminder to pop up in their Outlook. Will this work like that?
Thanks

 

[PHV]

Have you tried to play with the Object Browser just to have an idea of how is the Outlook Object Model ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TonyJollans]

I don't know. try it!

When you say several users of the program, do you mean several users of the database - each with their own instance of the program under their own userid and/or on their own machine, each with their own Outlook, or what?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[aw23]

PHV - What is the object browser?
Tony- Yes

 

[TonyJollans]

Well, if each user is on their own machine, then each user should get their own reminders in their own Outlook. It doesn't matter whether the database is shared or not.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[PHV]

What is the object browser
When in VBE (Alt+F11) press the F2 key.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[aw23]

Thanks!

 

[aw23]

is there any way to make the reminder from outlook pop up on top of all other open windows? (Like my access program)

 

[TonyJollans]

Hi aw23,

Common sense says it ought to be possible but I don't know how to make it do that.

I think it is Windows XP behaviour - I notice the same type of behaviour on my system in other situations. I just tried with Outlook 97 on Windows Me and it popped up right on top of Access.

If I find anything, I'll post back. Or maybe somebody else knows - I have asked in the Win XP forum (see thread779-949317).

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[aw23]

Thanks so much.
My boss isn't so thrilled that the reminders are in Outlook, I told him there'e no choice, no way to do it in Access. It'll be a little better if they pop up on top.