Steve Goodhall
steve at goodhall.info
Thu Feb 14 15:08:34 CST 2013
Another option is to get a scanner that stores the data internally as it scans it. You then upload this and use it as a transaction file Regards, Steve Goodhall, MSCS, PMP ----- Original Message ----- From: Access Developers discussion and problem solving To:"Access Developers discussion and problem solving" Cc: Sent:Thu, 14 Feb 2013 11:46:46 -0800 Subject:Re: [AccessD] Adding Bar Coding and Scanners to an Access Application For input I'd go with the 'wedge' approach: http://en.wikipedia.org/wiki/Barcode_reader [1] For output, you need a bar code font - easy to Google up, and add that to your reports. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [2] [mailto:accessd-bounces at databaseadvisors.com [3]] On Behalf Of Brad Marks Sent: Thursday, February 14, 2013 11:28 AM To: Access Developers discussion and problem solving Subject: [AccessD] Adding Bar Coding and Scanners to an Access Application All, In order to save time and improve accuracy, our Vice President of Operations would like for me to look into the possibility of using bar codes to collect "labor" information from the factory floor. This is basically to record the number of parts that are completed by a work-center. To do this, we would like to use a scanner to read the "Job Number" from an Access report (Factory Floor "Traveler"). I have some experience with bar coding back in the 1970s in an IBM mainframe environment, in a prior life, on a different planet :-) I have no experience with bar coding in the Microsoft Access realm. If I have an Access report that has a key (such as "A12345") how can I add a bar code to the report for this piece of information? If I am able to print a bar code for such a piece of information on a report, what is needed in order to use a scanner to "input" this key into an Access application or other Windows-based application? Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com [4] http://databaseadvisors.com/mailman/listinfo/accessd [5] Website: http://www.databaseadvisors.com [6] -- AccessD mailing list AccessD at databaseadvisors.com [7] http://databaseadvisors.com/mailman/listinfo/accessd [8] Website: http://www.databaseadvisors.com [9] Links: ------ [1] http://en.wikipedia.org/wiki/Barcode_reader [2] mailto:accessd-bounces at databaseadvisors.com [3] mailto:accessd-bounces at databaseadvisors.com [4] mailto:AccessD at databaseadvisors.com [5] http://databaseadvisors.com/mailman/listinfo/accessd [6] http://www.databaseadvisors.com [7] mailto:AccessD at databaseadvisors.com [8] http://databaseadvisors.com/mailman/listinfo/accessd [9] http://www.databaseadvisors.com