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? 3 4117
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******@pcdata sheet.com www.pcdatasheet.com
"RC" <rc*********@ya hoo.com> wrote in message
news:3c******** *************** ***@posting.goo gle.com... 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?
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******* ********@newsre ad3.news.atl.ea rthlink.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******@pcdata sheet.com www.pcdatasheet.com
"RC" <rc*********@ya hoo.com> wrote in message news:3c******** *************** ***@posting.goo gle.com... 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" <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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Murray Elliot |
last post by:
Just wondering if anyone has any ideas on how to solve a particular
problem. A client wants to print barcode labels from their (web/php
based application). The barcode labels are very small, so I'm guessing
that doing a screendump via a standard inkjet isn't going to work
(i.e. might need somehow to print to a barcode printer!)
Any ideas where to start?
Thanks in advance.
|
by: Dave Boyd |
last post by:
Are there arguments for the built-in commands called via RunCommand
such as acCmdNewObjectReport or do they always require interactive
input? Is the code behind the built-in commands exposed anywhere? At
one time there was some code available for wizards, is this all hidden
now?
Thanks!
|
by: Hank |
last post by:
My Access 2000 code has been running for several years in our main
plant. Now we need to install it, as a stand-along application, at
remote sites, some of which are out of state.
My problem is the printer destination for special reports such as
stickers and mailing labels. The Mailing Label report is, of course,
designed here for a specific printer (Mailing Label). At another site,
the name could be completely different. Other than...
|
by: xtra |
last post by:
Hi Folk
I have written a module that allows you to type a bunch of commands in the
immediate window, for quick access to information when you are creating VB
code. Here it is, it may be helpful to you (I find it pretty fast and
friendly).... Some of it is specific to my database (I left out many as well
which were too specific), so you will have to rewrite it for yours, but you
may find it useful.... Any questions, please ask. Typing...
|
by: Mika M |
last post by:
Hi all!
I have made an application for printing simple barcode labels using
PrintDocument object, and it's working fine.
Barcode printer that I use is attached to the computer, and this
computer has drivers installed for this printer, and this printer is
shared for the network.
Question 1:
| |
by: Susan Beebe |
last post by:
I have downloaded the code described in Microsoft article Q154078. I
am trying to send raw ZPL (zebra barcode printer) code from Microsoft
access. It works just fine if I hard code the actual data in the
string being sent to the printer. However, if I prompt the user for
data or if I insert data from a particular record/field in a form
Access crashes/closes on its own.
I have included the code below, if anyone has any suggestions,...
|
by: Wayne |
last post by:
I'm using the following line of code to print only the first page of a
report:
DoCmd.PrintOut acPages, 1, 1
This works fine with one limitation. It sends the report to the default
printer. Is there some way to show the printer selection window before
sending the report to the printer?
Any help is appreciated.
|
by: =?Utf-8?B?cGF0cmlja2RyZA==?= |
last post by:
Hi everyone!
Does anyone know how can I do barcode printing?
First of all, I know I have to write a client executable,
but how do I communicate with the thermal printer?
Using software the company I work for needs to buy like Seagull Bartender,
or some other label printing software or can I get access to the printer
directly?
|
by: mkperumal |
last post by:
Hi,
I am trying to print barcode label through TSC barcode printer using text file method and sent to printing.
In the TSC programming guid i could't find how to set "No across" property to set two label in a row or 3 label in a row.
If any one know to how to do. please mail me...
regards
perumal
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |