Share via

Is it possible to make a QR code to Access form?

Anonymous
2024-06-02T20:31:48+00:00

Hi there, I am curious if it is possible to create a QR code that links to a Microsoft access form. My hope is for the QR code to lead straight to the form. Please let me know if this is possible. Thank you

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 No comments

9 answers

Sort by: Most helpful
  1. Anonymous
    2024-06-03T13:45:58+00:00

    If you intend to use your phone's camera, then I'm not sure how the Access form will open in your phone.

    I assume the OP intends to scan the string expression into a text box control, and then use an event procedure to open the form. To enable a phone to be used as a scanner input device for a PC see https://barcodetopc.com/

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  2. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2024-06-04T14:27:31+00:00

    I wasn't thinking clearly. My original thought was that the QR code would have a full Access command line in it, with the /cmd argument. But you're right: how would that get executed? It would have to be the job of the receiving app, just like on a phone the receiving app runs that URL in the default browser.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. ScottGem 68,810 Reputation points Volunteer Moderator
    2024-06-03T11:53:36+00:00

    Possible yes, practical no.

    Was this answer helpful?

    0 comments No comments
  4. DBG 11,711 Reputation points Volunteer Moderator
    2024-06-03T01:36:25+00:00

    Hi there, I am curious if it is possible to create a QR code that links to a Microsoft access form. My hope is for the QR code to lead straight to the form. Please let me know if this is possible. Thank you

    I'm sorry but I actually don't understand this request, perhaps I am missing something. To read a QR code, won't you need to use a camera? If so, which camera are you planning to use? If you intend to use your phone's camera, then I'm not sure how the Access form will open in your phone.

    Was this answer helpful?

    0 comments No comments
  5. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2024-06-02T21:46:24+00:00

    Sure. A QR code represents a string of text. Imagine the text being:
    [path-to]msaccess.exe [path_to]your.accde /cmd "OpenForm=frmOne"

    Then all you have to do in your startup code is process the command line argument (see the Command function), and open the requested form.

    Was this answer helpful?

    0 comments No comments