After scanning a barcode move to next field without clicking enter

[Guest]

I have a form with ten fields (combo box). The field name is
[numero_articulo1], ..., [numero_articulo10].

After I am scanning a barcode in the first field I want to move to the next
field without clicking the enter button. I try using the after update event
but doesn't work, I still have to click the enter button.

I read other questions posted before, because I don’t want to repeat the
question. For what I read:

- The scanner will need a start and stop signal so I will need to
concatenate the data into a field such as = "*" & [DataField]&"*"
Where should I write this formula?


- I has to use a carriage return after the scan.
What is a carriage return and how I can define that?

Thanks in advanced for your help.
Maria

 

[John Vinson]

I have a form with ten fields (combo box). The field name is
[numero_articulo1], ..., [numero_articulo10].

If your table has these fields, you really should consider normalizing
your design. "Fields are expensive, records are cheap" - if you have a
one (something, I don't know what) to many (articulos) relationship,
it should be modeled as a one to many relationship with two tables,
one record for each article.

After I am scanning a barcode in the first field I want to move to the next
field without clicking the enter button. I try using the after update event
but doesn't work, I still have to click the enter button.

What has worked for me involves no code at all, assuming that all of
the barcodes are the same number of characters. Define the table field
(or fields) as having that length, and set the Auto Tab property of
the textbox (or textboxes) to Yes. When you scan a 12-byte string into
the 12-byte field it will automatically tab to the next control in the
form's tab order.

John W. Vinson[MVP]

 

[Guest]

Not all barcodes has the same number of characters; since I am scanning
diferents part number that comes from diferent suppliers. The labels are
already printed, and there are like more than 1,000 part number (or barcode
labels already printed).

I will use a wireless scanner, that why I need to go to the next field
whithout clicking enter.

From other forun in a similar situation someone answer:
"Add code:
onChange="submit();"
to the form fields code
i.e.
Code:
<input type="text" name="TextBoxName" size="20" onChange="submit();">

I don't know where I should write this code?

Thanks for your help.

I have a form with ten fields (combo box). The field name is
[numero_articulo1], ..., [numero_articulo10].

If your table has these fields, you really should consider normalizing
your design. "Fields are expensive, records are cheap" - if you have a
one (something, I don't know what) to many (articulos) relationship,
it should be modeled as a one to many relationship with two tables,
one record for each article.

After I am scanning a barcode in the first field I want to move to the next
field without clicking the enter button. I try using the after update event
but doesn't work, I still have to click the enter button.

What has worked for me involves no code at all, assuming that all of
the barcodes are the same number of characters. Define the table field
(or fields) as having that length, and set the Auto Tab property of
the textbox (or textboxes) to Yes. When you scan a 12-byte string into
the 12-byte field it will automatically tab to the next control in the
form's tab order.

John W. Vinson[MVP]

 

[SF]

Hi,

I used Symbol barcode scanner. The scanner can be programmed to add 'Enter'
and the end of the scanned field. This could be accomplished by simply
scanned a pre-defined code on the manual of the scanner. You may need to
look into the manual of your scanner

SF

Not all barcodes has the same number of characters; since I am scanning
diferents part number that comes from diferent suppliers. The labels are
already printed, and there are like more than 1,000 part number (or
barcode
labels already printed).

I will use a wireless scanner, that why I need to go to the next field
whithout clicking enter.

From other forun in a similar situation someone answer:
"Add code:
onChange="submit();"
to the form fields code
i.e.
Code:
<input type="text" name="TextBoxName" size="20" onChange="submit();">

I don't know where I should write this code?

Thanks for your help.

I have a form with ten fields (combo box). The field name is
[numero_articulo1], ..., [numero_articulo10].

If your table has these fields, you really should consider normalizing
your design. "Fields are expensive, records are cheap" - if you have a
one (something, I don't know what) to many (articulos) relationship,
it should be modeled as a one to many relationship with two tables,
one record for each article.

After I am scanning a barcode in the first field I want to move to the
next
field without clicking the enter button. I try using the after update
event
but doesn't work, I still have to click the enter button.

What has worked for me involves no code at all, assuming that all of
the barcodes are the same number of characters. Define the table field
(or fields) as having that length, and set the Auto Tab property of
the textbox (or textboxes) to Yes. When you scan a 12-byte string into
the 12-byte field it will automatically tab to the next control in the
form's tab order.

John W. Vinson[MVP]

 

[Guest]

Thanks a lot for your reply John Vinson and SF!

The only manual I have first was a Quick Start Guide; whithout the
preffix/suffix information. I download the complete User Guide and scanned
the pre-defined code to add 'Enter' and it works fine.

Appreciate all your help
Maria

Hi,

I used Symbol barcode scanner. The scanner can be programmed to add 'Enter'
and the end of the scanned field. This could be accomplished by simply
scanned a pre-defined code on the manual of the scanner. You may need to
look into the manual of your scanner

SF

Not all barcodes has the same number of characters; since I am scanning
diferents part number that comes from diferent suppliers. The labels are
already printed, and there are like more than 1,000 part number (or
barcode
labels already printed).

I will use a wireless scanner, that why I need to go to the next field
whithout clicking enter.

From other forun in a similar situation someone answer:
"Add code:
onChange="submit();"
to the form fields code
i.e.
Code:
<input type="text" name="TextBoxName" size="20" onChange="submit();">

I don't know where I should write this code?

Thanks for your help.

On Sun, 19 Nov 2006 14:58:01 -0800, maria

I have a form with ten fields (combo box). The field name is
[numero_articulo1], ..., [numero_articulo10].

If your table has these fields, you really should consider normalizing
your design. "Fields are expensive, records are cheap" - if you have a
one (something, I don't know what) to many (articulos) relationship,
it should be modeled as a one to many relationship with two tables,
one record for each article.

After I am scanning a barcode in the first field I want to move to the
next
field without clicking the enter button. I try using the after update
event
but doesn't work, I still have to click the enter button.

What has worked for me involves no code at all, assuming that all of
the barcodes are the same number of characters. Define the table field
(or fields) as having that length, and set the Auto Tab property of
the textbox (or textboxes) to Yes. When you scan a 12-byte string into
the 12-byte field it will automatically tab to the next control in the
form's tab order.

John W. Vinson[MVP]