Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-11-2018, 06:36 PM   #1
June7
Newly Registered User
 
Join Date: Mar 2014
Posts: 238
Thanks: 0
Thanked 53 Times in 53 Posts
June7 is on a distinguished road
QRCode Image Generator

This database developed from discussion in https://www.access-programmers.co.uk...d.php?t=299589

Offer no guarantees but it does seem to work nicely.

At its core is an Excel workbook built by Johan Schoeman - his details are in the workbook. Be aware the workbook is password protected by the author and therefore no analysis of its VBA can be done. I am not able to get QRCode images to generate from the workbook alone.

Thanks to @arnelgp for locating this workbook and building an Access application to manipulate it. Even though code worked for him, it would not for several of us testing. Posted here is my modified version of that Access file.

Also attached is a completely different workbook that generates QRCode patterns. This one does not use VBA. Found at http://blog.ambor.com/2013/03/create...el-or-any.html
Attached Files
File Type: accdb xlQRCode.accdb (776.0 KB, 28 views)
File Type: xlsx QR.xlsx (205.9 KB, 20 views)

June7 is offline   Reply With Quote
Old 05-14-2018, 11:07 PM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,075
Thanks: 313
Thanked 712 Times in 678 Posts
Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about
Send a message via Skype™ to Uncle Gizmo
Re: QRCode Image Generator

Hi June,
A couple of sections within access world forums are moderated. This means that posts made in those sections have to be approved by a moderator. This is to discourage conversations taking place in those sections...

In particular this sample database provided by yourself is moderated and no one is able to see it except moderators!

Unfortunately the vbulletin software is not able to, or possibly not set up to notify moderators when a post is hidden.

To get around this bug we are currently experimenting with the idea of "reporting your own post"..

In future, if you post something in one of these moderators sections, just press the report post button and Report your own Post! This will report your post to the moderators. Include a comment like "please could you approve my post" and it will be brought to the attention of the moderators, who will then be able to approve your post and the attachments. I mentioned attachments because attachments need to be approved separately...
__________________
Tony Hine - My Aspiration --- Finding a better way of Explaining ---
From this YouTube:-

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Uncle Gizmo is offline   Reply With Quote
Old 05-15-2018, 12:09 PM   #3
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,912
Thanks: 75
Thanked 1,216 Times in 1,133 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: QRCode Image Generator

Quote:
In future, if you post something in one of these moderators sections, just press the report post button and Report your own Post! This will report your post to the moderators. Include a comment like "please could you approve my post" and it will be brought to the attention of the moderators, who will then be able to approve your post and the attachments. I mentioned attachments because attachments need to be approved separately...
Hi Tony

Although I do exactly what you said myself (on your advice), the flaw with this system is that:
a) you can't report the post until you've sent it
b) if sending to a moderated area, you can't then see the post again until its approved ... so you still can't directly report it!

So I just click on another post of mine, report that & explain which post I'm referring to. As you already stated, mention there is one or more attachments to be approved as well

__________________
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.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
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.
ridders is offline   Reply With Quote
Old 05-15-2018, 10:48 PM   #4
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,075
Thanks: 313
Thanked 712 Times in 678 Posts
Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about
Send a message via Skype™ to Uncle Gizmo
Re: QRCode Image Generator

Quote:
Originally Posted by ridders View Post
b) if sending to a moderated area, you can't then see the post again until its approved ... so you still can't directly report it!
Thanks for the heads up Colin. I had noticed that posts reported didn't link to the post requiring moderation, now I know why!

As the defacto tester in this experiment, do you think it's working, or should an alternative by sort?

Sent from my SM-G925F using Tapatalk
__________________
Tony Hine - My Aspiration --- Finding a better way of Explaining ---
From this YouTube:-

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Uncle Gizmo is offline   Reply With Quote
Old 05-15-2018, 11:11 PM   #5
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,912
Thanks: 75
Thanked 1,216 Times in 1,133 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: QRCode Image Generator

I can't think of a better alternative.
As already mentioned, I just click on another post, report that and if necessary state there are N attachments. It's always worked well for me.

__________________
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.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
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.
ridders is offline   Reply With Quote
Reply

Tags
qr code , qrcode , quick reference code

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MD5 hash generator irade92 Modules & VBA 6 09-19-2017 04:39 AM
Survey Generator MStCyr Sample Databases 0 09-05-2006 08:40 AM
Quote Generator Help Sandpiper General 3 03-05-2006 06:05 PM
OrderID Generator latex88 Modules & VBA 3 11-11-2005 09:59 AM
Random Generator jbeasley Forms 1 08-03-2001 09:28 AM




All times are GMT -8. The time now is 02:25 AM.


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

Sponsored Links

How to advertise

Media Kit


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