Printing Membership Card

[PR]

I have a membership database with over 1700 records held in it, I want to
print a membership card for each member each year here is my problem:

I want to print a selection of records i.e. abc, def etc.
I want to mark records that have had the card printed for this year.
I want to be able to re-run a card if anything is incorrect in the detail or
goes wrong at print time.
I do not want to print all the records at once.

Can anyone suggest a way forward?

Many Thanks
Paul R

 

[PC Datasheet]

Paul,

Your first and last questions are the same. Create a query that contains all
the fields you want on the membership cards. Include a field where you can
set the criteria so you print only the cards you want.

For question 2, you need tables like this:
TblMember
MemberID
FName
MI
LName
etc

TblYearMembershipCardPrinted
YearMembershipCardPrintedID
MemberID
YearPrinted

After you print membership cards, you need to open a popup form that asks if
the cards were printed successfully. An answer of Yes then executes code
that creates a record in TblYearMembershipCardPrinted for each card printed.
An answer of No opens another pop-up form that asks which cards were not
correct. You need a way on the form to say All or specific cards. If only
specific cards are listed, you then execute code that creates a record in
TblYearMembershipCardPrinted for each card that printed successfully. You
can then go back and correct the other cards and try to reprint them. This
takes care of your question 3.