Mark report pages as printed?

cozzykim

Registered User.
Local time
Today, 05:32
Joined
Apr 6, 2006
Messages
10
Hi all,

Is there a way to automatically mark a record when it is printed from a report (to avoid duplicating invoices for example)

TIA

Kim
 
I'm affraid you'll have to build this functionality into your database/form/report


No auto gizmo's that I'm aware of :(
 
Thanks for the reply Ken

How could this be done, how about a non printing field on the data entry form "Already Printed?" (I have a lot of previously printed records) with a default value of "Yes" and a drop down box with "No/Yes" then print from a query looking for a "No" ?
A bit clunky, but at least then I could see on the form straight away whether it has been printed (and I could defer or miss out ones that are still in progress)

I tried a check box but when I check the record I want in the form it check all the other records as well?

Any other (elegant) solutions?

TIA

Kim
 
There a couple of ways this can be done but knowing so little about your project it is hard to advise. Everytime the report is opened is it printed?
 
Hi and thanks,

the report is basically a preview of the record to be printed, with company heading and a number of fields that make up a service visit report.
They can be viewed at any time but are only printed to accompany an invoice or as a requested duplicate.
I normally click "print" in report view and then select the "pages from - to" in the printer dialogue.
I need to know whether they are still work in progress or have been printed and sent to the customer when doing an invoice run.

I have another question about merging database table fields which I'm going to ask in the tables forum.

Kim
 
Sounds like you need to accommodate this business rule/process with something other than some 'has it been printed' logic. I would do a 'Has customer been invoiced' fld and manage it that way...
 
First I would add a field to the table where the records are called Printed. Then I would add some code to the reports On_open event to trigger an update query to update the records on the report to printed. This is assuming that everytime the report is opened it is printed.
 
The problem here is that hard coding an update in the OpenEvent of the Report may give a false result, what happens if the printer jams, runs out of ink etc. It's better to use a message box asking for confirmation of a successful print run and then run the update
 
I can't really use an On_open event because the reports get opened and modified sometimes before completion but I've got some ideas to look at now so I'll explore them a bit, thanks

Kim
 
OnPrint success

Try making an error handler using the OnPrint event. Can you make a PrintedField=OnSuccess(Printed(Me)) routine?
 

Users who are viewing this thread

Back
Top Bottom