Re: Printing labels has a glitch

On Mon, 30 Jul 2007 15:41:07 GMT, Ron wrote:

Hi All,

I've got a report that prints mailing labels. It utilizes a routine that
asks the number of labels to skip, the number of each label to print, and
then prints. It works really well on a print preview. But,when I print to
the printer it disregards the number of labels to skip.

I preview all the reports I've got and then have a little printer icon to
click on if the user wants to actually print (my attempt at saving trees).
Every other report I've got shows the preview, and then prints successfully
to a printer in a format identical to the preview. So, why would my label
program not print that way? If I choose to skip 5 labels, on the preview it
does...but the printer starts at the top left corner of the page, almost
every time. Sometimes, depending on how many I ask it to skip it'll show up
fine on the preview, but then it'll skip 2 on the printer...but it's never
what I asked for.

So, I guess my question would be why would it work on the preview, and not
on the actual printing? Without posting all the code, modules, etc...can
anyone think of a reason for this?

TIA
ron

It's difficult to reply because you haven't shared with us the code or
method used to input the number of label positions to skip. We're not
mind readers, especially on Mondays... :-)

I would suspect that somewhere between opening the Report in preview,
and printing it, you have code that is closing the form that asks for
the input of how many records to skip.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Re: Printing labels in a certain row or column on the sheet
    ... The generic report wizard in Access ... > assumes you have an entire page of blank labels. ... > page back into your printer and choose a start printing ... Private Sub Detail_Print ...
    (microsoft.public.access.reports)
  • Mailing List code bug for FredG
    ... address labels and to start at a specific position on the first page. ... Then add a Report Header to the label report. ... Name this control SkipCounter ... then how many times to repeat each label. ...
    (microsoft.public.access.reports)
  • RE: Making a report that can leave records blank based on user inp
    ... > labels but also lets you skip the labels already used. ... > print multiple copies of the same report. ... Set the Height property for both the report header ... >> I am making a database of a large video archive. ...
    (microsoft.public.access.reports)
  • RE: Making a report that can leave records blank based on user inp
    ... I also have a DVD database that I designed in ms Access. ... >> labels but also lets you skip the labels already used. ... >> print multiple copies of the same report. ... Set the Height property for both the report header ...
    (microsoft.public.access.reports)
  • RE: Report Parameters and Filters
    ... also stops two labels of the same value being scanned. ... No the report is not filtered by the printed field, ... So that is why I tried to set the parameters in reports query from controls ... Dim cnn As New ADODB.Connection ...
    (microsoft.public.access.reports)