Hi Luis,
The Barcode Scanner is just an input devicce like a
keyboard so you should be able to scan directly into
a textbox on a form.
The barcode Scanner is classed as a Human Intercace Device.
If you want to print the barcodes you will need to
use Font codes 39 or 128 to convert the characters
to barcodes.
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@...> wrote:
>
> Hello Luis
>
> It sounds like the effect of the scan is exactly the same as typing in the
> number and pressing <Enter> - for example:
> 1 0 0 0 <enter>
>
> If the focus is on a textbox on a form at the time of the scan, then the
> number will be "typed" into the textbox and the AfterUpdate event will fire.
> You can use the AfterUpdate event to write the current date/time to the
> timestamp field, navigate to a new record (which will save the current
> record), and set focus to the textbox ready for the next scan. Something
> like this:
>
> Private Sub TagNumber_AfterUpdate()
> If IsNull( Me.ScanTime ) Then Me.ScanTime = Now()
> DoCmd.GoToRecord Record:=acNewRec
> Me.TagNumber.SetFocus
> End Sub
>
> Make your form in continuous view with two textboxes - one for the scanned
> number and one for the timestamp. If you like, you could base it on a query
> with a join to the table containing the names of the riders, so that the
> name appears when the tag is scanned. For all the boung textboxes on the
> form except the tag number, set Enabled to "No" and Locked to "Yes".
>
> Good luck :-)
> Graham Mandeno
> [Access MVP 1996-2012]
>
> > From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Luis
> > Sent: Monday, 6 August 2012 15:39
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Collecting data from scanner & storing in table
> >
> >
> > Hi, I am looking for advise to store data from a scanner in an access
> table.
> >
> > The scanner is connected to a USB port. If the active window is the
> windows notepad, what you scan with the scanner appears on screen with a
> return (cursor moves to next line). Multiple scans provide a list of scanned
> data.
> >
> > We have a bicicle race where each competitor gets a card to put in his/her
> byke with plastic ties. The card contains a number (ie 1000) and a small
> barcode with same number (ie 1000). The intent is to scan the card on
> arrival to finish line and store the scanned number along with a time stamp
> (date/time) to a table containing those 2 columns (number, timestamp).
> >
> > The same database would contain another table with the participants info
> (name, address, town, category, etc) including the card number assigned. We
> can join both tables on the number column to get queries of when a
> participant arrived, which place, by category, how long it took to finish,
> etc.
> >
> > Any suggestions on the best way to grab & store the scanned data?
> >
> > Thanks for the assistance.
>
Tidak ada komentar:
Posting Komentar