I am printing 4 X 8 labels from a report in Access. Each label needs
to have it's own barcode.
The booklet that comes with the SATO printer says I should send a
command to the printer. It starts like this <STX><ESC>A.. .
Can I do this in access? Where would I put this command line?
--
NewsGuy.Com 30Gb $9.95 Carry Forward and On Demand Bandwidth 6 4033
I think STX is chr(1) and ESC is chr(27)
so if you have a text box on your report with a control source of
CHR(1) & CHR(27) & "A", that should do the trick
Tom Becker wrote: I am printing 4 X 8 labels from a report in Access. Each label needs to have it's own barcode.
The booklet that comes with the SATO printer says I should send a command to the printer. It starts like this <STX><ESC>A.. .
Can I do this in access? Where would I put this command line?
The control characters for controlling a transmission are
generally decimal 2 thru 37 and 127 for a DEL.
If your printer requires control characters, then you may need
to use some of the following.
Some devices that require a start of text (STX), may also require
an end of text (ETX) to tell it this is the end of the control
stream.
You can do this with concantentation
CHR(2) & CHR(27) & Your Data & Chr(3)
Check the printer manual to see if any control characters are
required after, such as ETX, LF, CR, or HT.
01 SOH - Start of Header
02 STX - Start of Text
03 ETX - End of Text
04 EOT - End of Transmission
05 ENQ - Enquire
06 ACK - Acknowledge
07 BEL - Bell
08 BS - Backspace
09 HT - Horizontal Tab
10 LF - Line Feed
11 VT - Vertical Tab
12 FF - Form Feed
13 CR - Carriage Return
16 DLE - Data Link Escape
21 NAK - Negative Acknowledge
23 ETB - End of Transmission Block
27 ESC - Escape
127 DEL - Delete
HTH,
Ron
hi tom,
i am facing the same problem with sato printer but i am using vb/
vb.net to print.
so, if u have found ant solution can u pls. tell me.
thnks,
prashant.
--
prashantgh
------------------------------------------------------------------------
prashantgh's Profile: http://www.dbtalk.net/m241
View this thread: http://www.dbtalk.net/t297373
Tom Becker wrote: I am printing 4 X 8 labels from a report in Access. Each label needs to have it's own barcode.
The booklet that comes with the SATO printer says I should send a command to the printer. It starts like this <STX><ESC>A.. .
Can I do this in access? Where would I put this command line?
Tom, I'm not familiar with the SATO printer, but I print barcodes with
various reports and job assignments all the time.
All you need is a bar code font. Format the report for the label size
and for the data you need barcoded, use the barcode font for that text
box. You will also likely need a delimiter for the bar code reader to
be able to read the barcode.
For example, when I print work orders for our trades to do work, the
work order text box that is barcoded has a controlsource like:
="*" & WO_NUMBER & "*"
Where WO_NUMBER is the work order number field. An asterisk is a very
common delimiter for bar code readers that scan code 39 type barcodes.
If you don't have a bar code font, you can find them out there. I don't
have any URLs handy but can try and dig one up for you if necessary.
Hopefully this is of some help to you.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
On Thu, 27 Apr 2006 02:53:01 -0400, prashantgh
<pr************ ***@no-mx.forums.yourd omain.com.au> wrote: hi tom,
i am facing the same problem with sato printer but i am using vb/ vb.net to print.
so, if u have found ant solution can u pls. tell me.
thnks,
prashant.
To get the bar code to be part of an access report I think we need
to buy a font. I found good stuff by searching google.
If you are not using an access report there might be a way to issue a
command using Shell. I don't really know though. Someone suggested
changing the <ESC> and the others like that from the Sato booklet, to
ASCII numbers.
--
NewsGuy.Com 30Gb $9.95 Carry Forward and On Demand Bandwidth
On Thu, 27 Apr 2006 09:37:41 -0230, Tim Marshall
<TI****@PurpleP andaChasers.Moe rtherium> wrote: Tom Becker wrote:
I am printing 4 X 8 labels from a report in Access. Each label needs to have it's own barcode.
The booklet that comes with the SATO printer says I should send a command to the printer. It starts like this <STX><ESC>A.. .
Can I do this in access? Where would I put this command line?
Tom, I'm not familiar with the SATO printer, but I print barcodes with various reports and job assignments all the time.
All you need is a bar code font. Format the report for the label size and for the data you need barcoded, use the barcode font for that text box. You will also likely need a delimiter for the bar code reader to be able to read the barcode.
For example, when I print work orders for our trades to do work, the work order text box that is barcoded has a controlsource like:
="*" & WO_NUMBER & "*"
Where WO_NUMBER is the work order number field. An asterisk is a very common delimiter for bar code readers that scan code 39 type barcodes.
If you don't have a bar code font, you can find them out there. I don't have any URLs handy but can try and dig one up for you if necessary.
Hopefully this is of some help to you.
Thanks! I found a good web site for it.
--
NewsGuy.Com 30Gb $9.95 Carry Forward and On Demand Bandwidth This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: CHANGE username to westes |
last post by:
What are the most popular, and well supported, libraries of drivers for bar
code scanners that include a Visual Basic and C/C++ API? My requirements
are:
- Must allow an application to be written to a single interface, but support
many different manufacturers' barcode scanning devices. I do not want to
be tied to one manufacturers' software interfaces.
- Must support use of the scanner from Visual Basic, and ideally from C/C++
and...
|
by: Tom Turner |
last post by:
Here's the background on my situation. The question follows ---
We have 600 units of mail going from our business to various Post
Offices every morning. Every unit is accompanied by a paper
Verification form which is signed and dated by a postal employee
and returned to our office as proof of delivery.
The Verification contains a 24 character barcode which holds a
non-unique 5 digit postal zip code at pos 5-9, and a unique 10-
digit...
|
by: |
last post by:
Hi all, we have a need to barcode encode and display a record identifier
(number) both in html in the browser and through fdf in adobe acrobat in
realtime. Is this possible? Can anyone make any recommendations on software
to do this?
thanks!
|
by: Aaron Bronow |
last post by:
I have an asp.net application which loads a Crystal Reports
ReportDocument, passes in parameters for selecting data from the
report's database connection, renders the report for previewing on the
client then allows the user to print the report on a networked printer.
To avoid having to launch an external application on the client I use a
server-side print method. When I call ReportDocument.PrintToPrinter the
report comes out fine but the...
|
by: Samuel Shulman |
last post by:
I would like to add barcode functionality to my POS program
How does one attach barcode reader is it usually USB port
How can the program get the data read by the device
Thank you,
Samuel
| |
by: Alper Ozgur |
last post by:
Hi;
How can i capture and decode the barcode that reading by an usb Barcode
reader?
|
by: nmrpa91290 |
last post by:
Hi,
I am in the design phase of building a database that will track the
productivity of my warehouse. I am thinking of using a barcode
scanner to assist me with this. Employees will hopefully be scanning
a barcode which will communicate to the computer that the employee did
some type of task. Employees will be identified by ID badges which
will contain string data to identify them and hopefully log them in.
Is this a good way to keep...
|
by: jim |
last post by:
I need to have 2 simple barcode reader applications finished by midnight
tonight. I have never written any barcode reader software and need any help
that you may be able to offer.
I do not know what type of barcode the user will have, so I need to be able
to accept input from any industry standard barcode reader.
I need to check the barcodes scanned to see if they are in a database of
acceptable barcodes and simply show ACCEPT or...
|
by: sam |
last post by:
can someone show how to change print font width & heigh scaling? I am
writing a code for barcode printing on smaller label. I do not want change
font size, because this may cause the bar code reader could work well is bar
code is too small, I want to keep same font heigh but smaller font width? is
it possible to do that?
|
by: divyac |
last post by:
I am doing an inventory control project and i want to create barcodes for the products in addition to the product details in a form.The form values should be submitted to the database to retrieve for future use.How to generate a barcode,how to load it in the database and retrieve it back.can i generate the barcode and submit the form with a single "submit" button?pls guide me in this issue.The following code is used to generate a barcode.i just...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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...
| |