Printing labels has a glitch

Ron

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

Jul 30 '07 #1

Steve

My guess is that you have to tell it how many to skip when you click the
little printer icon.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"Ron" <ro********************@verizon.netwrote in message
news:nEnri.1040$BQ.520@trnddc03...

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

Jul 30 '07 #2

John Marshall, MVP

That's a totally useless answer.

John... Visio MVP

"Steve" <So***@private.emailaddresswrote in message
news:_H*****************@newsread2.news.pas.earthl ink.net...

My guess is that you have to tell it how many to skip when you click the
little printer icon.

PC Datasheet

Jul 30 '07 #3

fredg

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

Jul 30 '07 #4

Steve

Tell fredg the same thing because his response is the same as mine!

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John Marshall, MVP" <la******@stonehenge.cawrote in message
news:c5***************************@PRIMUS.CA...

That's a totally useless answer.

John... Visio MVP

"Steve" <So***@private.emailaddresswrote in message
news:_H*****************@newsread2.news.pas.earthl ink.net...

>My guess is that you have to tell it how many to skip when you click the
little printer icon.

PC Datasheet

Jul 30 '07 #5

John Marshall, MVP

I'm glad you agree. Your post was totally useless and just another one of
your misguided attempts to post your sigline. If you had passed grade 2
English, you would have noticed it was NOT the same as FredG's post.

There was nothing wrong with FredG's post. He indicated that more
information was required, you just parroted what the OP said.

John... Visio MVP

"Steve" <So***@private.emailaddresswrote in message
news:kp******************@newsread1.news.pas.earth link.net...

Tell fredg the same thing because his response is the same as mine!

PC Datasheet

"John Marshall, MVP" <la******@stonehenge.cawrote in message
news:c5***************************@PRIMUS.CA...

>That's a totally useless answer.

John... Visio MVP

"Steve" <So***@private.emailaddresswrote in message
news:_H*****************@newsread2.news.pas.earth link.net...

>>My guess is that you have to tell it how many to skip when you click the
little printer icon.

PC Datasheet

Jul 30 '07 #6