How to get the QR Code in Ms Access

Hi all

Is there a way to have the QR Code on my Ms Access report using these controls which are pulled from the table as follows:

"VerificationUrl"

"VerificationQRCode"

"VerificationUrl": "http://efd.zra.org.zm:8097/search/invoiceInspection/invoiceVerification?x=%7B%22INV%22%3A%7B%22IC%22%3A%22000200110000%22%2C%22IN%22%3A%2200009310%22%2C%22TPIN%22%3A%221002623668%22%2C%22MACH%22%3A%22010300000080%22%2C%22DATE%22%3A%2220200405174611%22%2C%22AMT%22%3A%220000000082.75%22%2C%22FSC%22%3A%2234717018140560210201%22%7D%7D",
"VerificationQRCode": "R0lGODdhHQEdAbMAAAAAAAAAqgCqAACqqqoAAKoAqqqqAKqqqlVVVVVV/1X/VVX///9VVf9V////Vf///ywAAAAAHQEdAQAE/xDISau99+nNK39eR31YJmJfqmrhSpYuOLplbcc2TOd87/u42abFEhZ5L1RsN1meTCti6tcL

Is there a need for some kindly of VBA to encode the above stuff , I thought this was supposed to b e the easiest, but it has proved me wrong.

PLEASE NOTE THE ABOVE STRINGS ARE STORED INTO THE TABLE AUTOMATICALLY INVOICE SALES INVOICE WISE

Regards

Chris

Chris,

Do you want the actual bar code to appear on the report? If so, you'll need a bar code library like:

http://www.abarcode.net/

or

https://www.idautomation.com/barcode-components/native-access-generator/

Jim.

ASKER

No sir

I need a QR picture like below:

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.