Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-19-2019, 01:33 AM   #31
Endless
Newly Registered User
 
Join Date: Aug 2019
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
Endless is on a distinguished road
Smile Re: Create QR code in access report

Quote:
Originally Posted by arnelgp View Post
based on the message, you need
a bmp file, so i've made changes
and instead of jpeg being produced,
a bmp file instead.
Hi Arnelgp,

I am also trying to generate the bar code for each individual device for my IT inventory management work. I have created the table in Access to store all the devices (computers). A field named QRCode is also created.

Now with a created FORM for this table, the code part is empty.
I would like to know what to do with your code in my scenario, so I could have the QRCode to be generated for each device listed in the Access FORM.

I am sorry that I almost have zero coding experience so my question might be sound stupid to you!

Any help is appreciated!

Endless is offline   Reply With Quote
Old 08-19-2019, 02:08 AM   #32
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,396
Thanks: 68
Thanked 2,701 Times in 2,586 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Create QR code in access report

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.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 08-19-2019, 03:02 AM   #33
Endless
Newly Registered User
 
Join Date: Aug 2019
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
Endless is on a distinguished road
Re: Create QR code in access report

Quote:
Originally Posted by arnelgp View Post
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.
Thank you very much Arnelgp!

I have uploaded & attached the TEST Access DB file with only 1 table - DIR. It only got a few devices recorded. It also has a created FORM named Label2Print, where you could see a number of fields I have added into.

I expect the QR code for each device could be shown in the square area in the FORM. When the label is printed I could also use mobile device to scan the QR code to get details of the device from the DB.

Now, the using cellphone to scan QR code task I will leave it temporarily. I just want to get the QR code could be successfully generated for each device from the DIR table.

Many thanks for your help in advance!
Attached Files
File Type: accdb TEST.accdb (400.0 KB, 24 views)

Endless is offline   Reply With Quote
Old 08-19-2019, 03:20 AM   #34
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,271
Thanks: 527
Thanked 927 Times in 879 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Create QR code in access report

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.
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 08-19-2019, 03:36 AM   #35
Endless
Newly Registered User
 
Join Date: Aug 2019
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
Endless is on a distinguished road
Re: Create QR code in access report

Quote:
Originally Posted by Uncle Gizmo View Post
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.
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?
Endless is offline   Reply With Quote
Old 08-19-2019, 05:37 AM   #36
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,271
Thanks: 527
Thanked 927 Times in 879 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Create QR code in access report

Quote:
Originally Posted by Endless View Post
what would you recommend?
Well, I don't know enough about what you are doing to advise you. All I can say is:-

A QR code is sophisticated version of a Bar code. It is designed to carry lots of information. A typical example, you would have a QR Code on your business card, then when somebody scans the business card QR code, your app would gather information from it like name, address, mobile phone, office phone, email, in other words the QR Code contains loads of information.

In your scenario I don't think you need it to carry information, a simple number (Bar Code) would suffice. I'm not saying you can't use the QR code, I just don't think it's necessary.
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 08-19-2019, 08:38 AM   #37
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,146
Thanks: 27
Thanked 270 Times in 257 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: Create QR code in access report

Quote:
Originally Posted by Endless View Post
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?
The barcode label is just a report but with smaller dimensions. The "devicename" and "model" are just fields within your database. The thing you want to capture with the barcode is something unique such as a serial number or a unique identifier like an asset number you contrive. That way your tracking something unique not just some random Apple Computer.

HTH

AccessBlaster is offline   Reply With Quote
Old 08-19-2019, 11:07 AM   #38
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,271
Thanks: 527
Thanked 927 Times in 879 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Create QR code in access report

I've just updated my Bar-code Blog on the Nifty Access Website because the comment I made here was a good start for a blog about Bar Codes v QR Codes. Would have been a shame to waste it! I thought it might add some value to this thread hence, I have posted this link here.
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 08-19-2019, 10:24 PM   #39
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,396
Thanks: 68
Thanked 2,701 Times in 2,586 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Create QR code in access report

totally forgot about this.
Attached Files
File Type: zip TEST (1).zip (308.5 KB, 42 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 08-19-2019, 10:52 PM   #40
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,356
Thanks: 112
Thanked 2,843 Times in 2,593 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Create QR code in access report

Unfortunately Arnel's QR code generator doesn't work for me though I know it does for others.
I get a file/permission error and the Excel file with QR code isn't generated.

For info, there is another utility by June7 based on a similar approach in sample databases https://www.access-programmers.co.uk...d.php?t=299675. That one does work for me.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 08-19-2019 at 11:00 PM.
isladogs is offline   Reply With Quote
Old 08-20-2019, 02:30 AM   #41
Endless
Newly Registered User
 
Join Date: Aug 2019
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
Endless is on a distinguished road
Re: Create QR code in access report

Quote:
Originally Posted by arnelgp View Post
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!
Endless is offline   Reply With Quote
Old 08-20-2019, 02:36 AM   #42
Endless
Newly Registered User
 
Join Date: Aug 2019
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
Endless is on a distinguished road
Re: Create QR code in access report

Quote:
Originally Posted by Uncle Gizmo View Post
I've just updated my Bar-code Blog on the Nifty Access Website because the comment I made here was a good start for a blog about Bar Codes v QR Codes. Would have been a shame to waste it! I thought it might add some value to this thread hence, I have posted this link here.

Thank you for the nice share Gizmo!


Last edited by Uncle Gizmo; 08-20-2019 at 03:18 AM. Reason: Added URL
Endless is offline   Reply With Quote
The Following User Says Thank You to Endless For This Useful Post:
Uncle Gizmo (08-20-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
code to create a PDF bookmark when printing a report to PDF davefwelch Reports 25 04-11-2012 09:19 AM
Access VBA Code to create a toolbar in Excel RodgerDJr Modules & VBA 1 10-22-2009 12:41 AM
Question How to create odbc connection thru ms access code to connect access to sql tables marianne General 3 03-27-2009 05:25 PM
Code to Create New Report loo8866 Modules & VBA 1 05-13-2007 12:39 PM
Create new Access Database in code? pdbowling Modules & VBA 3 01-27-2005 09:00 AM




All times are GMT -8. The time now is 07:37 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World