Barcode

[Tom Becker]

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

[lesperancer]

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

[Ronald Roberts]

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

[prashantgh]

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

[Tim Marshall]

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

[Tom Becker]

On Thu, 27 Apr 2006 02:53:01 -0400, prashantgh
<pr***************@no-mx.forums.yourdomain.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

[Tom Becker]

On Thu, 27 Apr 2006 09:37:41 -0230, Tim Marshall
<TI****@PurplePandaChasers.Moertherium> 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