I'd sure love to be able to do this.

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I have a database I open daily. In it, I include info about the birthday &
anniversary dates of folks I know. I'd like to create a macro (or code???)
that will do signal me when someone's birthday or anniversary is to take
place within the next 2 weeks.

The fields of interest are:
DOB = birthday
DOA = anniversary
CombinedDate = the result of a union table whose SQL statement is:
SELECT LastName, FirstName, "Birthday" As CardType, DOB As CombinedDate
FROM tblContacts
UNION ALL SELECT LastName,FirstName, "Anniversary" As CardType, DOA As
CombinedDate
FROM tblContacts
ORDER BY CombinedDate;

How would I go about this? CAN I go about this?

Thanks.
 
I set up a query("birthdayCheck") selecting between Date() and birthdayfield
+ 14
Create a Popup form base on that query
creat a marcro opening that form
In your macro conditions put
DCount("[record-id]", "birthdaycheck")>0
You can name that macro Autoexec or launch it after you open you main form.

The form will only open when 1 or more birthdays fall between date run + 14
days.
 
Back
Top