Our office administrative assistant keeps a roster of our people and their birthdays. As a birthday approaches, she prepares a greeting card for everyone to sign. She then clips a cover sheet to the card and circulates it around the office.
This cover sheet is just a Word document that lists everyone's name with a line next to it for each person to initial the cover sheet. Before she circulates the card and cover sheet, the admin assistant removes the name of the person who will receive the card. Then she hand-writes that name down the side of sheet.
It seems to me there's got to be a better way to do this, and I've turned to Access. The attached database shows what I'm trying to do. You'll see one table (tblPeople) that stores names and birthdays; a query; a form (to print the cover sheet); and a report (the cover sheet).
The form should let the user select the name of the birthday boy or girl, then click a button to print the cover sheet. The cover sheet will print with everybody's name in the list on the left side of the report (in portrait view) except the name of the person who's having the birthday. The selected name will print in a large, bold font in a text box somewhere on the sheet. (Perhaps in the page header ... ?)
I've built the basic parts. Can someone help me, please, with whatever it takes to make this thing work. Thank you!