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": "R0lGODdhHQEdAbMAAAAAAAAAq
gCqAACqqqo
AAKoAqqqqA
KqqqlVVVVV
V/1X/VVX//
/9VVf9V///
/Vf///ywAA
AAAHQEdAQA
E/xDISau99
+nNK39eR31
YJmJfqmrhS
pYuOLplbcc
2TOd87/u42
abFEhZ5L1R
sN1meTCti6
tcL
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
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.