Scan a barcode which adds the current record?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

netadmin - 28 Feb 2007 02:43 GMT

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,

Reply to this Message

Damian S - 28 Feb 2007 03:35 GMT

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.

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

Reply to this Message

netadmin - 28 Feb 2007 14:59 GMT

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,

> Hi netadmin,
>
[quoted text clipped - 13 lines]
> >
> > Thanks,

Reply to this Message

netadmin - 28 Feb 2007 23:22 GMT

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

> Hi netadmin,
>
[quoted text clipped - 13 lines]
> >
> > Thanks,

Reply to this Message