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

Подписаться 235 тыс.

Просмотров 71 тыс.

50% 1

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:
RU-vid: / @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:
Autonumbers: 599cd.com/AutoNumbers
Imaging: 599cd.com/Image
Invoicing: 599cd.com/Invoicing
Double Double Quotes: 599cd.com/DoubleDouble
RECOMMENDED PRODUCTS
Wired 1D Scanner $21: 599cd.com/BarcodeScanner1
Wireless 1D Scanner $37: 599cd.com/BarcodeScanner2
Wireless 2D Scanner $44: 599cd.com/BarcodeScanner3
QR & Barcode Reader (Android): 599cd.com/QRBarcode
ONLINE ISBN LOOKUPS
openlibrary.org/dev/docs/api/...
developers.google.com/books/d...
isbndb.com/apidocs/v2
ONLINE UPC LOOKUPS
devs.upcitemdb.com/
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
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...
Email Me: amicron@gmail.com
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.

Опубликовано:

1 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 72

@mubeezimicah5678 3 года назад

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

@599CD 3 года назад

You got it! :)

@chargermopar 3 года назад

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 3 года назад

Haha. Thanks. Yeah, there are a lot of good videos on RU-vid, 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 2 года назад

Love the Boondocks Saints reference lol, great video

@599CD 2 года назад

Classic

@alberts3482 3 года назад

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

@599CD 3 года назад

Coming soon!

@ryanfajardo2321 2 года назад

Really helpful Richard, Thank you

@599CD 2 года назад

Very welcome

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

@adityaupadhyay9720 3 года назад

Great Work!!!

@599CD 3 года назад

Thank you! Cheers!

@rogerazevedo3861 2 года назад

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

@599CD 2 года назад

Happy to help

@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

@yessir66666 3 года назад

great sir 🔥🔥 .. Im from indonesia

@599CD 3 года назад

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

@younis9220 3 года назад

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

@599CD 3 года назад

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

@mariorockero 2 года назад

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

@599CD 2 года назад

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

@tharindurathnayake9345 3 месяца назад

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

@AlaeAbajlal 3 года назад

RESPECT MAN

@599CD 3 года назад

Thanks!

@xhianne182 2 года назад

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 2 года назад

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

@juswa11 2 года назад

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

@599CD 2 года назад

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.

@accessdevelopingzone7603 2 месяца назад

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?

@user-yx4gj3ch7v 4 месяца назад

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

@599CD 4 месяца назад

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

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

@reliks14 2 года назад

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 2 года назад

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 2 года назад

@@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

@AnasAlyousofi 2 года назад

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

@599CD 2 года назад

=Now()

@AnasAlyousofi 2 года назад

@@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 2 года назад

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

@Stache987 8 месяцев назад

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

@599CD 8 месяцев назад

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

@UnDigableDigs 2 года назад

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 2 года назад

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 2 года назад

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?

@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

@halolaosgisa9790 Год назад

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

@599CD Год назад

Huh?

@burhanuddindadawala1377 2 года назад

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

@599CD 2 года назад

Sure. Covered here: 599cd.com/BarcodeSeminar

@burhanuddindadawala1377 2 года назад

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

@599CD 2 года назад

The video you are commenting on IS the free video.

@accessdevelopingzone7603 3 года назад

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

@599CD 3 года назад

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

@samokoth1014 Год назад

Great

@599CD Год назад

Thanks

@jaimeteixeira2232 2 года назад

MR. RICH ADD THE LINK TO DOWNLOAD THE TEMPLATE.

@599CD 2 года назад

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

@boerinbeton7052 3 года назад

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

@599CD 3 года назад

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.