Results 1 to 3 of 3
  1. #1
    klynn47 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Apr 2016
    Posts
    2

    Trouble creating mailing label


    I have an Access Database that has as one of its fields a lookup. When I try to create mailing labels using the data from the database, for the fields that are lookup, I'm getting just an integer to show up which I assume is the id of the field. How can I get it to print the text on the mailing label and not the number? If I create a simple report, it shows the data, but not if create the label. Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    pick the ID from the combo box,
    the report will open a query using that box. pull all the data needed for the label using that key.

    select * from table where [id]=forms!frmReport!cboBox

  3. #3
    klynn47 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Apr 2016
    Posts
    2
    Quote Originally Posted by ranman256 View Post
    pick the ID from the combo box,
    the report will open a query using that box. pull all the data needed for the label using that key.

    select * from table where [id]=forms!frmReport!cboBox
    Is there a way to do that in the Reports tab on Access?

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

Similar Threads

  1. Macro to print a mailing label
    By AntnyBrusk in forum Macros
    Replies: 3
    Last Post: 06-23-2015, 10:07 AM
  2. Creating a temp mailing list
    By bbrazeau in forum Programming
    Replies: 2
    Last Post: 05-06-2013, 12:23 PM
  3. generating mailing label reports
    By Glider_man in forum Reports
    Replies: 7
    Last Post: 04-26-2011, 10:03 AM
  4. access mailing label message
    By fwit in forum Access
    Replies: 1
    Last Post: 07-14-2010, 01:36 PM
  5. Printing multiple copies of a mailing label
    By Flight Planner in forum Reports
    Replies: 1
    Last Post: 10-19-2006, 08: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
  •  
Other Forums: Microsoft Office Forums