Results 1 to 5 of 5
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919

    LABELS: serializing multiple copies from a single record

    I have a need to print serialized copies of the same label defined by a single record. The record keeps a record of the serialization history so the user can respond to a UI asking how many labels are desired and the reports OnDetail can easily attend to the serialization. My question is how to loop on a single record to satisfy the RecordSource of the report. Maybe my question is how to create a query that returns an already serialized set? I can always create a temporary table but had the idea my situation is not the first of its kind?

    Any thoughts?



    Thanks,
    Bill

    Edit: E.g., LabelText-1; LabelText-2; LabelText-3; LabelText-4;...............LabelText-n

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    You want report to repeat record?

    Here is one way to force a record to repeat http://allenbrowne.com/ser-39.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    As I mentioned earlier:
    I can always create a temporary table
    is more-or-less along the lines of what Allen described. It's simple enough to create the temporary table with as many labels as specified via the UI and in accordance with the serialization history for the label.
    Thanks,
    Bill

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    No, there is no temporary table.

    Allen describes creating a 'counter' table. This table is used in a query to force records to repeat.

    The 'counter' table can actually be generated by a query.

    SELECT DISTINCT [Tens]+[Ones] AS Factor, 10*Abs([Deca].[id] Mod 10) AS Tens, Abs([Uno].[id] Mod 10) AS Ones FROM MSysObjects AS Uno, MSysObjects AS Deca;

    That results in a query with 100 records.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    To add to June's description, this utilises a permanent table with just an ascending number in it, you link to it to provide the count and simply limit the number of records by using criteria on the number field.

    It's a highly efficient way of providing list numbers in queries, batching records and a whole host of things to avoid RBAR (Row By Agonising Row) processing.
    It's used a lot in large dataset processing in SQL server to improve speed.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

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

Similar Threads

  1. Replies: 3
    Last Post: 02-04-2014, 04:33 PM
  2. Replies: 3
    Last Post: 08-29-2013, 02:36 PM
  3. serializing labels for IMBC using access
    By harold in forum Access
    Replies: 1
    Last Post: 03-19-2013, 06:17 AM
  4. Replies: 5
    Last Post: 11-03-2011, 08:53 PM
  5. Replies: 10
    Last Post: 11-23-2010, 10:16 PM

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