Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Labels (Access 2000)

    Once I create a report of labels on for example my Staff Table, how can I keep from wasting space on the last page of the labels if the last page of labels prints the few remaining Staff that did not print on previous "full pages"...is there a way to loop maybe the label process from the beginning again, but only until the last page is full...and then Stop the loop. Figured if there was a way you all would know it...am I going to just have to deal with wasting departmental money by having that last sheet contain just a few needed labels, and the rest "empty"...I suppose I could just re-insert the last page of labels the next time I print, and disgard the completed few at the top that get printed "over"...any ideas?
    Thank you
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Report Labels (Access 2000)

    I don't understand your description, but perhaps you can use the technique from MSKB article HOW TO: Skip Used Mailing Labels and Print Duplicates in Access 2000.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Labels (Access 2000)

    Just an idea and could be a quick fix. If you have say 27 staff and 24 labels per page couldn't you do a TOP 24 sql query and run the reports from there. Sorry, dirty trick but a practituioners response without the code.
    Jerry

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Labels (Access 2000)

    Hans,

    Thank you. This article makes more sense then I did. It will work.

    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Labels (Access 2000)

    Could, if I was any darn good at SQL... <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> I use it minimally, and have never used the TOP statement in one, so wouldn't know how to phrase it. Am still curious with a Top statement, what happens to the last 3?
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Labels (Access 2000)

    In SQL view type

    SELECT TOP 24 *
    FROM tblStaff;

    change the number to what you want. Last 3 in my example will not show
    Jerry

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Labels (Access 2000)

    Jerry,

    Understand your SQL query...it works well. However, if I have 27 employees, and the top 24 are printing on page 1, I am not understanding where the other 3 are going to be printed except on the last page, where I will be wasting 21 unused labels once that second page prints.
    I am gathering the info Hans gave at the link above, and see they have given a method to print on those remaining 21 labels and skip the 3 used ones...believe I'll stay with that thought as it will work well enough. Sorry Jerry, I'm missing something in what your saying to help me understand...but, gees...this is the 4th Monday I've had this week, so I'm not suprised with myself at all. Sorry. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Labels (Access 2000)

    Sorry I misunderstood your question but on reading the article realised what you wanted. Mine was just to get rid of the last 3 of the example and just have a sheet of 24, not very practicle in hindsight, sorry. But, hey grab the Rose bud and not the thorn at least I taught you the TOP sql bit
    Jerry

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Labels (Access 2000)

    You did at that...and that is "exactly" why I love this place. <img src=/S/salute.gif border=0 alt=salute width=15 height=20>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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