MS Access database support

Author

Barcode

Tom Becker

2006-04-04, 8:30 pm

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@natpro.com

2006-04-05, 9:35 am

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

2006-04-05, 1:44 pm

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

Sponsored Links