Printing Terms on the Back of a Statement or Invoice

  • Thread starter Thread starter Phuff13
  • Start date Start date
P

Phuff13

I have set up a Statement in Access, and i would like to set it to print the
terms on my the back of each statement with my HP Duplex printer. I have
tried everything i can think of, can anyone help me out with this.

Thanks
 
Presumably you have created report with:
- a group header for the InvoiceID (invoice number, date, and address
panel),
- a detail section (for the line items on the invoice),
- a group footer for the InvoiceID (for the total.)

In the Sorting And Grouping box, add InvoiceID as second time.
For this 2nd one, set Group Footer to Yes.
This gives you 2 group footers for each invoice.
You can now place the text you want in the new group footer.
By setting the Force New Page property of the sections, this will end up on
the back of the invoice.

The only remaining problem would be what happens if you have a really long
invoice with lots of items so it spills over onto a second page. That would
throw the double-siding for all the remaining invoices in a print run. If
you are concerned about that, see:
Duplex reports: start each group on an odd page
at:
http://allenbrowne.com/ReportDuplex.html
 
I am sure you have thought of this already, but if your HP Duplex printer has
multiple paper trays you could pre print a setof statement backs then place
them in the second tray of the printer. Now im relatively new to access so
not sure how you would do it but i am sure you could then set up your reports
to print those that need the back sheet (eg statements) through the paper
tray with the prepared paper and those that dont need it through the regular
tray feeder.

Not too much help on the access part sorry about that but that may work for
you!

Ben
 
Thanks a ton for the answers Allen, I downloaded your example and your
codeing for the back page printing. When i tried to follow the directions
and do the same with my page i got an error that read:

Microsoft Access can't find the macro '.'

can anyone be of any assistance?
 
The idea is to set the On Format property of the section to:
[Event Procedure]

Then click the Build button (...) beside that.
Access opens the code window.
Set up your code as shown in the example:
http://allenbrowne.com/ReportDuplex.html

The sample database shows how to set the property like that.
 
Back
Top