Thanks Uncle Gizmo for your attention. I think the second code will fit my desired, that I searched a lot of threads and tried many of them almost generate the QR code but unfortunately, it's not stand alone codes, the user machine should be connected to the internet, and it will not work in our office environment, hence, I think this code will help me to generate a stand alone MS Access application, how can I call this code means from a text box in my form or report to be printed? Please when you get free time, I would appreciate your help.Could be this Link:-
For a little project I'm working on, I needed to understand how to generate QR codes. Being the Excel junkie that I am, I thought it would...blog.ambor.com
And Here some VBA:-
Barcode generator for LibreOffice and MSOffice as pure VBA macro... with a critical bug fixed compared to the version on code.google.com - barcode-vba-macro-only/barcody.bas at master · JonasHeidel...github.com
how can I call this code means from a text box in my form or report to be printed?
Thank you so much, I will do my best to try that later, unfortunately, my wife got sick and I will not get enough time to implement this. But once my wife recovered from her sickness, I will follow the steps you provided and let you know the result.I don't know!
You already have the code for putting a single line inside a textbox and displaying it on the report. I don't understand this process, and and I haven't investigated it to see how it works.
But printing it, that's your starting point, can you print it? You need to see if you can convert the line into a square, as a square is the basic element of a QR Code. You need to prove that this method can produce a square.
Next you need to know if you can add extra Lines with this method. Can you add a line of squares followed by another line of squares underneath?
If you discover you can, then you need to decide on the size of of QR code you wish to create.
The size of the QR code you need to create will depend on the information you want to present with it. Follow this link here for more information:- https://www.qrcode.com/en/about/version.html
Let's assume you need a 25 by 25 QR code. That means you need to be able to add 25 squares across and 25 squares down in your text box.
If you achieve this, then you need to check that you can control the appearance of the squares with some simple tests. Can you print every other square so you have a chequerboard effect? If you can achieve that, then you are probably going to be able to take it further.
The next stage is to start deciphering the VBA code to see how it it modifies the Excel spreadsheet. Then see if you can apply that VBA code to the process of adding the lines in the text box..
None of this is trivial, but it is small/manageable steps, but it will take many hours, probably weeks and many iterations until you perfect it.
But first of all you have to prove that it is possible to modify what you present in the text box.
If you decide to undertake this project I suggest you start a new thread in Access World Forums. I'm sure that if you show willing to take on this project you will get some of the best help available. Also I wouldn't be too restricted in how you want to approach this, as there are many people here who have vast experience and might be able to steer you in a completely different direction.
I'm quite sure barcodes can be made with the Access Line method, and characters written using Print
That's good to know thank you Crystal. Would you have any examples that could be adapted to produce 25 by 25 grid of squares in a chequerboard pattern to test the possibility of producing a QR code?