Using Barcodes in Access

[Guest]

Hi All

I wonder if you could offer some advice please.

I have set up a very very simple database that hopefully i can use with
barcodes.

It consists of one table that has the following fields

RefNo (autonumber)
Date (automatic)
SendingStr (barcode)
STNNo (manually inputed)
ReceivingStr (barcode)

Some of the table eg STN No will have to be manually inputed into the
database but with the sending and receiving store, these will be scanned off
of a parcel.

Could you tell me whether i have to set the sendingstr and receivingstr
fields up as something other than a number field, would it need to be set as
something else to be able to read the information from the scanner?

Is there any way that once the receivingstr field has been entered that i
could add some form of coding (i am a real beginner with coding) that would
then automatically start a new record.

I am using the Free 3 of 9 Extended Font.

I'm not sure whether anyone would know of any examples of barcode databases?

Thanks as always for your invaluable help.

 

[Frank Stone]

hi,
basicly, bar codes are just another font so no you do not
have to set your fields up with anything special and the
bar code reader is just another form of input like the
keyboard or mouse.
if you are a real beginner and are wanting a way to
automaticly start a new record, i assume you are working
with a bound form.
since i have never worked with bound forms, i can't help
you there. Sorry. I started out doing things the hard way.
but i will recoment that you start whinning yourself from
bound forms. bound forms are good for the beginner and for
small, simple databases but when you start want to do more
advanced things and the database grows, bound forms start
becoming more restrictive. and it looks like your are
starting to run into that. unbound forms require more code
but are more versital.
regards
Frank