Results 1 to 4 of 4

Mailing Labels (Printing multiple copies of same record)

  1. #1
    OldCityCat is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    30

    Mailing Labels (Printing multiple copies of same record)

    After using the Label Wizard to create my label, I run my query to select a single record to print, When I do a print preview I only see that one record.
    If I modify me query to return all records then all records show in print preview.
    So what is the trick for printing say 20 copies of a single record?

    Thanks in advance for any and all suggestions
    OldCityCat

  2. #2
    June7's Avatar
    June7 is offline Moderator
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,852
    Solution I use is VBA procedure to copy duplicate records to a temp table. I can produce up to 24 little labels of the same record on one page. The report is setup for columnar output.

    Method in this article looks promising, I will have to explore http://support.microsoft.com/kb/207664

    Otherwise, print 20 copies of the report.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

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

  3. #3
    OldCityCat is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    30
    I'll play with your VBA option.

    But why should we have to do a work around for such a common process, you'd think it would be built into Access.

    Otherwise, print 20 copies of the report.
    I tried that but only one record per page
    How do you get more the one record on a page when printing copies?

  4. #4
    June7's Avatar
    June7 is offline Moderator
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,852
    Need work around because Access is not a word processor, it is a data management tool and it manipulates records.

    You won't, you are printing the same report 20 times, not one report with 20 records. I know, bad option but I'm not holding anything back, I give, you pick.

    Another option might be a label printer. I've never worked with any and don't know how well Access interacts with them.

    UPDATE: tried the code method from link in post 2 - works great!
    Last edited by June7; 08-30-2013 at 01:17 PM.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

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

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

Similar Threads

  1. Mailing labels formatting
    By Keith Sayers in forum Reports
    Replies: 11
    Last Post: 12-31-2012, 11:13 PM
  2. Mailing Labels from a Search Form
    By waltb in forum Access
    Replies: 4
    Last Post: 03-08-2012, 04:03 PM
  3. Replies: 1
    Last Post: 11-30-2011, 05:06 PM
  4. Replies: 5
    Last Post: 11-03-2011, 07:53 PM
  5. Printing multiple copies of a mailing label
    By Flight Planner in forum Reports
    Replies: 1
    Last Post: 10-19-2006, 07:16 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