Colby, John
JColby at dispec.com
Wed Oct 27 09:06:42 CDT 2004
>The barcode reader we purchased acted like any input device. Whatever field the cursor is in, is where the data is placed. You might want to go with a serial port reader (or usb port these days?). The alternative as a "keyboard wedge" type (sits between the keyboard and PC, inserting the data right into the keyboard stream). These cause problems. The reason is that with the serial port readers you have control over where and when you read the bar code. I have used both and, users being users, when you use the "keyboard wedge", you ALWAYS end up with garbage in word documents, excel documents, the wrong form etc. Basically the user forgets to go to the right place before scanning and they corrupt whatever data they the insertion pointer (cursor / focus) is currently on. The serial port type is more difficult to get set up since you have to use a serial port control (comes with vba), but once set up you can turn on / off the reader (or more correctly the serial port) programmatically, thus controlling when the user can scan data. John W. Colby The DIS Database Guy -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Wednesday, October 27, 2004 9:44 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] barcode and in stock managment A couple of years ago, we wanted to use barcodes for specimens used in evaluating inspectors. After much research on the code to generate the barcode, we purchased a barcode reader. After we purchased the barcode reader, we realized how simple it was. The barcode reader came with the code to generate the barcode and instructions on how to scan the items. In hindsight, we should have bought the barcode reader first, then if needed, do the research to generate the barcode. My recommendation is to decide which barcode reader you want to use first. The information that comes with the barcode reader might just have all the information you need. In Access the easiest barcode to use is called Code 39, which is easily downloaded as a font. As a font, it can be used for any alphanumeric character and can be printed on labels, forms, etc. The barcode reader we purchased acted like any input device. Whatever field the cursor is in, is where the data is placed. HTH Jim H. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of pedro at plex.nl Sent: Wednesday, October 27, 2004 7:38 AM To: AccessD at databaseadvisors.com Subject: [AccessD] barcode and in stock managment Hello group, who can point me in the right direction on the development of a database where i use barcode with: In Stock managment. Thanks Pedro Janssen -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com