Preset # of records for printing & avoid Duplicate Printing

[winxmun]

I have 25 records with Pending Status. Criteria of printing is Status = Approved.

1. Changed 12 records to Approved status on 06 Aug.
Printing request: 10 records in a page (with fixed header & footer)

2. Thereafter changed the remaining of 13 records to Approved status on the same day.
Printing request: Same as above, 10 records in a page (with fixed header & footer). In addition, to exclude the earlier 12 records in this report although the status is Approved.

My headache:

How to pre-set printing of 10 records in a page? :doh:
How to avoid duplicate printing of same records? :think: Thank you...:*)

[OBP]

For the previously printed records you probably need a "printed" check box added to the table and updated when the records are printed.
For 10 records per page can't you just set the page length?

[winxmun]

Hi OBP,

For Q1, you mean to create a code like after printing & check the "printed" box? Ok, will try to create the code.

For Q2, I cant set the page length coz some data is longer thus may drop to 2nd page.

Tks

[OBP]

For Q1, create an Update query that resets the "Printed" box to -1 for those that have been printed.
For Q2, it is possible to use VBA to count the records and force a Page Break, but I am not sure if that will help the dropping down to the 2nd page.

[winxmun]

For Q2, can help to provide the VBA coz not sure watz VBA? tks

[OBP]

Actually I have found you can do it using Grouping on an Autonumber ID field Select Grouping, Footer = Yes
Group on = Interval
Interval = 11
ForceNewPage = After Section

[winxmun]

Yes, managed to solve both the questions! :rotlaugh:

However, new question arised, ie how to re-start the numbering on every new page using RunningSum Property?

[OBP]

I don't quite understand the question.

[winxmun]

sorry...
Referring to the file attached, Report named AAForm, textbox named Text18. How do I control the auto number appear as “1” again on second page. Eg. I’ve 25 records to be printed. 20 records displayed on 1st page as 1, 2, 3….20, then 2nd page to start as 1, 2, 3…again instead of 21, 22, 23…

tks!

[winxmun]

Hi OBP,

Any news! Sorry for chasing coz very desperate to know...:mkay