By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Birthday Reminder

P: 2
Want to a develop an authomatic birthday pop-up reminder in ms access "birthday report" using vb. I want the report to come up with the following fields: date of birth, age and name. Any help?
Jun 11 '12 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 10K+
P: 14,534
You will need to create some kind of table to hold the birthdays. Then add some code to trigger the opening "Popup" of a form when the system date matches one or more birthday records.

However, the biggest issue will be when to trigger that check. I would suggest it be done on the database open event or on the open event of some form that would always be opened like the switchboard or custom menu.
Jun 12 '12 #2

P: 2
Hi MMcCarthy
I tried that but did not work.
Can you help me with the vb codes for the birthday Reminder in ms access.
Sep 4 '12 #3

Expert Mod 10K+
P: 12,357
Please show us the code you tried along with any error messages you got.
Sep 4 '12 #4

Expert Mod 5K+
P: 5,397

You have not provided enough information as to why what you tried didn't work.

MMcCarthy's suggestion and further question is, quite simply, the solution many of us would have given.

Please post your code or describe what you have tried so far to acheave your goal... include any error messages (number and descriptions) that occur and if there is an issue with the SQL or VBA please provide.

Sep 4 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.