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

  Рет қаралды 76,602

Computer Learning Zone

Computer Learning Zone

Күн бұрын

Пікірлер: 74
@bigneiltoo
@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
@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
@bigneiltoo Жыл бұрын
@@599CD Trash 80! I had a TI-99 so I would have had an attitude.
@chargermopar
@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
@599CD 3 жыл бұрын
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
@anythingfootball3786 2 жыл бұрын
@@599CD lol..... a touch of arrogance. Thanks for the video anyway
@mubeezimicah5678
@mubeezimicah5678 3 жыл бұрын
Thanx Rick. I had always wanted to understand how the bar codes work.
@599CD
@599CD 3 жыл бұрын
You got it! :)
@kensimba7868
@kensimba7868 6 күн бұрын
Mad respect to you sir Rich. This topics are quite helpful to us
@599CD
@599CD 4 күн бұрын
Thank you very much.
@n3oninja
@n3oninja 3 жыл бұрын
Love the Boondocks Saints reference lol, great video
@599CD
@599CD 3 жыл бұрын
Classic
@SoftwareSolutons
@SoftwareSolutons 2 жыл бұрын
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
@599CD 2 жыл бұрын
Yep
@eng-luma8105
@eng-luma8105 3 күн бұрын
Hello sir, did you make the product ID field disabled so that the first option is activated directly on the product code field and the code is registered automatically? Please reply. Thank you.
@accessdevelopingzone7603
@accessdevelopingzone7603 8 ай бұрын
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?
@WilliamGordon-m5s
@WilliamGordon-m5s 2 ай бұрын
Does anyone know how to barcode read into Access "Item1", "Item2", "Item3, etc,etc "Shelf1"? I have a table ready to go with [Item] and [Shelf], and a form with an unbound text box, but - no code! Many thanks!
@tharindurathnayake9345
@tharindurathnayake9345 8 ай бұрын
@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.
@younis9220
@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
@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
@rogerazevedo3861
@rogerazevedo3861 3 жыл бұрын
hey Man you're magic. my saviour Thanks a million
@599CD
@599CD 3 жыл бұрын
Happy to help
@mariorockero
@mariorockero 3 жыл бұрын
Hi, is there a way to auto clear the search text box after scanning and opening of new form?
@599CD
@599CD 3 жыл бұрын
Sure. Isn't that covered in the extended cut? You just say SearchField="" when you're done.
@ryanfajardo2321
@ryanfajardo2321 3 жыл бұрын
Really helpful Richard, Thank you
@599CD
@599CD 3 жыл бұрын
Very welcome
@Nvidia-v7o
@Nvidia-v7o 10 ай бұрын
I have a question: How can I print a sheet of paper directly on the printer after adding the barcode?
@599CD
@599CD 10 ай бұрын
You can make a button to print the report directly to the printer just pick open normal instead of open print preview
@csskongen
@csskongen 2 жыл бұрын
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
@599CD 2 жыл бұрын
With most scanners that I've used, that's an option you can set in the scanner software
@bigneiltoo
@bigneiltoo Жыл бұрын
In the barcode manual they likely provided there is a barcode you scan to set that setting.
@Clpmvsshrt
@Clpmvsshrt 3 жыл бұрын
In microsoft visual.basic 6.0...how bar code scanner scan the bar code from papers to the textbox of your system
@599CD
@599CD 3 жыл бұрын
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
@reliks14 3 жыл бұрын
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
@599CD 3 жыл бұрын
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
@reliks14 3 жыл бұрын
@@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
@AnasAlyousofi 2 жыл бұрын
is there a way when I read the barcode the time recorded automatically??
@599CD
@599CD 2 жыл бұрын
=Now()
@AnasAlyousofi
@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
@kensimba7868 2 жыл бұрын
@@AnasAlyousofi it requires VBA. After update on the qrcode txtbox, time txtbox =now().
@Stache987
@Stache987 Жыл бұрын
Not Axes, but Axis, Axes are primarily used to cut wood, Axis is a direction
@599CD
@599CD Жыл бұрын
The plural of axis is axes. tinyurl.com/ysvfrx9d
@adityaupadhyay9720
@adityaupadhyay9720 3 жыл бұрын
Great Work!!!
@599CD
@599CD 3 жыл бұрын
Thank you! Cheers!
@xhianne182
@xhianne182 3 жыл бұрын
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
@599CD 3 жыл бұрын
Memberships: 599cd.com/MembershipDB Checking In and Out: 599cd.com/ACD23
@omelmedina100
@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 Жыл бұрын
599cd.com/Ask
@halolaosgisa9790
@halolaosgisa9790 2 жыл бұрын
How to lock only scan? because I don't want to typing and past
@599CD
@599CD 2 жыл бұрын
Huh?
@UnDigableDigs
@UnDigableDigs 3 жыл бұрын
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
@UnDigableDigs 3 жыл бұрын
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 3 жыл бұрын
599cd.com/Consulting
@bigneiltoo
@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?
@burhanuddindadawala1377
@burhanuddindadawala1377 3 жыл бұрын
I want to scan product code and lookup on same Form can you please Help sir ?
@599CD
@599CD 3 жыл бұрын
Sure. Covered here: 599cd.com/BarcodeSeminar
@burhanuddindadawala1377
@burhanuddindadawala1377 3 жыл бұрын
@@599CD if you can help with a free video will thankful to you please
@599CD
@599CD 3 жыл бұрын
The video you are commenting on IS the free video.
@yessir66666
@yessir66666 3 жыл бұрын
great sir 🔥🔥 .. Im from indonesia
@599CD
@599CD 3 жыл бұрын
Hi. I'm from Buffalo NY, now living in Florida. :)
@AlaeAbajlal
@AlaeAbajlal 3 жыл бұрын
RESPECT MAN
@599CD
@599CD 3 жыл бұрын
Thanks!
@jaimeteixeira2232
@jaimeteixeira2232 3 жыл бұрын
MR. RICH ADD THE LINK TO DOWNLOAD THE TEMPLATE.
@599CD
@599CD 3 жыл бұрын
It's in the description below the video: 599cd.com/Barcode
@accessdevelopingzone7603
@accessdevelopingzone7603 3 жыл бұрын
What kind of Barcode scanner can use Wireless or Wire Barcode Scanner
@599CD
@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
@samokoth1014 Жыл бұрын
Great
@599CD
@599CD Жыл бұрын
Thanks
@boerinbeton7052
@boerinbeton7052 3 жыл бұрын
Nice till you find out the same product can have different barcodes and different products have the same barcodes
@599CD
@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
@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
@topping1.0 2 жыл бұрын
This guy sounds like JShlatt
@599CD
@599CD 2 жыл бұрын
Uhm... cool?
Printing Custom Barcode Labels from your Microsoft Access Database
19:09
Computer Learning Zone
Рет қаралды 25 М.
Deadpool family by Tsuriki Show
00:12
Tsuriki Show
Рет қаралды 7 МЛН
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 149 МЛН
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 21 МЛН
Cat mode and a glass of water #family #humor #fun
00:22
Kotiki_Z
Рет қаралды 21 МЛН
How to Open a Microsoft Access Form to a Specific Record Without Filtering
16:59
Computer Learning Zone
Рет қаралды 1,2 М.
HOW TO: BARCODE INVENTORY MANAGEMENT FOR SMALL BUSINESSES
12:11
Stardust by Allie
Рет қаралды 116 М.
How to Create Readable Barcode in Microsoft Access
17:18
LoopLearnings
Рет қаралды 23 М.
Example of Sale & Inventory Transaction Using a Scanner
19:34
T Golden Eye
Рет қаралды 48 М.
Deadpool family by Tsuriki Show
00:12
Tsuriki Show
Рет қаралды 7 МЛН