what field i can define for the barcode reader

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Naveed Pathan - 09 Jul 2007 10:16 GMT

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

Reply to this Message

Brendan Reynolds - 09 Jul 2007 10:22 GMT

> 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

Check out Tony Towes barcode page at the following URL ...

http://www.granite.ab.ca/access/barcode.htm

Signature

Brendan Reynolds

Reply to this Message

Naveed Pathan - 09 Jul 2007 11:02 GMT

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.

> > 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
>
> Check out Tony Towes barcode page at the following URL ...
>
> http://www.granite.ab.ca/access/barcode.htm

Reply to this Message

Steve - 09 Jul 2007 14:53 GMT

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
resource@pcdatasheet.com

>i appreciate that but friend i need to know that how i can read a barcode
>in
[quoted text clipped - 19 lines]
>>
>> http://www.granite.ab.ca/access/barcode.htm

Reply to this Message

Tony Toews [MVP] - 10 Jul 2007 04:21 GMT

>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
[quoted text clipped - 7 lines]
>i need for the barcode to be read by the barcode reader is it the text field
>or the number field.

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

Signature

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/

Reply to this Message

mcnews - 09 Jul 2007 18:17 GMT

On Jul 9, 5:16 am, Naveed Pathan
<NaveedPat...@discussions.microsoft.com> wrote:

> 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

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).

Reply to this Message