Asked by:
QR Code in an Access Report

Question
-
Hi
I need to include a QR code in an Access Report.
The value for de QR is a URL that comes within the report query.
The computers using this application have no internet access.
Thanks!!
Ricardo
Friday, April 21, 2017 6:22 PM
All replies
-
Hi,
You may have to resort to using a third-party application.
Friday, April 21, 2017 6:38 PM -
Hello Ricardo,
Office object model doesn't provide anything for generating a QR code, so you need to use a third-party application or tool as theDBguy suggested. If you want to generate it automatically, you need to add third party dlls as reference.
You may visit the following links to find some available dlls or tools.
https://strokescribe.com/en/qr-code-excel-word-csharp-javascript.html
https://bytescout.com/products/developer/barcodesdk/bytescoutbarcodesdk-excel-with-vba.html
Regards,
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.Monday, April 24, 2017 6:24 AM -
Hi,
You may also want to take a look at the following link:
http://www.c-sharpcorner.com/UploadFile/38268a/generating-qr-code-in-C-Sharp/
Tuesday, April 25, 2017 1:34 AM -
Wednesday, October 17, 2018 6:48 PM
-
There are a few working examples online in various forums.
Here's one (not mine) that I have used several times and it does the job
https://access-programmers.co.uk/forums/showthread.php?t=299675
Friday, October 19, 2018 11:08 AM -
There are a few working examples online in various forums.
Here's one (not mine) that I have used several times and it does the job
https://access-programmers.co.uk/forums/showthread.php?t=299675
Hello,
I like this suggestion because I think the OP asked for an approach applicable to computers without an Internet connection. Most solutions out there require access to something like the Google API, which means the computer using those methods will need Internet access to get the resulting QR code. Using an Excel file as a source for generating a QR code doesn't sound like a bad alternative.
Good job!
Friday, October 19, 2018 5:33 PM -
Microsoft Word mail merge display QR code link data from Access
Wednesday, September 16, 2020 7:31 AM -
Hi Ricardo
I use stuff from Barcodewizards.
You buy a license and are free to distribute to your customers.
https://barcodewiz.com/qr-code-fonts-features.aspx
Cheers // Peter Forss Stockholm
Friday, September 18, 2020 12:02 PM