Results 1 to 2 of 2
  1. #1
    dyhunter is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2014
    Posts
    9

    Number of labels


    Ok, I found how to create a query and then print labels based on that query. Now, can I make it print the correct number of labels based on other data already in my DB. For instance, if my data shows I have 3 pcs of one thing, and 4 of another, Can I use this data to make access print 3 labels for the one, and 4 for the other?

  2. #2
    nrgins's Avatar
    nrgins is offline some guy
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    62
    There are a couple of ways you can do this.

    You can compile all your label data into a temporary table, and then base your labels off the temp table. That would require looping through your query using a recordset in code, and then writing it to the temporary table the correct number of times.

    The other way would be to print the labels one by one, printing the appropriate number of times for each one.

    Obviously the first way is superior.

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

Similar Threads

  1. Hide labels
    By wiredgecko in forum Access
    Replies: 7
    Last Post: 11-16-2014, 05:27 PM
  2. Replies: 0
    Last Post: 01-30-2012, 01:20 PM
  3. Labels
    By cbrsix in forum Reports
    Replies: 5
    Last Post: 12-22-2011, 12:15 PM
  4. labels duplicating themselves
    By RedGoneWILD in forum Forms
    Replies: 2
    Last Post: 08-17-2010, 07:42 AM
  5. Labels
    By MFS in forum Programming
    Replies: 2
    Last Post: 01-28-2010, 07: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
  •  
Other Forums: Microsoft Office Forums