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

On Mon, 13 Apr 2009 08:24:38 -0700 (PDT), alex <(E-Mail Removed)> wrote:

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

John W. Vinson [MVP]

On Mon, 13 Apr 2009 08:24:38 -0700, alex wrote:

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


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

On Apr 13, 12:42*pm, Rick Brandt <rickbran...@hotmail.com> wrote:
> On Mon, 13 Apr 2009 08:24:38 -0700, alex wrote:
> > 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.
>
> --
> 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

On Apr 13, 12:28*pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> On Mon, 13 Apr 2009 08:24:38 -0700 (PDT), alex <sql_...@yahoo.com> wrote:
> >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 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