Run Code on Data input without click

[Mike]

Hi,
I want to add code to have MS Access automatically trigger
the keyboard "Enter Key" command when the user populates a
data field. I have a bar code scanner attached to the pc
and the user will scan the barcode which will be populated
into a data field I have on the access form. Now, instead
of the user pressing the "Enter Key" on the keyboard or
clicking on a button after scanning the barcode, I want
to call a function to trigger the enter key on the
keyboard so I can display the info for that scanned
barcode.

Thanks,

 

[Fred Boer]

Dear Mike:

I can't answer the code question, but I suggest you look at the manual for
your barcode scanner. I use a "wedge" type barcode scanner, which
"piggy-backs" onto the keyboard port. My scanner can be programmed to
automatically send an "Enter" after the scanned number. You may be able to
enable this in the firmware settings of your scanner, and avoid any coding
at all.

HTH
Fred Boer

 

[Mike]

I'll check into it.

Thanks for your help.

-----Original Message-----
Dear Mike:

I can't answer the code question, but I suggest you look at the manual for
your barcode scanner. I use a "wedge" type barcode scanner, which
"piggy-backs" onto the keyboard port. My scanner can be programmed to
automatically send an "Enter" after the scanned number. You may be able to
enable this in the firmware settings of your scanner, and avoid any coding
at all.

HTH
Fred Boer




.

 

[PC Datasheet]

Mike,

You don't need to press the enter key! When the barcode scanner populates
the data field and you see a value in the data field on the screen, it's
already been entered. If you want something to happen after the barcode is
scanned, program the AfterUpdate event of the textbox. If it needs to be
immediately saved, use this code:
DoCmd.RunCommand asSaveRecord

 

[Mike]

Yes, I want to do a lookup on the Barcoded ID
that is scanned...so I could just use the AfterUpdate
event when the ID is scanned?

Thanks for your help.

 

[Sam Hobbs]

I see that you asked this question about 22 hours previous to this one.
Since that one did not get answers and this one did, I don't feel so bad
about my questions not getting answers.

I am sure you have a solution now, but I did post some other possiblities in
the other thread.