[AccessD] barcode and in stock managment

Erwin Craps - IT Helps Erwin.Craps at ithelps.be
Wed Oct 27 09:28:19 CDT 2004


 The  in-between-keyboard barcodescanner only works with PS2 type of
keyboards.
Some brand are migrating to USB connector keyboards.

The in-between-keyboard barcodescanner does not work when no PS2
keyboard is connected.

Erwin

-----Oorspronkelijk bericht-----
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens Colby, John
Verzonden: woensdag 27 oktober 2004 16:07
Aan: 'Access Developers discussion and problem solving'
Onderwerp: RE: [AccessD] barcode and in stock managment

>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
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list