Birthday pop-up

[Guest]

Dear Sirs
In my database I have a table with customer details. Of course in this table
are as well the customer birthdays.
I would like that, on the day of the birthday, a pop-up should automatically
open with the text: Mr. XXXXXXXX has birthday Tel. number XXXXXXXXXXXX.
How can I do that?
Thanks
Klaus

 

[Arvin Meyer [MVP]]

This one opens before the birthday to give you time to mail a card, but you
can change that:

http://www.datastrat.com/Download/Birthday2K.zip

 

[Guest]

Thanks, I've tried it - but it seems that I always have to open the Form to
get the message. Is it not possible that the pop-up appears automatically on
the day of the birthday?

 

[Franck]

actually access can't by himself think, so he can check as he want/
when he want, so you need to trigger the code to look for birthdays, so
you need to put it sumwhere. the best i can suggest you, is put the
code in a module procedure, (i havent look at the code the other
provide you maybe it's like that) and call this code on the loading of
each form. that way it will always get triggerd. You still have another
solution that's not touching access at 100%, it would be to make a VB
services that check every Xsec ex:60sec(1 min) check in the database
for birthdays.

 

[Guest]

Amateur, try placing the code at database start up or main menu (if app)
load/open.
Don.

 

[Arvin Meyer [MVP]]

Make the form start when the database starts, just start it hidden. Then
either make it visible if there's a birthday, or close it if there isn't.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com