sorry, only english.
if you have an internet connection, you may try the code in the class.
this one is written in vb. never tried it though.
first put an image control on your report for the qrcode.
on the load event of your report, get the qrcode:
dim qrCode As clsQRCode
private sub report_load()
set qrCode = New clsQRCode
' "text" means the text to make qr code, it can be from a textbox on your report
me.image_control.picture = qrCode.GetPictureQrCode("text", me.image_control.Width, me.image_control.Height)
If me.image_control.Picture Is Nothing Then MsgBox "Error!"
end sub
based on the message, you need
a bmp file, so i've made changes
and instead of jpeg being produced,
a bmp file instead.
firstly you need to import the following from the sample db (latest) I made to your db:
tblQRSheet table
autoExec macro
modGeneral module
on your form you add an Image control, this will hold the qr generated.
I have a button there on my sample that generate the qr.
please follow the code.
if you have difficulty, plz. upload your db with your table and form and I will be glad to do it for you.
sorry it's hard to explain.
If your data, the information you want to scan is just a simple serial number or part number, then QR codes are the wrong way to go. It's much easier to set up normal barcodes.
The only reason you should consider QR codes is if you want to incorporate a lot of information in the scan like the device name, type, location, serial number, IMEI number things like this.
However if you just want a quick way of scanning something and checking it against your database, a reference number stored in the database will suffice. Against that number in the database table, you have Fields containing all the other information.
what would you recommend?
Thanks Uncle Gizmo!
My scenario is I would like a label (with DeviceName, Model) to be printed and sticked on every staff;s computer. I can scan to the QR code (or maybe bar code) on the label so to get some more details of this device. e.g, CurrentUser, PreviousUser, and etc.
In such a case, what would you recommend?