Azalea Software, Inc.

UPC, EAN, JAN, Bookland (ISBN), & ISSN Bar Codes in Access

If you are printing UPC 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 UPCsampleinput.mdb in the database window, click "Modules".

Close this database (remembering its path) and open your own.

Import the Azalea functions by opening your database; in our example, we'll use UPCsampleinput.mdb. From the File menu, select Get External Data/Import.

Give the path to the UPCAsampleinput.mdb sample database. In the "Import Objects" window, click the "Modules" tab, highlight "AzaleaUPC" and click "OK".

Query the design by clicking "Queries".

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

In the mini window click twice on the field containing your UPC, EAN/JAN, Bookland or ISSN 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 window on the left pane, expand "Functions", then expand "UPCsampleinput". On the right pane, select "AzaleaUPC_A". (or any other function name listed on the right pane that you want to print).

Replace "InputString" with the name of the input data field (in our example, "UPCA" without the quotes). Click "OK". Save and name your query. To select your entire query field, go to File menu/Format/Fonts and select one of Azalea's UPC fonts (e.g UPCTallThin) at size point 73 (standard).

Run the query at the main database window, by highlighting the name of your query, and clicking on top red exclamation point to execute.