[AccessD] barcode and in stock managment

Hello All,

thanks for your reply.
You maybe missunderstood my question.
I already work with barcodes for years.
They don't have that many secrets for me.

I asked for help on a database for Stock managment,
for examples of such a database.

Pedro Janssen




----- Original Message -----
From: "Erwin Craps - IT Helps" <Erwin.Craps at ithelps.be>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, October 27, 2004 4:28 PM
Subject: RE: [AccessD] barcode and in stock managment


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