Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2017
    Posts
    1

    Printing the same report over multiple pages with page numbers

    Hi All - Very new to the world of access so please excuse any simple questions.

    I have a database which I have made which has only 2 tables, an account number and name of hotel.



    I have a report that is generated by the user entering the account number into a search box. The report displays the name of the hotel and a print button.

    The idea is that the user can print the report (only hotel name) onto a label with the name of the hotel followed by page 1 of 5, 2 of 5, 3 of 5, ect... depending on how many labels they want printed.

    I have managed to get it to display 1 of 1 with the following code:

    ="Page " & [Page] & " of " & [Pages]

    This however does not change if I try and print more then one.

    Do you think what I am trying to achieve is possible?

    many thanks

    Will.

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    I've used this with success:
    http://allenbrowne.com/ser-39.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 14
    Last Post: 03-15-2016, 01:22 PM
  2. Replies: 3
    Last Post: 05-11-2015, 12:35 PM
  3. Replies: 9
    Last Post: 08-26-2014, 10:43 AM
  4. Replies: 2
    Last Post: 02-08-2012, 01:03 PM
  5. One page report is printing as 666 pages
    By JackieEVSC in forum Reports
    Replies: 3
    Last Post: 12-20-2011, 10:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums