Microsoft Access QR Code Link Creation HELP - VB code

Job ID: 34363441

Budget: $30 – $250 AUD

Hello,

please watch this video for you to get upto speed.: - https://www.youtube.com/watch?v=e8gBkxzVQGg&t=655s&ab_channel=ComputerLearningZone

I'm trying to integrate QR code creation into my forms and reports in microsoft access.

This link :

https://docs.google.com/forms/d/e/1FAIpQLSc6fSWSvLSMpN686JHiy0h3S9RC3avDT-qWSHxOGSDbMYL7nw/viewform?usp=pp_url&entry.555792064=123&entry.1871702717=123

needs to be integrated into the QR code and where it says "123" needs to be fields from my Access database.

please see the attached txt file with the code.

so currently:
when i scan the qr code(scan attached) it is supposed to reference my database fields and produce a separate qr code for each when i scroll through the records. A different url code should be created. but when you scan the code it simply sends you to the form with no pre filled data.

The hyperlink version of this works perfectly but imbedding the link with the referenced table data does not.

see below link - this works great but it does not work inside the qr code generation script. the qr code generates but it does not hold the reference data

https:/docs.google.com/forms/d/e/1FAIpQLSc6fSWSvLSMpN686JHiy0h3S9RC3avDT-qWSHxOGSDbMYL7nw/viewform?usp=pp_url&entry.555792064=" & [EMPLOYEE ID] & "&entry.1871702717=" & [UTH Job Number]

i need this fixed now not later.