Scanning Barcodes (UPC, ISBN, EAN, etc.) to Lookup Products in your Microsoft Access Database

In this video, we'll discuss the types of barcode scanners, the different types of barcodes, 1D and 2D barcode symbologies, using your cell phone as a barcode reader, creating a product table with a barcode field, creating a form to scan a barcode and look up a product.
Coleman from Honolulu, Hawaii (a Platinum Member) asks: I would love to be able to use a barcode scanner with my Access database. At first, it would be nice to be able to just scan a product and have the details appear on the screen while I'm talking to a customer, but eventually I'd like to be able to tie it in to my order entry system. I know nothing about scanners. Can you help?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to scan a product and have it automatically added to an invoice. We'll also check to see if the product is already on the order, and if so, increment the value by one instead of adding lots of line items. We will also learn how to scan a product and perform a Google search on it to display details. Great for books or any product with a UPC barcode.
MEMBERS VIDEO:
• Scanning Barcodes (UPC...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
BARCODE LESSONS:
Barcode Scanning: 599cd.com/Barc...
Barcode Printing: 599cd.com/Barc...
Barcode Seminar Full: 599cd.com/Barc...
QR Codes: 599cd.com/QRCodes
LINKS:
Autonumbers: 599cd.com/Auto...
Imaging: 599cd.com/Image
Invoicing: 599cd.com/Invo...
Double Double Quotes: 599cd.com/Doub...
RECOMMENDED PRODUCTS
Wired 1D Scanner $21: 599cd.com/Barc...
Wireless 1D Scanner $37: 599cd.com/Barc...
Wireless 2D Scanner $44: 599cd.com/Barc...
QR & Barcode Reader (Android): 599cd.com/QRBa...
ONLINE ISBN LOOKUPS
openlibrary.or...
developers.goo...
isbndb.com/api...
ONLINE UPC LOOKUPS
devs.upcitemdb...
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/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/Cons...
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
Email Me: [e-mail]
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, barcode scanners, corded, wireless, laser, image, cell phone, 1d, 2d, upc code, ean, code 39, code39, code 128, usps postnet, qr code, data matrix, aztec, pdf417, dotcode, default button property
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@chargermopar]

My wired barcode scanner I first used has a PS/2 bridge and of course uses no drivers. It is still working on my shop computer. I have been thinking of making a video of how I set up my My Sql database with Php. Your video style is so clear and intuitave compared to almost any other person here, especially the foreigners!

[@599CD]

Haha. Thanks. Yeah, there are a lot of good videos on KZbin, but if you can't understand the presenter, they're very difficult to watch. I get some people asking me to slow down my speaking because they don't speak English as a native language, to which I have to reply, "I'm sorry." I'm not going to change my presentation style for folks to don't speak English well. Lots of tutorials on learning English too. Start with those. :)

[@anythingfootball3786]

@@599CD lol..... a touch of arrogance. Thanks for the video anyway

[@n3oninja]

Love the Boondocks Saints reference lol, great video

[@599CD]

Classic

[@bigneiltoo]

You have Herbert Schildt! I learned C from his Using Turbo C book (1987) and Advanced Turbo C (1988). One of my favorite tech authors of all time! Can't believe how long ago it was. Nothing ever seemed more modern than Borland Turbo C.

[@599CD]

Yeah I love that book. I taught myself programming on a TRS 80 using the color computer manual but my first real programming book was Teach Yourself C

[@bigneiltoo]

@@599CD Trash 80! I had a TI-99 so I would have had an attitude.

[@mubeezimicah5678]

Thanx Rick. I had always wanted to understand how the bar codes work.

[@599CD]

You got it! :)

[@accessdevelopingzone7603]

I have a single request: How can I link the DigitalPersona 450 to a Microsoft Access Database for managing attendance, similar to how a barcode scanner operates?

[@alberts3482]

Thank you. Very useful. Looking forward to the links & related videos on barcodes.

[@599CD]

Coming soon!

[@SoftwareSolutons]

When we add an item (product) to the inventory it will be two steps proccess 1. generate the bar code for that product, print it and put it on the product 2. scan and add it to the inventory.

[@599CD]

Yep

[@user-yx4gj3ch7v]

I have a question: How can I print a sheet of paper directly on the printer after adding the barcode?

[@599CD]

You can make a button to print the report directly to the printer just pick open normal instead of open print preview

[@tharindurathnayake9345]

@Computer Learning Zone Interesting and a very useful video mate. Much appreciate if you could demonstrate a library management system integrated with barcode scanners for ID scanning and book scanning using Microsoft access.

[@rogerazevedo3861]

hey Man you're magic. my saviour Thanks a million

[@599CD]

Happy to help

[@omelmedina100]

I tried creating this myself. Yet whenever I search it up, the form shows up but none of the data will. I copied and pasted my inventory table that has all the data and fields. I named it Lookup and pasted the fields I wanted into the form I created. The forms record source is using the lookup table. I added a regular text box and named the unbound box "Lookup". I then placed a button and did the following: Form Operations, Open Form, Selected my newly made form, specific data. I matched "Lookup" with "Item ID" and then did the rest. I made up one record to try all this and the unique number I put into the search box is the same number I have in the Item ID. But all the fields are empty after I search. Please help me.

[@599CD]

599cd.com/Ask

[@csskongen]

big problem for me all the bar code scanners i get my hand on to when u scan a bar code in the computer also presses enter what brand to buy to get the option to have no enter after each scan

[@599CD]

With most scanners that I've used, that's an option you can set in the scanner software

[@bigneiltoo]

In the barcode manual they likely provided there is a barcode you scan to set that setting.

[@juswa11]

In microsoft visual.basic 6.0...how bar code scanner scan the bar code from papers to the textbox of your system

[@599CD]

I haven't used VB6 in years, but the actual scanning happens at the hardware level. Most scanners will send text just as if it was typed at the keyboard.

[@reliks14]

I'm in need of assistance. I need to figure out how to scan a barcode that will fill in multiple boxes at once. I'm doing this via computer and it's just so slow using drop boxes and my mouse.Is that even possible?

[@599CD]

You mean you want to scan one barcode after another and have them go into successive boxes without interaction from the mouse? Sure. I cover that in my Barcode Seminar. 599cd.com/BarcodeSeminar

[@reliks14]

@@599CD yeah that's pretty close to what I'd like to learn. It's for 4 boxes total. Would be awesome if I could just scan 1 barcode and it fill every box in lol

[@ryanfajardo2321]

Really helpful Richard, Thank you

[@599CD]

Very welcome

[@UnDigableDigs]

Here's what I need help with. I sell music on ebay & discogs. I have mountains of music and want to create an inventory management system. To make this more efficient, I want to be able to scan a upc/barcode with a handheld digital barcode scanner (i don't want to use my phone), have that number sent to a spreadsheet cell on my computer, and somehow have an external database (like discogs who have an open API and have monthly data dumps) linked/be my database to pull product details from. Does this make sense? I want to scan, have that scan pull available data into the spreadsheet, along with the barcode, and so forth, so I don't have to manually enter each barcode and product information into each cell. I want a high efficient way to capture it all while i simultaneously shelve each scanned item - its almost like i'm starting my own library. Are you able to help at all with this?

[@UnDigableDigs]

Are we able to have a one-on-one consultation? That would really help. What Is your contact info? Any help is appreciated, thanks.

[@599CD]

599cd.com/Consulting

[@bigneiltoo]

Were you able to solve this problem? Does anyone have a product that lets you scan a UPC and retrieves the title and price?

[@mariorockero]

Hi, is there a way to auto clear the search text box after scanning and opening of new form?

[@599CD]

Sure. Isn't that covered in the extended cut? You just say SearchField="" when you're done.

[@younis9220]

Thanks Mr Rich Do you have a sample of ms access database to connect fingerprint reader? Please share video if you have Thanks

[@599CD]

Sorry, no. I've never worked with fingerprint readers. I'll tell you the same thing I told my student who wanted to learn how to print barcodes on a Dymo printer: send me one and I'll figure it out. In your case, I'll "finger" it out. LOL

[@Stache987]

Not Axes, but Axis, Axes are primarily used to cut wood, Axis is a direction

[@599CD]

The plural of axis is axes. tinyurl.com/ysvfrx9d

[@halolaosgisa9790]

How to lock only scan? because I don't want to typing and past

[@599CD]

Huh?

[@xhianne182]

Sir Rick, is it possible to make a membership data base on access and a QR/Barcode scanning for check in and out? please make a tutorial 🙏🙏🙏 Thank you in advance 😊😉

[@599CD]

Memberships: 599cd.com/MembershipDB Checking In and Out: 599cd.com/ACD23

[@adityaupadhyay9720]

Great Work!!!

[@599CD]

Thank you! Cheers!

[@yessir66666]

great sir 🔥🔥 .. Im from indonesia

[@599CD]

Hi. I'm from Buffalo NY, now living in Florida. :)

[@AnasAlyousofi]

is there a way when I read the barcode the time recorded automatically??

[@599CD]

=Now()

[@AnasAlyousofi]

@@599CD I watched most of your videos and they were all helpful And thank you for that My problem is: When I read the barcode in the text box (the search box) it shows the person's data, but I want it to record the time in another text box in another form

[@kensimba7868]

@@AnasAlyousofi it requires VBA. After update on the qrcode txtbox, time txtbox =now().

[@burhanuddindadawala1377]

I want to scan product code and lookup on same Form can you please Help sir ?

[@599CD]

Sure. Covered here: 599cd.com/BarcodeSeminar

[@burhanuddindadawala1377]

@@599CD if you can help with a free video will thankful to you please

[@599CD]

The video you are commenting on IS the free video.

[@samokoth1014]

Great

[@599CD]

Thanks

[@AlaeAbajlal]

RESPECT MAN

[@599CD]

Thanks!

[@accessdevelopingzone7603]

What kind of Barcode scanner can use Wireless or Wire Barcode Scanner

[@599CD]

Any kind you want, pretty much. I give some tips in the video, and some links to scanners I recommend in the description.

[@jaimeteixeira2232]

MR. RICH ADD THE LINK TO DOWNLOAD THE TEMPLATE.

[@599CD]

It's in the description below the video: 599cd.com/Barcode

[@boerinbeton7052]

Nice till you find out the same product can have different barcodes and different products have the same barcodes

[@599CD]

The same product having different barcodes is definitely a possibility. If that's the case you can either add the product twice, or use a 2nd table with a 1-to-many relationship to store the various barcode numbers. Two products having the same barcode, with a universal numbering system like UPC or ISBN, I've never come across that. I'm not saying it's not possible, I'm sure there are mess-ups all the time. In that case I guess you'd have to prompt the user and say "yo, that code is already assigned."

[@bigneiltoo]

Yes, sadly the old Playboys don't have unique barcodes. If you scan March 2000 it will give you some other month. I verified that multiple mags use the same barcode. Also, some products like cigars are blacklisted.

[@topping1.0]

This guy sounds like JShlatt

[@599CD]

Uhm... cool?