Click to See Complete Forum and Search --> : Birthday Blaster
ALFA117
Aug 30th, 2000, 11:58 AM
I´m creating a little program which runs a database...
In this database there´s a field "Birthday"
And i want my program to tell me the name of subject the day before his birthday.
Any ideas..
QWERTY
Aug 30th, 2000, 12:45 PM
I'm assuming that the field "Birthday" contains a date of birth. What I would do is:
[list=1]
Run Your program when Windows starts
Take the info (the date) from the database (store it in the variable - you could use an array if needed)
Compare the date-variable with today's date (using DateDiff function)
If the difference between the two dates is one day then display a message saying that "QWERTY has birthday tomorrow!!!!!!!!!!!!"
If the difference is greater than one day, ignore everything and do whatever you have to do
[/list=1]
HTH
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.