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
    5,846
    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
    42,927
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

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

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