PDA

View Full Version : access - using scanner



sjvenz
08-01-2005, 03:56 AM
Is it possibel to have access linked to a scanner to read Bar Codes.

As I would like to build a database for inventory control if possible where the users use a scanner for entry:dunno

xCav8r
08-01-2005, 06:50 AM
:hi:

Yes, it's possible. There are oodles of third party apps and plugins that will add bar codes to lots of applications. Just search in google for access and barcodes, and I'm sure you'll return more results than you can read. :yes

xCav8r
08-08-2005, 08:52 PM
sjvenz, how has this worked out for you?

Ken Puls
08-08-2005, 10:03 PM
Hi sjvenz,

One REALLY important thing to note when dealing with barcodes in any app... they just look like numbers. Make sure that your field type is a string, or else they will drop all leading zeros on you.

HTH,

xCav8r
08-09-2005, 05:29 PM
Yes, making the field type text is the easiest way to go. (An alternative is to set the format so that it preserves leading zeros.) If it's an .adp, then use var(char). You won't need to use the numbers for calculations, so there's really no impact performance by storing as text.