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.
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.
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!
Haha. Thanks. Yeah, there are a lot of good videos on TH-cam, 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. :)
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
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.
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?
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?
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
@@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
@@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
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!
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
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.
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.
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?
@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.
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 😊😉
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."
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.
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.
599cd.com/Ask
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.
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
@@599CD Trash 80! I had a TI-99 so I would have had an attitude.
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!
Haha. Thanks. Yeah, there are a lot of good videos on TH-cam, 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. :)
@@599CD lol..... a touch of arrogance. Thanks for the video anyway
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
With most scanners that I've used, that's an option you can set in the scanner software
In the barcode manual they likely provided there is a barcode you scan to set that setting.
I have a question: How can I print a sheet of paper directly on the printer after adding the barcode?
You can make a button to print the report directly to the printer just pick open normal instead of open print preview
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.
Yep
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?
Hi, is there a way to auto clear the search text box after scanning and opening of new form?
Sure. Isn't that covered in the extended cut? You just say SearchField="" when you're done.
Mad respect to you sir Rich. This topics are quite helpful to us
Thank you very much.
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?
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
@@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
is there a way when I read the barcode the time recorded automatically??
=Now()
@@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
@@AnasAlyousofi it requires VBA. After update on the qrcode txtbox, time txtbox =now().
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!
Isn't that what's covered in the video?
Love the Boondocks Saints reference lol, great video
Classic
Thanks Mr Rich
Do you have a sample of ms access database to connect fingerprint reader? Please share video if you have
Thanks
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
How to lock only scan? because I don't want to typing and past
Huh?
In microsoft visual.basic 6.0...how bar code scanner scan the bar code from papers to the textbox of your system
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.
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.com/Ask
Thanx Rick. I had always wanted to understand how the bar codes work.
You got it! :)
I want to scan product code and lookup on same Form can you please Help sir ?
Sure. Covered here: 599cd.com/BarcodeSeminar
@@599CD if you can help with a free video will thankful to you please
The video you are commenting on IS the free video.
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?
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.com/Consulting
Were you able to solve this problem? Does anyone have a product that lets you scan a UPC and retrieves the title and price?
Not Axes, but Axis, Axes are primarily used to cut wood, Axis is a direction
The plural of axis is axes. tinyurl.com/ysvfrx9d
@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.
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 😊😉
Memberships: 599cd.com/MembershipDB
Checking In and Out: 599cd.com/ACD23
MR. RICH ADD THE LINK TO DOWNLOAD THE TEMPLATE.
It's in the description below the video: 599cd.com/Barcode
What kind of Barcode scanner can use Wireless or Wire Barcode Scanner
Any kind you want, pretty much. I give some tips in the video, and some links to scanners I recommend in the description.
Really helpful Richard, Thank you
Very welcome
hey Man you're magic. my saviour Thanks a million
Happy to help
Great Work!!!
Thank you! Cheers!
great sir 🔥🔥 .. Im from indonesia
Hi. I'm from Buffalo NY, now living in Florida. :)
Nice till you find out the same product can have different barcodes and different products have the same barcodes
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."
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.
RESPECT MAN
Thanks!
Great
Thanks
This guy sounds like JShlatt
Uhm... cool?