Is it Possible? (1 Viewer)

[Jon123]

Does anyone know if it is possible to create QR codes within access using a command button? I can be done in excel so guessing maybe??? Excel looks sloppy and using access might be easier to track and update.

jon

 

[Minty]

Yup but I think you'll need to pay for it http://www.idautomation.com/barcode-fonts/2d/qr-code/user-manual.html

 

[arnelgp]

i am also using QR code written in Excel.
You see Access has no graphic capability.
What I did is I insert the Workbook in an Attachment Field in Access table.

I have a routine that save the Attachment to disk.
Create Excel automation.
Send the Text to be convert to QR Code to Excel.
Let Excel do the work for creating the QR Code.
Save the QR Code as Picture to the disk.
On my form or report, I have an Image Object.
Set the Picture Property of the Image to the Picture in the disk.
Done.