How to Display QR Codes in your Microsoft Access Database Forms
ฝัง
- เผยแพร่เมื่อ 2 มี.ค. 2021
- In this video, I will show you how to use the Google Charts API and the WebBrowser Control to display QR Codes (2D barcodes) in your Microsoft Access Forms. QR Codes are great for detailed product info, employee name badges, whole web page URLS, or any time you want to display an image for someone to scan with their phone to get detailed information.
Anna from Madison, Wisconsin (a Platinum Member) inquires: I watched your previous videos on scanning and printing barcodes. They've been very helpful for my business. Thanks! I would love to be able to print employee ID badges with QR codes on them containing their Employee ID number, first and last names, and some other information. Is this possible with Microsoft Access?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to download the QR code from the web and save it as a local file on their hard drive, in a folder under their current database folder. Then, you will see how to display that file as an image in a report so we can print employee name badges.
MEMBERS VIDEO:
• How to Display QR Code...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMember
BARCODE LESSONS:
Barcode Scanning: 599cd.com/BarcodeScanning
Barcode Printing: 599cd.com/BarcodePrinting
Barcode Seminar Full: 599cd.com/BarcodeSeminar
QR Codes: 599cd.com/QRCodes
LINKS:
Concatenation: 599cd.com/Concatenation
WebBrowser Control: 599cd.com/WebBrowser
GOOGLE CHARTS:
developers.google.com/chart/
developers.google.com/chart/i...
chart.googleapis.com/chart?ch...
OTHER FREE ONLINE BARCODE GENERATORS:
Generator 1: 599cd.com/OnlineBarcodeGen1
Generator 2: 599cd.com/OnlineBarcodeGen2
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/Consulting
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, qr codes, 2d barcode, WebBrowser, URLDownloadToFile, printing qr codes, qr codes labels, free qr codes in access
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
![[TH] VCT Pacific Stage 2 - Playoffs Lower Bracket Final // PRX vs DRX](http://i.ytimg.com/vi/5HwO1bQyAx4/mqdefault.jpg)
![Decode a barcode or QR code from a Delphi app [Intermediate]](/img/n.gif)
Yesterday. I have subscribed in Mr. Richard channel "Silver Package" and I got the Extended Cut of this video. It solved my problem. Thanks 100 times. Mr. Richard. Appreciate your professional work. Please keep it up.
Awesome. Thank YOU. :)
You should see the database you helped me create. :) Now I am adding this feature. THANK YOU!!! Just became a silver member. Hope this helps!!!
Welcome aboard!
Thank you so much for this excellent video. I have subscribed. I'll join soon.
Sweet. Thanks!
Thank you so much! any way to make it work for continuous reports? I have to print hundreds of labels but in this way I can generate just one QRCode for each report...
That's covered in the Extended Cut for Members. You have to save the QR code as an image on your local drive to print it using a report.
The the server google web site not working right now from few days any solution for this problem
Hi sir, i want to join the member. But before that i want to ask whether the extended video will be explaining how to display the barcode for continous reports? (We dont have to save and import the qr manually on the reports)
Yes, it does, and thank you for signing up. :)
Hi Richard, I like your Access videos and these are very useful for me. I have also purchased your Beginners level and couple of Expert level videos. I want to be a member but there is no 'Join' button. How come I become a member? Please advise. Thanks.
TH-cam doesn't allow members from certain countries. Try joining on my site: 599cd.com/THMembers
Sir your tutorials are very helpful. This time, I want to know how to write a code in form level for a conditional calculation. Form example, I want to add a number/currency field with another number/currency field where the text field represents a particular item e.g. field a + field b where city = "New Delhi". Here in India, there is no such comprehensive book available where I can learn my required coding/procedures. Kindly advice. Regards.
599cd.com/Calculated and 599cd.com/IIF
Hi,
Thanks for this great lesson.
Now the question is: How to scan that QR code and get data in relevant fields?
The QR code is going to return something... whatever it's programmed to... a web address, someone's name, an ID, etc. What you do with that information is up to you.
sir can u help me how to manage two warehouse stock quantity,if one warehouse stock empty system tel during sale get from warehouse 2 quantity thanks
599cd.com/Inventory
I wish always the best
I am from Iraq.
I use barcodewiz class to create qr code in microsoft access database, it works good, but the word of (trail) is the problem.
how can solve this problem, please
I don't understand your question.
Hi Richard. Nice solution. However is there a way to bypass IE and use Chrome?
Not that I know of
Very very good . Please clarify how we can print the forms with QR code
That is covered in the Extended Cut
@@599CD i dont understand what about extendcut and how i get that
You have to become a PAID member of the channel. If you don't see a JOIN button here on TH-cam then it's not available in your country. You'll have to subscribe on my web site: 599cd.com/Join
@@599CD now become members
Many thanks
Hello Richard, thanks for your video, this is very useful. in Access,
I need to be able to change the size of the QR-Code being printed, is this possible? and if yes, how ? If possible as when changing the font size, thanks for your help. Best regards David ///
--- Bonjour Richard, merci pour votre vidéo, cela est bien utile. dans Access,
J'ai besoin de pouvoir changer la taille du QR-Code a l'impression, cela est il possible ? et si oui comment ? Si possible comme losque l'on change la taille des polices, Merci pour votre aide. Meilleures salutations David
That all depends on whatever QR code generator you're using.
Funny how TH-cam picked the QR Codes and Scanning bar codes (Not just yours but somebody else as well) for Access. Never really thought about bar code scanning but my next project is inventory of um Fishing gear so I theoretically don't purchase 500 more lures of the same one I already have because I swore I was low. Projects still going to happen (somehow). I had stopped using the old web tool some time ago as certain sites don't play nice with IE (specifically Google related pages. It felt too much like Dos isn't done until Lotus won't run). I had never tried the new one and had hoped it would play nice with sites like Google and guess what it doesn't. Is there a work around so can access certain pages or am I and every Access user doomed until Microsoft decides to update the ugly redheaded stepchild. I'm using Office 2016.
Sorry, Jeff, but you packed a lot of info into that paragraph. What's your question, exactly? :)
@@599CD the question was - is there a work around regarding the Web tool not displaying certain pages correctly in Access since it still seems to use IE instead of Edge or other. I know Microsoft said an update was to be released in 2021 but that can was punted to a future date?
Dear Sir,
When we print the form so this QR not showing in print is there any solution for that.
Yep. I explain how in the extended cut. You have to download the image.
@@599CD yea sir but for the users its long process downloading image so if you found any short process please let me know
Well, as of yesterday (4-1-2024) from my end it looks like Google API has disabled their QR code system as it has not been functioning for the past two days. I have now built into my code multiple URLs to go generate the QR code until successful. If the first URL doesn't generate the QR code then it repeatedly goes to the next URL until there is a successful QR code is generated. When your factory is depending on functionality having this redundancy built in is priceless. And no, we only do a dozen or so QR requests per day so it isn't like we are DoS requesting codes.
Looks like it's still working for me MOST of the time. I use it for the QR codes in my videos. I've noticed a couple of times over the past week they didn't load. There are other PAID services out there you can use that may be more reliable if it's business critical.
hi Richard, greetings from Germany, from turkish guy...i give you my personal title.....Professor of MS-Access...
Nice to meet you, professor. Greetings from Florida.
hi, i spent 3 month in Ft. Lauderdale do practice in MODCOM company...sometimes miss this time.
@@599CD i meant...you get the title of Prof. of Access... (:
my project...tab controls for totally touch use pos and restaurant system with MSAccess...total without using keyboard or mouse....
You'd need to build an on-screen calculator for that. I've got a video coming up on this.
BIG BAIN IDEA !!!
K
all well and good but not suitable for offline computers (internal network) 😢
Correct, but in the extended cut I do show you how to download those to local images
@@599CD download on offline systems? X)
Hi Rost... How r u?
All good
Wouldn't this pose as a company security threat? All someone would need to do is find a first and last name of someone that works with/for her and create a barcode using the same site? I guess this is how a QR code is a bad idea?
Well, if security is an issue, then you can always encrypt some kind of a code in the QR code.