Birthday Warnings....

[bluenose76]

Hi,

My db amongst other things hold date of birth information for many people. What would be great is if I could somehow get the db to automatically inform me, say, a week in advance of an impending birthday so that my user of the db could then fill out a birthday card and pop it into the post.

I have experimented with trying to get access to export to Outlook and then set a reminder but this really didn’t work.

My thought process is that maybe I could have an event procedure that would run automatically when the db is opened with the result being a form opening on screen to inform the end user of all birthdays within the forthcoming 7 days?

Is this possible and if so could someone guide me in the right direction?

Thank you in advance and I look forward to your help.

Best regards
Bluenose

 

[petehilljnr]

Are you looking more so for the code to calculate the number of days until a birthday, or the process to show this information when the database is opened, or both?

 

[JohnLee]

Are you looking more so for the code to calculate the number of days until a birthday, or the process to show this information when the database is opened, or both?

I have something that I have done along those lines as follows:

within the query that you have created create the following two virtual fields as follows, First Virtual field -: Day: Day(Now([dtmDoB])), I am assuming that your date of birth field is name "dtmDoB", but what ever name you have for your date of birth field should occupy my expresssion above. Second virtual field -: Month(Now([dtmDoB]))

In the criteria row directly underneath the virtual field Day enter the following expression : Day(Now())+1 Or Day(Now())+2 Or Day(Now())+3 Or Day(Now())+4 Or Day(Now())+5 Or Day(Now())+6 Or Day(Now())+7 or Day(Now())-1 Or Day(Now())-2 Or Day(Now())-3 Or Day(Now())-4 Or Day(Now())-5 Or Day(Now())-6 Or Day(Now())-7

In the criteria row directly underneath the virtual field Month enter the following expression: Month(Now())

What this will do is limit your query to the current month and records that fall within 7 days of the current date [including the current date], either side of the current date for the current month, the only problem here is when you move into a new month any birthdays that fall 7 days before the current date will not show. i.e 1st of December, will not show any dates of birth in the last 7 days of November.

If you can live with that, this might be helpful.

FAB

John