send commands to barcode label printer with docmd.printout ??

[RC]

I am using docmd.printout to send Reports (formatted as labels) to a
barcode label printer. I need to collate the labels so that I print
lable 1 twice, then label 2 twice, then label 3 twice, etc. The
printout collate option only seems to work if the printer supports it.
The label printer I am using doesn't collate via the printout command
option, but it does have a command language that will collate IF I can
find a way to send the command to the printer. Any ideas? Maybe I
need to use something besides printout to control the printer?

[PC Datasheet]

Just a thought ---

Base your label report on a query and then try unioning the query to itself.
You should then get two of every label.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"RC" <rc*********@yahoo.com> wrote in message
news:3c**************************@posting.google.c om...

I am using docmd.printout to send Reports (formatted as labels) to a
barcode label printer. I need to collate the labels so that I print
lable 1 twice, then label 2 twice, then label 3 twice, etc. The
printout collate option only seems to work if the printer supports it.
The label printer I am using doesn't collate via the printout command
option, but it does have a command language that will collate IF I can
find a way to send the command to the printer. Any ideas? Maybe I
need to use something besides printout to control the printer?

[RC]

Thank you so much! I WAS printing the first label, then printing the
first label again, then incrementing the numbers, then printing the
second label, etc. I had to put in a long pause between each print so
that printer could keep up and not get overwhelmed with so many
separate print tasks. But your simple and elegant solution prints
each label twice, and it's fast and accurate. Thank you. I don't
have much experience with queries and now I see why they are so
important.

"PC Datasheet" <no****@nospam.spam> wrote in message news:<_H***************@newsread3.news.atl.earthli nk.net>...

Just a thought ---

Base your label report on a query and then try unioning the query to itself.
You should then get two of every label.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"RC" <rc*********@yahoo.com> wrote in message
news:3c**************************@posting.google.c om...

I am using docmd.printout to send Reports (formatted as labels) to a
barcode label printer. I need to collate the labels so that I print
lable 1 twice, then label 2 twice, then label 3 twice, etc. The
printout collate option only seems to work if the printer supports it.
The label printer I am using doesn't collate via the printout command
option, but it does have a command language that will collate IF I can
find a way to send the command to the printer. Any ideas? Maybe I
need to use something besides printout to control the printer?

[Michael \(michka\) Kaplan [MS]]

"PC Datasheet" <no****@nospam.spam> wrote...

www.pcdatasheet.com

I wish you would fix up the T.S. Eliot quote ypu have there, which is both
in the wrong order and messing up a word. It seems risky assuming that no
one who might want to hire you would have any sort of literary background
that would cause this to sour them....

Beyond that, anyone who understands the context of The Rock in general and
that poem in particular will likely conclude that either you do not have
such an understanding or that you are insulting them. But thats another
matter, and you should feel free to either fawn ignorance or insult
potential customers as much as you like. :-)
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.