Reports with QR Codes (1 Viewer)

[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?

 

[Pat Hartman]

I have an app that runs on several client locations and each uses a different logo. This is the code that populates the logo control. I set the background of hidden controls to yellow so I can easily find them. The logo uses an unbound image control. If there is no proper path, then the default image is used.

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)

    If Me.LogoPath & "" = "" Then
    Else
        Me.imgLogo.Picture = Me.LogoPath
    End If
End Sub

 

[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)