×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Barcode Scanning Into Access 2003

Barcode Scanning Into Access 2003

Barcode Scanning Into Access 2003

(OP)
Good Afternoon everyone.

Due to development being frozen on our main system. I've been tasked on implementing another tool that will Scan Barcodes and send this data into an access Database.
Users at multiple stations will be scanning error codes ( Barcode Format) and it should populate a single access database.

Has anyone had experience with any good tools in this regard?

Thanks.

RE: Barcode Scanning Into Access 2003

You may want to contact www.tek-tips.com  They have alot of excellent software experts on that sight.


ck1999

RE: Barcode Scanning Into Access 2003

Maybe it is just today (I am in an odd mood) but I would think that these barcodes are being printed or generated from (at some time) data that is already in an electronic format.  Why print a barcode then spend the manpower just to scan it back into an electronic database rather than grabbing the data directly?  I am missing something or was this what you meant by development being frozen on your main system?

Regards,

RE: Barcode Scanning Into Access 2003

(OP)
We have error codes we'd like to generate into Bar Codes.
Our Manufacturing users will then scan these Bar Codes whenever an error occurs.

We want to collect this information into a database to find out where our main deficiencies are...

Thanks,
HME

RE: Barcode Scanning Into Access 2003

(OP)
What I ended up doing was create the DB.

Then using a Data Access Page that will be placed on every users Desktop.

They will open it up and scan in the bar code whenever there is an error.

Thanks

RE: Barcode Scanning Into Access 2003

Bar code sans are an OK way to collect 'down time' issues but you will have to monitor them and the reasons closely or the real reasons maybe missed.

An alternative is touch screen panels, I ahve used these alot. A bit more expensive but can provide better info.  The screens can be configured to display the likely cause based on where the problem occured in the machine.

Hope this is of some help

RE: Barcode Scanning Into Access 2003

USB barcode scanners are rediculously easy to use. They work just like you typed the input into the keyboard. It should have very little effect on how you design your Access application. My experience was with USB wasp barcode scanners - they work great!

http://www.waspbarcode.com/

----
Nathan Boeger
http://www.inductiveautomation.com
Total SCADA Freedom

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources