• Printing multiple labels no longer works

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Printing multiple labels no longer works

    Author
    Topic
    #492929

    For a number of years I had a query that would print as many labels as I needed for an order, using Allen Browne’s tip below: http://www.allenbrowne.com/ser-39.html

    A Better Solution

    A simpler and code-free solution uses a query with a record for each label. To do this, you need a table containing a record from 1 to the largest number of labels you could ever need for any one record.

    Create a new table, containing just one field named CountID, of type Number (Long Integer). Mark the field as the primary key (toolbar icon). Save the table as tblCount.
    Enter the records into this table manually, or use the function below to enter 1000 records instantly.
    Create a query that contains both this table and the table containing your data. If you see any line joining the two tables, delete it. It is the lack of a join that gives you a record for each combination. This is known as a Cartesian Product.
    Drag tblCount.CountID into the query’s output grid. Use the Criteria row beneath this field to specify the number of labels. For example, if your table has a field named Quantity, enter:
    <= [Quantity]
    or if you always want 16 labels, enter:
    <= 16
    Include the other fields you want, and save the query. Use it as the RecordSource for your label report.

    It no longer works. I am running Access 2010 on a Windows 7 Pro machine. All updates are current. I wonder if that's part of the problem, an update doesn't allow that to work any longer? I did a repair of my Office Suite and that didn't change anything.

    Any ideas?

    Viewing 2 reply threads
    Author
    Replies
    • #1434460

      It would help to know exactly what is a not working and the result you are getting. What is is doing now? Do you get any error messages, etc?

    • #1434766

      Check the number of entries in tblCount – I am suspicious that it only contains one record, or no records.

      • #1434804

        Thank you! I never though to check that table. It either got corrupted or someone got in there and changed it. It had 4 blank records in it. I corrected the count and it works wonderfully now!

        Merci beaucoup!

    • #1434813

      Glad you got it solved. Thanks for sharing your solution.

    Viewing 2 reply threads
    Reply To: Printing multiple labels no longer works

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: