Results 1 to 2 of 2
  1. #1
    halnurse is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2016
    Posts
    22

    Selecting Start Position for label printing


    I am trying to create a form that allows users to select the position that the labels are printed on to limit wasted labels. I found this article but I have limited VBA knowledge. Does any one know if this code works for queries or how I could modify it to allow for the data source to be a query? Thanks for all your help. https://www.techrepublic.com/blog/ho...-on-the-sheet/

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Nothing in that code prevents using a query as the report RecordSource. You just have to use the 'duplicate' table with the empty records in that query.

    If you meant by 'data source' the source used for the Recordset in the code, yes can reference a query instead of table.
    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.

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

Similar Threads

  1. Replies: 3
    Last Post: 08-25-2016, 02:55 AM
  2. Selecting a field automatically selects the label
    By Access_Novice in forum Forms
    Replies: 1
    Last Post: 09-26-2013, 06:02 PM
  3. Replies: 0
    Last Post: 11-07-2010, 01:28 PM
  4. Label printing problem
    By igiatakis in forum Queries
    Replies: 2
    Last Post: 09-13-2010, 08:27 AM
  5. Printing multiple copies of a mailing label
    By Flight Planner in forum Reports
    Replies: 1
    Last Post: 10-19-2006, 08:16 AM

Tags for this Thread

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