Results 1 to 4 of 4

Making report list item multiple times

  1. #1
    DBR138 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    4

    Making report list item multiple times

    Hello, I have a query that creates a list of items we need to pick (Screenshot attached). I also have a report that allows us to print pick labels (Screenshot attached). I need to find a way to make it print X number of labels for each item where X= the value in list field # OF CONT. Is it possible to accomplish this within the report? I am fairly new to Access so any help would be greatly appreciated.



    Click image for larger version. 

Name:	qry_2nd Floor Replen.JPG 
Views:	13 
Size:	75.5 KB 
ID:	32080Click image for larger version. 

Name:	Report.JPG 
Views:	13 
Size:	138.1 KB 
ID:	32081

    Thank you!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,038
    if you put all the items in a list box on a form,
    then loop thru them printing as you go. The #copies is the bound value in the list box.
    Or you can have it grab the record key and only print that 1 persons label

    Code:
    sub btnPrint_click()
    For i = 0 To lstBox.ListCount - 1
       iCopies = lstBox.dataitem(i)   'get new item
       lstBox = vItm               'set list box to item
         
       PrintMultipleCopies "rMyReport", iCopies
    Next
    End Sub
    
    
    Public sub PrintMultipleCopies(pvRpt,pyCopies as byte)
        Dim i As Byte
        For i = 1 To pyCopies
            DoCmd.OpenReport pvRpt
        Next 
    End Function

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,583
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    13,144

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

Similar Threads

  1. Replies: 1
    Last Post: 01-12-2018, 06:13 AM
  2. Replies: 3
    Last Post: 01-11-2018, 07:12 PM
  3. Making a multiple choice list searchable
    By dwheatley in forum Queries
    Replies: 8
    Last Post: 12-13-2017, 02:41 AM
  4. Replies: 1
    Last Post: 04-21-2014, 07:00 AM
  5. Making a list on a report
    By tbroy in forum Reports
    Replies: 2
    Last Post: 04-04-2012, 09:01 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
  •  
Tech Forums: Microsoft Office Forums