Printing Continuous Labels (Access 2000, 2002)

Topic

New Reply

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

Reply | Quote

Replies

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?

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

Thank You Kindly

Will give a try

Reply | Quote

>>… 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.

Reply | Quote

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.

Reply | Quote

Checkout

Printing labels/Dot matrix (2003/SP1) post 516,547

HTH, John

Reply | Quote

Check the paper selection.

Reply | Quote

Mark

Checked the paper selection, and tried different paper selections.

Reply | Quote

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.

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

Pat

The problem has not been resolved, but I did use a work around (with HanV help at some tweaks), as mentioned in the thread. Final End users seem to have taken to it, we have increased our quantity and the labeling is still done by hand. Another company was giving a good try at the same, and failed, they came by to see how I made it work with the second try.

Thank you for your interest.

Reply | Quote