Thank you Graham!
It seems simple and straight forward. I am getting the scanner and a few number cards tomorrow so I can test it.
If something doesn't work as expected I'll post again!!
--- 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