Reminder of birthday

[shiro]

Hi All,
I'm shiro,and trying to create my first project with ms access.

I have a databse which contain birthday my family and my friends.
Inside my table I keep OLE object ( photo.jpg ) of all my
friends and family.

I want to create a reminder form that can remind me about my friends
birthday.

I want to create aform that can be open automatically one week
before the birthday and a textbox or label that can count backward
the remaining days.

May be it will look nice if the form opened 4 or 5 times a day,and the form
also contain the photo of those who will celebrate their birth.

Is it too difficult to do or impossible?.Would somebody advise.

 

[Stefan Hoffmann]

hi Shiro,

Is it too difficult to do or impossible?.Would somebody advise.

Create a form, use the timer event to check, if you have to display a
reminder. Open the form hidden after startup of your application.


mfG
--> stefan <--

 

[shiro]

Hi Stefan,

More detail please.I use Access 2000 where I can find
a timer even or did you mean VBA code?.

And,your suggestion,what control do I need to put on that
form?.

 

[Stefan Hoffmann]

hi Shiro,

More detail please.I use Access 2000 where I can find
a timer even or did you mean VBA code?.
And,your suggestion,what control do I need to put on that
form?.

Just open a new form in design view, open the property editor (F4) for
the form. Go to the event page. There you will find (approximatly in the
lower third of the list):

- TimerInterval and OnTimer

Set the timer interval to an value of your choice. Maybe 5 minutes. As
the valus is measured in milliseconds, this would be 5 * 60 * 1000.

Then create an event procedure for the OnTimer event by pressing the
"...". In the event code (yes, here it comes down to VBA) you need your
reminder logic:

Query the appointments/birthdays, if there are some, show the reminder form.


mfG
--> stefan <--

 

[shiro]

Ups,Mr Stefan
I'm getting dizzy facing this 'logic program langguage'.
More guidence,please.

 

[Stefan Hoffmann]

hi shiro,

Ups,Mr Stefan
I'm getting dizzy facing this 'logic program langguage'.
More guidence,please.

Take a look at

http://ste5an.de/mpaf-reminder.zip

mfG
--> stefan <--