I have an issue with the Page numbering in both the 'ContactForLetterR' and the 'OrderCollectionLetterR' Reports. All these letters are only 1 page but if you're generating more than 1 letter, let's say 2 letters, the page number says 1 of 2 on the first letter and 2 of 2 on the second letter even though they're going to different people. How can you reset the page number to 1 after each letter?
That's a bit tricky and requires some VBA. I do cover it in the extended cut for Print Multiple Invoices.
Juan C Rivera
@Reply 2 years ago
I think this link might have an answer for you not sure but it does hit on page numbers and reports.
https://www.youtube.com/watch?v=o6O15KzTco4&t=1180s
on or about the 19 min time it shows how to get total pages for report and page for the group. hope it helps.
V/r
Juan
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 6.
