Birthday Remainder VBA...

[anbusds]

Hi All,
I would like to have a birthday remainder on access form load event VBA...
i have tblEmp with 2 fields,
Name DOB
A 22/04/1977
B 25/03/1965
C 17/08/1985

I would like to compare Date and month with my system date to show in the message box "Mr. A Birthday Today" on the Form load event...
Thanks in advance!!!

 

[bob fitz]

What if more than one person has a birthday today

 

[anbusds]

Messages one by one after we close the previous person or all the person names in one message box...

 

[bob fitz]

Do you want these messages when the form first opens or as you step through each record

 

[pr2-eugin]

I hope this POST will help you, I remember helping another user with similar request. The other user wanted to send an email, you can ignore that part.

 

[bob fitz]

See if the attached file helps

 

[anbusds]

Hi Bob,
Your sample Birthday remainder database Working Good,
At the same time is it possible to come out message after you
open the form rather you search one by one?
if can more convenient for payroll or employee management users!!!

 

[anbusds]

Hi pr2-eugin,
I tried your code email notification, there is no email after that time...
Can able to hide the form and able to insert into tbl_emailogger,
any settings need to do to receive email?
Thanks!!!

 

[bob fitz]

Hi Bob,
Your sample Birthday remainder database Working Good,
At the same time is it possible to come out message after you
open the form rather you search one by one?
if can more convenient for payroll or employee management users!!!

Try this please:

 

[anbusds]

Hi Bob,
This is what i expected, Working Well...
is it possible to send via email?
Just asking if can please let me know!!!

Thanks
Anbu

 

[bob fitz]

is it possible to send via email?

Sorry, I don't understand. Send what?

 

[anbusds]

Birthday Remainder via email 1 day earlier

 

[bob fitz]

Birthday Remainder via email 1 day earlier

Yes I'm sure it is possible to do that but I'm sorry to say that I have scant knowledge of how it is done. Suggest you Google for information and search this sight also. It's a topic that is often asked about.

Good luck with your project.