Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Continuous Labels (Access 2000, 2002)

    Has anyone here had to print continuous mailing labels and actually got it to work?
    I use the label wizard to create the labels, and when they print, I
    threecrow

    Don't make excuses. It's what you do, not why you didn't.

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

    Re: Printing Continuous Labels (Access 2000, 2002)

    Laser and inkjet printers can't print right to the bottom edge of the paper; if you set the bottom margin to 0, it will be reset to the minimum for your printer.

    Apart from that, printing labels from Access works fine, it is used in many of my databases. I don't understand why you'd get one label, then 22 empty ones. Are you sure the record source of the label report is OK?

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Printing Continuous Labels (Access 2000, 2002)

    >>... did check page setup, this show bottom as 10, and will not let me change it.<<

    Do you mean the Bottom Margin? And if this is set at 10", then this is your problem.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Printing Continuous Labels (Access 2000, 2002)

    Apologies, In my haist I did not mention that the printer was a Dot Matrix.

    You are correct labels printed from Access are fine, when using Laser or Ink Jet printer.
    I do not understand either, I use the label wizard, the label of choice was an Avery Continuous 4013.
    The wizard set top margin at 0.166 and the bottom margin at 10.
    Most interesting.

    Six hours of sleep a night, your a lucky man.
    threecrow

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

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

    Re: Printing Continuous Labels (Access 2000, 2002)

    I have no experience using a dot matrix printer with Access. What are the settings in the Columns tab of the Page Setup dialog?

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

    Re: Printing Continuous Labels (Access 2000, 2002)

    Yes Sir, Your right that what what my problem is.
    I manually change the setting and it flips right back.
    I even tried doing the labels via Word (mail merge) and got the same results.

    I think that I'll have to create from scratch.
    threecrow

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

  7. #7
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Continuous Labels (Access 2000, 2002)

    Checkout

    Printing labels/Dot matrix (2003/SP1) <post#=516,547>post 516,547</post#>

    HTH, John

  8. #8
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Printing Continuous Labels (Access 2000, 2002)

    Check the paper selection.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Printing Continuous Labels (Access 2000, 2002)

    A relatively simple solution is to specify a group header for Carrier and for Bundle (in the Sorting and Grouping window), and to make both group headers the same height as the detail section.

    You'll get two blank labels at the start of the report. If you want to suppress these, create On Format event procedures for the group headers:

    Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
    Me.GroupHeader0.Visible = (Me.Carrier > 1)
    End Sub

    Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
    Me.GroupHeader1.Visible = (Me.Bundle > 1 Or Me.Carrier > 1)
    End Sub

    where GroupHeader0 and GroupHeader1 are the names of the Carrier group header and Bundle group header, respectively.

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

    Re: Printing Continuous Labels (Access 2000, 2002)

    Hans

    Dot Matrix works fine for Reports and such, But as I am learning Access does not seem to like Continuous Labels.

    I have found another method, using Avery 5160 labels they are perfed between the columns, I set them to print down and then across. Its just a matter breaking apart the columns, and a little tape to make a strip.

    These labels are used for mailings, that the place where I work is doing, At present I have the labels sorted by three fields, first one being Carrier, Second being Bundle, the Third being a Sequence (Number). I start a new page (Sheet) on change of Carrier and Bundle, or when the Bundle only changes. Is there a way that I could print these in a straight run with a blank label at Bundle change and two or three blank labels at carrier change. I do have these field printed on the label, example below.

    1_1_1
    1_1_2
    1_1_3
    Blank (would like to do this)
    1_2_4
    1_2_5
    Blank
    Blank
    2_3_6
    2_3_7

    Hope I made this understandable.
    threecrow

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

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

    Re: Printing Continuous Labels (Access 2000, 2002)

    Thank You Kindly

    Will give a try
    threecrow

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

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

    Re: Printing Continuous Labels (Access 2000, 2002)

    Mark

    Checked the paper selection, and tried different paper selections.
    threecrow

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

  13. #13
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Printing Continuous Labels (Access 2000, 2002)

    You may just be running up against the limitations of dot matrix printers. Your report probably has one labels on it in design view and the printer is interpreting the output from the app to mean that it should do a page feed between labels. Dot matrix printers still have their place, but they can be hard to work with from Windows, as you have discovered. Is there some reason you MUST use a dot matrix printer? If there is, you may have to start searching for ways to send the ESC codes that drive the printer directly from Access instead of relying on Windows to translate for you. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    You might try tweaking the printer properties from page setup to use the specific printer rather than the default printer and then see if your driver offers you a means of printing the report as graphics or a bitmap. That can make a lot of difference when printing to dot matrix, as I recall, but I haven't had such a printer in years, so I can't test it.
    Charlotte

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

    Re: Printing Continuous Labels (Access 2000, 2002)

    Charlotte

    The only reason for the labels to be continuous, is the folks that do the labeling, do it by hand.
    Over the years they have developed a method that world put the auto labeling machines to shame.
    Two people, 1000 items to be labeled, sorted and bundled (we expect this number to grow to 5000 by weeks end).
    These folks had them done in 20min.

    Thanks HanV for opening my eyes to height of the group headers.

    Thank you kindly Miss Charlotte
    threecrow

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

  15. #15
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Continuous Labels (Access 2000, 2002)

    This is late, but I was searching for another topic and ran across yours, and don't think anyone mentioned to make sure you are using tractor feed for your continuous dot-matrix labels, I think it's in your paper source select.

    thx
    Pat

Page 1 of 2 12 LastLast

Posting Permissions

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