Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2009
    Posts
    8

    Unanswered: Setting a Label in Access - HELP PLS

    Hi,
    I'm trying to setup a label as followed:

    Order# <--This constant changes

    Company Name City

    ITEM_1 ITEM_5 <--Must be only two (2) columns

    ITEM_2 ITEM_6

    ITEM_3 ITEM_7

    ITEM_4 ITEM_8

    I have it almost done, but the items are coming out vertical. So I got stuck.

    Since my data is in Access, I would to be created in Access.


    I can do it within Access as a label form or through VB.

    Thanks in advance. I appreciate your help.

    LouisC

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I don't understand. Could you please re-explain?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Aug 2009
    Posts
    8
    Basically, i'm trying to setup labels with 4 columns;

    The Order # will change with each label.

    item1 qty item2 qty
    item3 qty item4 qty
    item5 qty item6 qty
    item7 qty item8 qty


    It will only have 8 items with quantities per label per order #.

    Thanks
    LouisC
    Last edited by LouisC; 04-17-10 at 23:56. Reason: update

  4. #4
    Join Date
    Aug 2009
    Posts
    8
    Can somebody me out on this?

    Thanks
    LouisC

  5. #5
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Your terminology is obviously inadequate.

    Labels display descriptive text such as titles, captions, or brief instructions. Labels don't display values from fields or expressions, labels are always unbound (i.e. not linked to data), labels don't change as you move from record to record. (From: Microsoft Office Access 2003 Visual Basic Reference). Labels also do not have columns.

    Are you talking about listboxes?
    Have a nice day!

  6. #6
    Join Date
    Aug 2009
    Posts
    8
    I'm strictly speaking about labels to place on carton boxes, like Avery type labels, also shipping but using addresses type format.


    Thanks

    Louis

  7. #7
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Are you talking about a REPORT with labels? If so, why not simply use the report wizard to create labels and then modify as needed. Again, I still don't understand and you need to be a bit more descriptive on EXACTLY what you're trying to do. Help us so we can help you.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

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
  •