Share via

how to display a text field as a QR Code in an Access report

Anonymous
2024-03-27T03:37:01+00:00

On an employee badge I want to display the person's Id, Name and Team as QR Code

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-27T11:25:06+00:00

    Hi,

    To add one more to George's video links, which are always displayed here in the huge preview. Last year, in a presentation in Tip No. 15, I showed how this can be done quite easily with a free, external tool: https://www.youtube.com/watch?v=k9jgkzG2IaU&t=2775s

    Servus
    Karl
    ****************
    Access DevCon - online conference April 18+19
    Access Forever
    Access News
    Access-Entwickler-Konferenz AEK

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. George Hepworth 22,855 Reputation points Volunteer Moderator
    2024-03-27T14:06:35+00:00

    George Y also translated for JuanJo in that presentation to our group.

    It's a small world, centered in Vienna.

    Speaking of which, isn't there an Access conference soon in Vienna?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-03-27T13:14:45+00:00

    BTW George, it's funny that we've linked 4 videos here and all relate to Vienna/Austria. Leila and I live in Vienna, Juanjo in Graz (2nd largest city). And George Young? He at least starts every DAAUG video with the The Third Man theme (movie playing in Vienna) by Anton Karas who lived all his life round the corner of my office.

    :-)

    Karl

    Was this answer helpful?

    0 comments
  4. George Hepworth 22,855 Reputation points Volunteer Moderator
    2024-03-27T11:04:49+00:00

    The first step would be to generate the QR codes, which can be done,according to this video, using a Google API. In this video the process is based on Excel, but the concept should be replicable in VBA in Access. Once you have the QR codes available Access--probably stored in an image file- you can include them in a report.

    Look into using Web API's in Access VBA as a key part of this process. And here from my Access User Group.

    Was this answer helpful?

    0 comments
  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more