QRCode Image Generator

[June7]

This database developed from discussion in https://www.access-programmers.co.uk/forums/showthread.php?t=299589

Offer no guarantees but it does seem to work nicely.

At its core is an Excel workbook built by Johan Schoeman - his details are in the workbook. Be aware the workbook is password protected by the author and therefore no analysis of its VBA can be done. I am not able to get QRCode images to generate from the workbook alone. Thanks to @arnelgp for locating this workbook and building an Access application to manipulate it. Even though code worked for him, it would not for several of us testing. Posted here is my modified version of that Access file. Workbook is embedded in table Attachment field. Code extracts and manipulates workbook.

Also attached is a completely different workbook that generates QRCode patterns. This one does not use VBA. Found at http://blog.ambor.com/2013/03/create-qr-codes-in-excel-or-any.html

 

[isladogs]

In future, if you post something in one of these moderators sections, just press the report post button and Report your own Post! This will report your post to the moderators. Include a comment like "please could you approve my post" and it will be brought to the attention of the moderators, who will then be able to approve your post and the attachments. I mentioned attachments because attachments need to be approved separately...

Hi Tony

Although I do exactly what you said myself (on your advice), the flaw with this system is that:
a) you can't report the post until you've sent it
b) if sending to a moderated area, you can't then see the post again until its approved ... so you still can't directly report it!

So I just click on another post of mine, report that & explain which post I'm referring to. As you already stated, mention there is one or more attachments to be approved as well

 

[isladogs]

I can't think of a better alternative.
As already mentioned, I just click on another post, report that and if necessary state there are N attachments. It's always worked well for me.

 

[June7]

Just revisiting this topic and discovered my db had a weird typo in it. I must have accidentally typed after testing code. The Generate button is named btnGenerate but event procedure had btbGenerate. And nobody ever nailed me on that!!!

I replaced attachment in OP.

Want to add reference to another tool GitHub - zingl/2D-Barcode: Create 2D barcodes Code128, Data Matrix, QRCode or Aztec in JavaScript, MS Office or OpenOffice