Solved

QR  codes

Posted on 2014-03-24
6
208 Views
Last Modified: 2014-03-25
My OS is win 7 prof 64 bit and I use office 2007.  I am trying to enter data of books into the database.  once entered, I would like to have some sort of a barcode  and to retrieve this book onto the screen,  I could scan the barcode. this will might be a better way of typing the title or isbn to search.  Also many of these books do not have the isbn bar code on the book or anywhere on it.
Can the experts advise what is the best strategy to use for this.  
Probably somke sort of bar code that even cell phones are capable of using.  Is QR codes the answer, if yes, can u please point me where I can look up the documentation for someone who has no knowledge about this.  Thank u
0
Comment
Question by:jegajothy
  • 3
  • 2
6 Comments
 
LVL 45

Expert Comment

by:aikimark
ID: 39953177
Are you trying to use the bar code(s) for entering data or for retrieving data?
If a user has a bar code, wouldn't they already have the book?   This is the part of your problem description that makes the least sense to me.
0
 

Author Comment

by:jegajothy
ID: 39953346
I intend to enter the data of the book into an Access db and then when I have to update the data, instead of searching by title or isbn number, which involve typing, I am thinking of scanning the bar code which will bring up the record for my editing.  Sldo domr og yhr books have very close titles, thus making sure the correct is displayed for editing a bit more cumbersome.    Is this a good idea or just not worth the effort. thank u.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 39953802
How are you going to print and look up the bar code?  You could have an entire book of bar codes, just to be able to locate the book.

I don't see a problem with keyboard lookups.  This has been a reliable method for many years.

If you want to add phonetic search capabilities to your application, then that might help with spelling errors.  I am not familiar with "Sldo domr og yhr books", so I can't put the difficulty of book differentiation in any context.
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 15

Accepted Solution

by:
weinberk earned 500 total points
ID: 39954329
If I'm understanding your question correctly, here's what I'd do:

For initial entry:
a) if a book has a barcode, you'll scan that and use it as a record locator and
b) if a book does not have a barcode, you'll create a random unique string and print that in barcode form onto a sticker

To lookup a book with the book in hand, you scan either the barcode from the cover or the sticker, which will enter that string into the database and look it up using the record locator.

Would that work?

I would not use QR codes, instead, I'd consider EAN13 barcodes, which is the same format books use on their ISBN barcodes.  These easily take a string and convert into a linear barcode.  You'd need to be sure that custom barcodes you create to not overlap any real ISBN.    You could either find the ISBN for the book and then print its barcode, or make something up and indicate on the label that it's a CUSTOM code and not true ISBN.  You'd use a different search field for custom codes so there's no chance of overlap.

See http://www.idautomation.com/barcode-faq/isbn/#Create_Bar_Code_for_Book for more info.

Hope this helps.
0
 

Author Comment

by:jegajothy
ID: 39954623
In response to Weinberk, thank u for an awesome response and solution.  Now I can get started.  Thank again.
0
 

Author Closing Comment

by:jegajothy
ID: 39954624
Awesome response, thank u and well done.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now