what field i can define for the barcode reader

N

Naveed Pathan

how i can define a field for a barcode reader to attach barcode read to my
computer and automattically write the price or the value in the field
 
N

Naveed Pathan

i appreciate that but friend i need to know that how i can read a barcode in
microsoft Access to get the exact value of the item for example
if i have a table

item barcode
apple ?

suppose if i have an apple with barcode on it and i have the barcode reader
and i want to read that barcode so how can i and furthermore that what field
i need for the barcode to be read by the barcode reader is it the text field
or the number field.
 
S

Steve

You need:
TblFruit
FruitID
FruitName

Where FruitID is autonumber. All you need is a textbox on a report with the
font set to your barcode font. In that textbox you print FruitID. The
barcode scanner then can read the FruitID barcode and associate it with
Apple.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
M

mcnews

how i can define a field for a barcode reader to attach barcode read to my
computer and automattically write the price or the value in the field
Click to expand...

it already works.
you needn't do anything unless you are using a non standard barcode
type.
the reader does the work.
just place the cursor in the textbox that you want to receive the
input and fire away.
you do what ever coding that you would regularly do (business rules,
etc).
 
T

Tony Toews [MVP]

Naveed Pathan said:
i appreciate that but friend i need to know that how i can read a barcode in
microsoft Access to get the exact value of the item for example
if i have a table

item barcode
apple ?

suppose if i have an apple with barcode on it and i have the barcode reader
and i want to read that barcode so how can i and furthermore that what field
i need for the barcode to be read by the barcode reader is it the text field
or the number field.
Click to expand...

The item number field on the transaction table is a combo box with the
values coming from the item table. In hidden fields in the combo box
you can put in the price and other data you might need such as taxable
or not.

You will need to put some code in behind the AfterUpdate event of the
field which will then update the price on the screen from the column
on the combo box.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top