Azalea Software, Inc.

Printing Code 39 Bar Codes in Access

If you are printing Code 39 bar codes from within an Access project, the easiest thing to do is use our barcode.dll after you've installed our fonts on your machine.

Extract barcode.dll into either your \WINDOWS\SYSTEM or \WINNT\SYSTEM32 directory.

Extract and save our sample database C39sampleinput.mdb.

In the database window, click "Modules".

You may close this database (remembering its path) and open your own.

Import Azalea functions. Open your database, in our example, C39sampleinput.mdb. From the File menu, select Get External/Import.

Give the path to the sample database (C39samplecode.mdb). In the "Import Objects" window, click the "Modules" tab, highlight "Code39" and click "OK".

Query design. Select "Queries".

Double click Design view". Select the table you wish to print bar codes from. Click "Add" and then "Close".

In the mini window click twice on the field containing your Code 39 input data. Uncheck the "Show" check box (we just want the bar code). Check the "Show" check box. Right-click on the first row field and select "Build".

In the Expression Builder left pane, expand "Functions", Expand "C39sampleinput"; on the right pane, select "AzaleaCode39". Note: While this example refers to Code 39, the same holds true for Code 39 ASCII.

Replace "InputString" with the name of the input data field (in our example, "C39" without the quotes). Click "OK". Save and name your query. Select your entire query field, go to File menu/Format/Fonts and select one of Azalea's Code 39 fonts and set the size point.

Run the query: At main database window, double-click on the name of your query.