Cheap/Free BarCode Solutions

I have a need to track some inventory running through my plant. I want to do it by barcodes. I have found many purchased systems and they are just overloaded with features and are extremely expensive.

All I need to track is a work order going through 4 check points and how long they work order was in that location for.

Information that needs to be included are:

Work Order number
Part ID
Quantity
Timestamp
Location

There is a slight kink in the mix where I need to possibly adjust quantities in a work order because sometimes the Work order gets broken up into two work orders. Same work order number just different ID and quantity.

I would like to use SQL or possibly Access. Anyone know of a great off the shelf simply cheap solution here or would my best bet be to just program a solution myself?
Keef4000Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Using barcodes for data entry really is easy. When you scan the barcode,  Windows sends that data to the cursor location in the application with focus. The app sees it as  keyboard input. This means you can use a barcode scanner for data entry in any Windows app.

I usually test a bar code scanner with just plain old Windows Notepad!

You could use any application that will do what you want. The trick is to get a barcode printed with the required data that you will enter into the tracking app.
0
Keef4000Author Commented:
I have seen the "Keyboard like" function barcode scanners, but I was looking for something that didn't have to have a window selected. I just wanted it to scan and go and not have the end user worry about where the mouse is pointed.

The tracking app is the missing link for me which is my main issue.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
but I was looking for something that didn't have to have a window selected. I just wanted it to scan and go and not have the end user worry about where the mouse is pointed.

In that case you probably will want to get a dedicate device with a built in scanner that only runs the tracking app.

check out these:

http://www.amazon.com/Motorola-Symbol-MC9090-G-Handheld-Barcode/dp/B000V25QA6/ref=pd_sim_sbs_e_5

http://www.l-trondirect.com/Intermec-CK3-Mobile-Computer-p/ck3b20d00e110.htm?gdftrk=gdfV25850_a_7c2310_a_7c8644_a_7cCK3B20D00E110

http://www.barcodesinc.com/cats/portable-data-terminals/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Keef4000Author Commented:
Thanks for the links that might do the trick. I'll research those types of devices.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.