Reminder of birthday

  • Thread starter Thread starter shiro
  • Start date Start date
S

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.
 
hi Shiro,
Is it too difficult to do or impossible?.Would somebody advise.
Click to expand...
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 <--
 
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?.
 
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?.
Click to expand...
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 <--
 
Ups,Mr Stefan
I'm getting dizzy facing this 'logic program langguage'.
More guidence,please.
 
Back
Top