Generate aztec-code Barcodes

Implement seamlessly across Crystal Reports, MS Excel, and MS Access

Generate aztec-code Barcode in MS Access Database

1. Adjust Database Security Properties

Modern Access Versions: Access Options Menu panel → Trust Center workspace options setup layout → Macro Settings → Choose "Enable all macros".

Access trust macro config

2. Run Visual Basic Engine Window

Launch the VB development application layout environment immediately by applying keyboard hotkeys combination triggers: ALT + F11.

Access trust macro config

3. Reference Type Library Extensions

Open Tools → References options interface. Click Browse targeting library file matching path variables location to activate cruflbcs.dll dependencies tracking elements. Pick the select block next to crUFLBcs 5.0 Type Library, then finalize step saving actions.

Access trust macro config

4. Append Module File Functions Library

Press Ctrl + M to append script structures data using standard template files barcodesoft.bas components layout definitions module framework package directly.

Access trust macro config

5. Implement Report Macro Expressions

Exit the VBA developer windows, return safely back onto the database designer environment, and switch reports workspace views towards standard Design View layout structures. Type expression formatting values precisely into targeting object control sources textboxes fields:

=azteccode([tableName.fieldName])

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

Replace 'tableName' with your database table name and 'fieldName' with your code field name.

aztec-code barcode excel macro

6. Finalize Typography System Configurations

Right-click target reporting control text container objects fields box areas picking layout Properties list context menus options mapping block. Alter control styling parameters to handle text display rendering behavior utilizing font type name family records matching BcsAztec typeface systems.

Access properties control font text box typography layout settings window step view