Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Single labels in Access Report (2000)

    Hello Access Gurus,

    Is there a way that a user can set the position for a single label to print within an Access Label report? I guess I would like something like what is available in Word where the user can select the column and row position for the single label to be printed. I would like to be able to provide a form where the user selects the column and row position for the single label or default to the top left label.

    Cheers,

    Jocelyn

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Single labels in Access Report (2000)

    See the thread starting at <post#=324477>post 324477</post#> with sample code and URLs of sites with free downloads (make sure to read to the end, there is a correction in it).

    The code in that thread is based on an MSKB: HOW TO: Skip Used Mailing Labels and Print Duplicates in Access 2002. It contains a link to download a sample reports database that demonstrates the techniques described in the article.

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Single labels in Access Report (2000)

    This works for choosing certain labels in 2002 but is there something that needs to be changed for it to work in Access 2003?

    Thanks.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Single labels in Access Report (2000)

    Not as far as I know, but I don't have Access 2003.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Single labels in Access Report (2000)

    The attached is a sample dataBase that was sent to me.
    I lay no claim to it, other than it work for me

    It may help
    threecrow

    Don&#39;t make excuses. It&#39;s what you do, not why you didn&#39;t.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •