MS Access report

Mar 16, 2012 at 11:59 AM
Hi Is it possible to use this in an access report ? If so can you give me an example on how to generate the QRcode from a record set If its not possible can you point me to something that will Thanks Kevin
Coordinator
Mar 16, 2012 at 9:14 PM

Hi Kevin.

I'm not sure what you are exactly wanna to do.  Do you mean you have a set of string inside access database that you want to turn them into QrCode then display inside access report or something else. 

Here is some link might be useful. 

https://office.microsoft.com/en-us/access-help/use-images-in-your-access-forms-reports-and-controls-HA001147204.aspx#BMstoreimages

Our project is purely a .Net library, you can actually code a small application use this library to encode any given string to QrCode then create image or EPS file according to that. But that application will also involve some code to extract data out of access file and put image or image link back into it after process. 

 

For access module you can check following link.

http://www.idautomation.com/fonts/qr-code/

http://www.barcodesoft.com/qrcodeAccess.aspx

http://www.morovia.com/fonts/qrcode/

Mar 16, 2012 at 9:35 PM

Hi,

Thanks for the info however all these require paying for a solution.

 

I have good but OLD VBA experience hence my question can this solution be used within MS Access ? this will read data from a field and produce the QRCode in the report as a graphic.

 

Coordinator
Mar 16, 2012 at 11:33 PM

Sorry I don't have any experience with VBA. I do see articles that teaches how to compile C# library to be usable to access, but then which kind of function is acceptable by access and which kind of graphic display renderer can be used within access, I have no idea. 

So far, I don't know any library that can be directly use under access or similar field which is free for commercial use. 

For non commercial use you can check out this one. 

http://strokescribe.com/en/price.html

Mar 22, 2012 at 11:26 PM

You can reference the DLL in Access and use it to create a file, which you use as the Picture property in an Image control on a form or report.

May 30, 2014 at 8:50 AM
I've heard something like excel qr code, don't know if this kind of thing be helpful to your situation or not. I quite a newbie on these kind of thing, got to study further.