Create QR code in access report (1 Viewer)

Endless

New member
Local time
Today, 15:18
Joined
Aug 19, 2019
Messages
5
totally forgot about this.

Thanks a lot sir!

It was working in the TEST DB. However, once if I copy the form and script part into my original DB, it would pop up err about something missing.

May I send you my original DB via email? I am very sorry for the inconvience! :)
 

corentin

New member
Local time
Today, 08:18
Joined
Jan 22, 2020
Messages
12
Good afternoon,

I am currently working on an access form and I would like it generates QR codes ...

I have already downloaded xlQRCode database. It has worked the first time but now when I run it, there is a issue in the function InitQRCode (please, see the attachements). :confused:

Do you know how I could run it again please ? And how could I fit the functions with datas from a form. Thank you and sorry for my english (I am french :))
 

Attachments

  • Capture 1.PNG
    Capture 1.PNG
    33.3 KB · Views: 150
  • Capture2.PNG
    Capture2.PNG
    12.9 KB · Views: 146

CJ_London

Super Moderator
Staff member
Local time
Today, 07:18
Joined
Feb 19, 2013
Messages
16,553
this is an old thread so you should really start your own, referencing this thread - but the implication of the error message is the file is open so cannot be deleted
 

RevJeff

Registered User.
Local time
Today, 03:18
Joined
Sep 18, 2002
Messages
125
forget about that, i think it uses
internet connection to create the qrcode.

here is another sample. doesnt
require internet connection.

there is sample form and report too.

if you want to adapt this to your db,
copy all Modules to your db.
and the AutoExec and the hiddenForm.

you need hidden form because it
is called form AutoExec macro to
instantiate Excel and extract
the excel file (the one who makes
the QR). when the applicatin closes
the hidden form does the housekeeping,
closing Excel and the excel file.
removing some other stuffs.

sorry for the sample, its unpolished.

if you have qrcode Reader on your
cellphone you can try to scan
if it is producing the correct code.
(on my test it passed all).

I know this is an old post, but I just came across it. Is there away to adjust how much information can be in the barcode. I noticed there is a point when the QRCode doesn't fit and gets cutoff.
 

Users who are viewing this thread

Top Bottom