Reminders in Access

[nicola1982]

Hi, This may sound ridiculously stupd but i taught myself Microsoft Access so my knowledge is VERY sketchy. I have set up a database of all my sales leads, contact details, time and topic of calls and it works ok. I heard that its possible to set up a reminders system so that when i open it it pops up with the people i need to call that day! Ive been through all the help guides but to be honest i dont really understand all the jargon. Could somebody please tell me in simple language if this is possible and if so, how do i do it??

You may just save my life!!

Thanks in advance!

[limperger]

Hi, This may sound ridiculously stupd but i taught myself Microsoft Access so my knowledge is VERY sketchy. I have set up a database of all my sales leads, contact details, time and topic of calls and it works ok. I heard that its possible to set up a reminders system so that when i open it it pops up with the people i need to call that day! Ive been through all the help guides but to be honest i dont really understand all the jargon. Could somebody please tell me in simple language if this is possible and if so, how do i do it??

You may just save my life!!

Thanks in advance!

Hey! If someone explains how to do it, I am very interested too!!

Best regards

[Nates]

Have you got a date/deadline field in the table that indicates when a task needs to be completed? If so run a query by today's date in the OnOpen event of your form and populate a msgbox/report with the results.

[limperger]

Nates:

Very interesting comment indeed. Unfortunately, I do not know how to convert the results of a query in a Msgbox text popping up in the screen (I suspect it may be very easy to do). Cound you shed some light on this?

Thank you very much in advance!

Best regards

[ADezii]

Hi, This may sound ridiculously stupd but i taught myself Microsoft Access so my knowledge is VERY sketchy. I have set up a database of all my sales leads, contact details, time and topic of calls and it works ok. I heard that its possible to set up a reminders system so that when i open it it pops up with the people i need to call that day! Ive been through all the help guides but to be honest i dont really understand all the jargon. Could somebody please tell me in simple language if this is possible and if so, how do i do it??

You may just save my life!!

Thanks in advance!

How about giving this a try.

NOTE: The Attachment did not take, will try at a leter time.

[aprpillai]

Try the following Link:

http://msaccesstips.com/2007/09/reminder-popups.shtml

or

http://msaccesstips.com/2006/10/reminder-ticker-form.shtml

[NeoPa]

As Nates says, put your reminder items somewhere in the database then run a query that picks up all the items whose dates (times) have already passed.

That's the basic concept. You can trigger on various things and you can make it as simple or as complicated as you need.

Forms have timer events if you want to get very clever, but why use Access for this when there are other applications better suited.

At the end of the day it's up to you what you do with it. It's flexible enough to handle it if that's what you need.

[NeoPa]

Hi!:

If a query was to be run, I would need one displaying the weekly results, that is, things pending to do that particular week. Then, I suppose that a query criteria like "display those to do this week" would be needed. I would use query a long date field and, although I know how to filter for today date, I don't know how should be the criteria for "this week". Any ideas? SQL statements will be also welcomed.

Best regards from Barcelona

You have asked your question in another member's thread. This is called thread hijacking and is not allowed on this site. There are various reasons for this, the principal of which is that it typically diverts the flow of the thread away from their needs and into yours. Another is that it will tend to mean that your new question is not seen as such, and may get overlooked by many of our experts (You appreciate that they're not looking for answered questions).
Please post your questions in their own threads in future (See How to Ask a Question).

ADMIN.

PS. This post has been deleted.