Duplicate Report Printing

[Paladon]

Hi I am new to the forum.

I am creating an access database that holds customer information for a friend of mine. I am struggleing to think of ways to make Access do several tasks.

I have created several forms that display when reletive buttons are clicked and some run automatically using queries, one of which runs a query that displays any upcoming service inervals that are within thirty days of the current date, and allows the user to print a report that is designed to be a service notice for the relevant Customer/s which contains the customers address, phone numbers and service due date with a small pre-made text insert that advises the Customer about the upcoming service recommedation. The Form also provides the ability to print address labels for the same customers, making it quick and easy to send them out by post. The problem that I am having is that I would like the customers information that has already been printed to be removed or greyed out in someway so that the query does'nt print out duplicates but also have the ability to allow user control to reprint any result that may for any reason need reprinting.

Thanks for any help
Christopher

 

[Oldsoftboss]

I would add an extra field to your table - a check box. Think of it as a flag.
Once the record has been printed you could loop through the records and check the checkbox to mark them as printed. Simply unchecking the checkboxes would allow them to be re-printed

 

[Paladon]

Hi Oldsoftboss
Thanks for your advice I will give it a try.

Christopher