Reports with QR Codes

[tmyers]

Is it possible to add QR codes from a stored list when the report is opened?
I had made some product labels for my work and thought it would be nice to also include our system generated QR codes for them but cant fathom how I would tell the report which code to use when it was opened.

In my products table I could add some form of link to which code belongs to it then try and pull that it on open but would that work? I am just brain storming this at the moment and am not actively working on it.

 

[isladogs]

If you already have the QR codes, you can save the file path and add them as image controls.
If you need to generate them, see this thread

QRCode Image Generator

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...

www.access-programmers.co.uk

 

[tmyers]

I do already have them but am curious the process I would have to use to get the report to know which to use. I have never messed with images outside of a static company logo that doesnt change.

 

[theDBguy]

I do already have them but am curious the process I would have to use to get the report to know which to use. I have never messed with images outside of a static company logo that doesnt change.

You can associate each qr image to their corresponding record by storing the full path to the image in the same table.

 

[tmyers]

You can associate each qr image to their corresponding record by storing the full path to the image in the same table.

I see. I figured it would be something along those lines but wasn't sure. On the reports On Open event I would just set the image to that path then correct?

 

[theDBguy]

I see. I figured it would be something along those lines but wasn't sure. On the reports On Open event I would just set the image to that path then correct?

If you're using Access 2007 and later, you can just bind the image control to the field used to store the file path.

 

[June7]

Review:
Display Product Picture (accessforums.net)
Image (accessforums.net)