Is it possible to set up Microsoft Access to give a birthday reminder?

Question

I'm looking to set up a system in which M$ Access could give an annual reminder similar to that of a birthday reminder. Do you know if this is possible? And if so how do I do it?

I know I could use outlook or another calendar/reminder programme but already have all the data in Access. Checking it is just getting frustrating.

Thanks in advance

Cheers for the link n b
Not sure if my Access skills are up to it or not but will have a look...
Robin -- thanks also. That's essentially what I'm doing at the moment, but if I can't figure out the better wat may need to refine my query to make it more user friendly...

Answer 1

You could just set up a query and then run it every day..

Select Person
From Birthdays_Table
Where day(BirthDate) = day(now())
and month(BirthDate) = month(now())

Answer 2

You'd have to write youself a script to run a quesry agains the database... and then get the Windws scheduler to run it for you every day.

I guess you'd need to have a general-purpose query that will extract whichever records are appropriate each day and then flag up something on screen as a reminder to you... or use the mail CLI to send you a reminder email.

Answer 3

It is fairly complicated but entirely possible.

I wont post the code here, but reccommend a good free site for you to discover :

Edit: maybe try this then:

make your query into a form
set the form to run on startup of the database
add the database to your startup folder on the pc so it runs when you start the pc.