Automatically save/go to new record

[alex]

Hello all,

I posted a similar question under “One record after another” but I
didn’t think my question was too clear, so I reposted.

I have a form with only one text box in which the user enters data.

I have a user with an electronic wand and a pile of merchandise.

When the user wands the merchandise barcode, Access reads it just find
and displays the number in the textbox.

I want Access to then automatically save and clear the textbox and
prepare for another number, all without the user doing anything; i.e.,
all that he/she does is wand merchandise, one after the other.

I have searched high and low for a way to do this…no luck.

I know that Excel can be configured to accept the number and then move
down a cell automatically (not sure if that helps with any logic).

Thanks for any help.
alex

 

[John W. Vinson]

Hello all,

I posted a similar question under “One record after another” but I
didn’t think my question was too clear, so I reposted.

I have a form with only one text box in which the user enters data.

I have a user with an electronic wand and a pile of merchandise.

When the user wands the merchandise barcode, Access reads it just find
and displays the number in the textbox.

I want Access to then automatically save and clear the textbox and
prepare for another number, all without the user doing anything; i.e.,
all that he/she does is wand merchandise, one after the other.

I have searched high and low for a way to do this…no luck.

I know that Excel can be configured to accept the number and then move
down a cell automatically (not sure if that helps with any logic).

Thanks for any help.
alex

Most barcode readers have software that lets you set options; one useful one
in this case is to have the scanner send a <Tab> or <Enter> keycode after the
scan. If the textbox for the wanded field is last in the form's Tab Order,
*and* if the Form's Cycle property is set to "All Records" (that's the
default), then Access will indeed save the record and move to the next one,
all by itself.

If you have problems with this please post some more details.

 

[Rick Brandt]

Hello all,

I posted a similar question under “One record after another†but I
didn’t think my question was too clear, so I reposted.

I have a form with only one text box in which the user enters data.

I have a user with an electronic wand and a pile of merchandise.

When the user wands the merchandise barcode, Access reads it just find
and displays the number in the textbox.

I want Access to then automatically save and clear the textbox and
prepare for another number, all without the user doing anything; i.e.,
all that he/she does is wand merchandise, one after the other.

I have searched high and low for a way to do this…no luck.

I know that Excel can be configured to accept the number and then move
down a cell automatically (not sure if that helps with any logic).

Thanks for any help.
alex

You can configure your scanner so that it will automatically send a Tab
or Enter key after each scan.

You can configure the form so that tabbing out of the last control in the
TabOrder will move you to the next record (the cycle property).

If your form has only the one control, the combination of the above
should give you what you want.

 

[alex]

You can configure your scanner so that it will automatically send a Tab
or Enter key after each scan.

You can configure the form so that tabbing out of the last control in the
TabOrder will move you to the next record (the cycle property).  

If your form has only the one control, the combination of the above
should give you what you want.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com- Hide quoted text -

- Show quoted text -

Thanks Rick,
You're right, there's a character return setting.
I got it to work, thanks.
alex

 

[alex]

Most barcode readers have software that lets you set options; one useful one
in this case is to have the scanner send a <Tab> or <Enter> keycode afterthe
scan. If the textbox for the wanded field is last in the form's Tab Order,
*and* if the Form's Cycle property is set to "All Records" (that's the
default), then Access will indeed save the record and move to the next one,
all by itself.

If you have problems with this please post some more details.
--

             John W. Vinson [MVP]- Hide quoted text -

- Show quoted text -

Thanks John.
The key was programming the barcode reader to send the keycode that
you mentioned.
alex