code set A, code set B, code set C, and GS1-128 bar codes
Our products come with free sample code to integrate our fonts in Access databases. Creating barcodes in Microsoft Access is an easy two part process: pass your data in, then format the returned value into one of our fonts. You’ll find instructions and sample Access databases below.
There are two ways to add Code 128 barcodes to your Access projects. The long way is to use our Visual Basic functions in your own Access programs.
VB macro reference implementation:We also offer an Access plug-in that calls our barcode.dll encoder. Below are instructions for using the plug-in and DLL.
Access plug-in:When you need to print Code 128 barcodes from within a Microsoft Access database, you can make it easy by using Azalea's free barcode.dll along with our Code128 TrueType fonts. Our barcode.dll adds the start and stop bars to your input string, calculates the necessary modulo 103 check digit, and then it maps the output into our fonts’ character set. To make a Code 128 barcode, you'll need to use the our DLL because you cannot simply format a chunk of text in a bar code font and create a scannable bar code symbol. Azalea's DLL will do all of the heavy lifting for you and make it effortless.
1. Download barcode.dll and save it into your\WINDOWS\SYSTEM or \WINNT\SYSTEM32 directory, as appropriate. Then you'll want to download C128sampleinput.mdb, our sample database. Open Microsoft Access.
2. In Access, open the database window; then click "Modules".
Close this database and make sure you remember its path and then open the database with your information that you need to barcode.
3. Import your Code 128 functions by opening your database and attaching C128samplecode.mdb. Open the File menu and select Get External Data/Import. Enter the path to the C128samplecode.mdb database.
4. The "Import Objects" window will then open. Choose the "Modules" tab, pick "Code128", and then click "OK".
5. Choose "Queries".
6. Pick "Design View" and you'll see the Query menu pop up.
7. Double-click on the field that contains your input data to be converted into a Code 128 barcode. Uncheck the "Show" check box, as we just want the bar code.
8. Right-click on the first row field; then choose "Build".
9. In Expression Builder, expand "Functions", "Expand C128sampleinput"; on the right pane, select "AzaleaCode128B". Note: This example refers to Code set B. However, the same method is used for Code set A, Code set C and UCC/EAN (also known as GS-1/128) barcodes.
10. Replace "InputString" with the name of the input data field that you intend to convert. (in our example, "C128" without the quotes). Click "OK". Save and name your query. Choose your entire query field, go to File >Format>Fonts and then select an Azalea Code 128 font (e.g Code128 or Code128Wide) and then set the point size.
11. Run the query; double-click the name of your query in the main database window. Check your output…if the output result differs or you see boxes or odd characters, please send a screenshot to technicalsupport at azalea dot com and we'll be happy to help you get it sorted out.
Need help? Email us at azalea at azalea dot com or call 1.206.341.9500
