Qr Code Generation - New QR Code Site - Computer Learning Zone


	Back to New QR Code Site Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Qr Code Generation

Michael Conard

11 months ago

Richard, I am trying to get a QR code generated for organization members with certain information contained in it from their files (name, membership #, etc.) for their membership cards/ID badges. My database worked well when using the old Google API but since that is no longer an option, I switched to the new GoQR API but I cannot get the information from my database to work with that API.Any help you can offer is appreciated. BTW, I am completely self-taught on MS Access and your tutorials and TechHelp videos have made me look like an Access Guru to my members! Thanks a lot! (I was unable to put a screen shot on this message - sorry.)

	Michael Conard OP @Reply 11 months ago

	Alex Hedley @Reply 11 months ago
What's not working? What did you try? `https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=Example` Did you update `data=Example` Replacing Example with the data you need?

	Michael Conard OP @Reply 11 months ago
That is the example I am using. My trouble has been replacing 'Example' with the string of data I need from my database. Every time I try, the entire statement disappears.

	Alex Hedley @Reply 11 months ago
What code have you tried?

Richard Rost @Reply

11 months ago

If you've got some non-standard characters in that example string, you might need to URL encode it. I actually have a video coming out on this pretty soon. Essentially, you just have to translate some characters into a URL-friendly character. For example, the character ? has to be coded to %3F.

Unfortunately, VBA doesn't have a built-in URLEncode function like ASP or some other languages do. But it's not hard to write one; it's just basically string replacement again. I've got a video coming out on this pretty soon, so stay tuned.

Richard Rost @Reply

11 months ago

I had GPT throw together a simple function for this real quick:

Details

Function URLEncode(ByVal str As String) As String

    str = Replace(str, "%", "%25")

    str = Replace(str, " ", "%20")

    str = Replace(str, """", "%22")

    str = Replace(str, "'", "%27")

    str = Replace(str, "&", "%26")

    str = Replace(str, "=", "%3D")

    str = Replace(str, "?", "%3F")

    str = Replace(str, "+", "%2B")

    str = Replace(str, "#", "%23")

    str = Replace(str, "/", "%2F")

    str = Replace(str, "\", "%5C")

    URLEncode= str

End Function

Now just URLEncode your string before passing it in the URL.

	Alex Hedley @Reply 11 months ago
Code Vault: URLEncode

	Richard Rost @Reply 11 months ago
Alex yeah, I just put that in there. I copied it here because he's not a Gold member. :(

	Michael Conard OP @Reply 11 months ago
Thank you Richard! I'll try writing it that way and see what happens. In the meantime, I look forward to the upcoming video!

Brad Wile @Reply

7 months ago

Michael
Try it like this:
="https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=" & [PartNumber] & " ==> " & [PartDescription] & ""
That should use the [PartNumber] field data in a database then an arrow pointing to the [PartDescription] field data from the database.
Or try it with just a PartNumber:
="https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=" & [PartNumber] & ""

Hope that helps

This thread is now CLOSED. If you wish to comment, start a NEW discussion in New QR Code Site.

Next Unseen

New Feature: Comment Live View