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.
On Jan 25, 7:44 am, Amateur <Amat...@discussions.microsoft.com> wrote:
> 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?
>
> "Arvin Meyer [MVP]" wrote:
> > 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
> > --
> > Arvin Meyer, MCP, MVP
> >http://www.datastrat.com
> >http://www.mvps.org/access
> >http://www.accessmvp.com
>
> > "Amateur" <Amat...@discussions.microsoft.com> wrote in message
> >news:585457C1-086B-4A4D-BD5B-(E-Mail Removed)...
> > > 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
Similar Threads
