Scan a barcode which adds the current record?

[netadmin]

Does anyone know if it's possible to have a barcode on a form that when
scanned, adds the current record? This would allow the user not to have to
used the mouse.

Thanks,

 

[Damian S]

Hi netadmin,

It sure is possible... I have written such systems myself. All you need is
a textbox on your form that the cursor sits in. When you scan a barcode,
it's the equivalent of typing the characters into the text box. Use an after
update event to process the barcode scanned (in your case, run SQL to insert
a record), then clear the text box and put the focus back onto it.

Hope this helps.

Damian.

 

[netadmin]

Hi Damian,

I guess I should have explained it a little different, Currently, I've got
that working. Scanning of a part number into the current record. The area
where the text gets scanned into, but I don't have it doing a return to add
the current value, the reason being is that I don't want an enter being done
until the job is completed. If the job is not complete and they may have to
start a different job, then they click a button that stores only the start
time, but nothing else. The other barcode that I want is a "picture" on the
form emulates an enter/add current record and completes the job

Thank You,

 

[netadmin]

Hi Damian,

I'm thinking that setting the pictures "on click" should do the same as I
what have the button programmed to enter the record does.
I am using a keyboard wedge scanner that will do enter for the record, but
like I mentioned in the previous message on savong the start time of the part
and the end time seperately.
Thanks for the help!
Kelly