Minggu, 05 Agustus 2012

RE: [MS_AccessPros] Collecting data from scanner & storing in table

 

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.

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar