Using barcodes on Exact lay-outs with code39 font

Posted on 11. Aug, 2010 by in Exact Globe Next

Introduction

It is possible to print bar codes on Globe layouts, like a production order printout. This enables your employees to scan the order number when using it, especially for production orders this can be a big help. The bar code can be scanned with mobile scan devices (like for E-WMS) but also with a scanner attached to your PC (keyboard wedge scanning), so the order number or item code can be scanned within an application like Exact Globe.

Description

You can use attached bar code font to print bar codes within any Windows program that support truetype fonts, so including Microsoft Office applications, and Exact Globe.

Download the attachment and copy it, using Windows Explorer, to the folder C:\Windows\Fonts (or your own Windows fonts folder). Then it will be automatically installed. After installation this font will be available within windows applcations with the name “cb_Code 39 one”.

In general, when using a CODE39 type bar code, any bar code should start and stop with an asterix ( * ).

In Exact lay-outs, there are two ways to print these bar codes:
1.  calculated fields
2.  database fields with ‘introductory’ and ‘subsequent’ texts

Calculation field

Create a new calculation field in the desired ‘block’, and press ‘Change expression’.

Sample for an item code:

     CONCAT(“*”;trim([Item code]);”*”)

Set the length of the field to the length of the database field + 2.
Then change this field to font type “cb_Code 39 one” and make it rather large, like size 22 or even larger.

Database field

Another method is to place just the database field itself, with prefix and suffix text ‘*’.

‘introductory’ text = *, ‘subsequent’ text = *
alignment database field = place next to previous field without space
alignment introductory text = align right
alignment subsequent text = place next to previous field without space
font type = “cb_code 39 one”

Sample for ‘production order’ field with method ‘database field':

Possibilities in Excel

Microsoft Excel offers a lot of possibilities to generate bar code lists when using this font. You could generate (a range of) values in Excel, add prefix and suffix to these values, and print the result with this font. This will generate a list of bar codes.


In this sample, following data is used:

  • column A contains the generated or imported data.
  • column B (cell B1) is a formula field:
    English =CONCATENATE(“*”;A1;”*”)
    Dutch =TEKST.SAMENVOEGEN(“*”;A1;”*”)
  • column C is the same as B, but formatted with font “cb_Code 39 one”, size 28 pt.

Make sure to allow some space between the rows, otherwise scanning one particular bar code is more difficult.

Remarks

Adding the prefix/suffix ‘*’ is only mandatory when using this font for CODE39 bar codes. When printing CODE39 bar codes with bar code labelling software like Bartender, the prefix and suffix are automatically added by the software.

Tags: , , , , ,

No comments.

Leave a Reply