• Aztec Code barcode excel download
  • Aztec Code barcode excel order

Generate Aztec Code in Microsoft® Access®

Generate Aztec Codes in MS Access Database

Aztec Code is a high-capacity 2D matrix barcode symbology. Aztec Code is able to encode both ASCII and Extended ASCII characters.

With Barcodesoft Aztec Code font package and Microsoft® Access®, it has never been so easy to print Aztec Code from your Windows computer and desktop printer.

1. Install aztec code demo on your computer.

2. Open DOS prompt. If you are using Windows Vista or Windows 7, please Open DOS prompt as administrator.

Type in the following DOS command to register crUFLbcs.dll
CD C:\Program Files\Common Files\Barcodesoft\FontUtil
regsvr32 crUFLbcs.dll

Aztec Code Access DLL DOS registration

3. Start Microsoft® Access®.

If you are using Access 2000 or 2003, click menu ===> Tools ==> Macro ===> Security. Choose Low security level.
Aztec Code Access Macro Security

If you are using Access 2007 / 2010 / 2013 / 2016 / 2019, click the Microsoft Office Button.
Office 2010 button Office 2016 button Office 2019 button
Click Access Options ==> Trust Center ==> Macro Settings, choose "Enable all macros" as shown below.

Aztec Code Access Macro Setting

4. Press ALT + F11 to open Microsoft® Visual Basic editor.
Aztec Code Access VBA

5. From Visual Basic editor, choose menu Tools ===> References. It will popup a dialog. Click Browse button and choose cruflbcs.dll from C:\Program File\CommonFiles\Barcodesoft\Fontutil folder.
Click the checkbox beside crUFLBcs 4.0 Type Library as shown below. Then click OK button.

Aztec Code add reference

6. Press Ctrl+M, it will popup a dialog, choose barcodesoft.bas under C:\Program File\CommonFiles\Barcodesoft\Fontutil folder. Then click "Open".

If you don't find barcodesoft.bas, please download it from Aztec Code.
Aztec Code import vba

You can copy and paste from code snippet below

Public Function Aztec(strToEncode As String) As String
Dim obj As cruflBCS.CAztec
Set obj = New cruflBCS.CAztec
Aztec = obj.EncodeCR(strToEncode, 0, 0, 0)
;The first parameter is string to encode.
;The second parameter is string Index, set it to zero.
;The third parameter is format, default value is zero.
;The fourth parameter is error correction level, default value is 23.
Set obj = Nothing
End Function

7. Close Visual Basic and go back to your Access database. Now, create a textbox in Design view and type in the following macro in its control source:
=aztec([data.code])

Please notice that 'data' is the Table name, 'code' is the Field name.

Aztec Code barcode access macro

8. Right click the textbox. Choose Properties from context menu. Apply BcsAztec as font.

aztec code access font typeface

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

  • Aztec Code barcode download
  • Aztec Code barcode software order