Rabu, 08 Agustus 2012

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

 

Thanks for the feedback, Luis! I'm glad it worked so easily for you :-)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Luis
Sent: Thursday, 9 August 2012 16:26
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: (SOLVED) [MS_AccessPros] Collecting data from scanner & storing
in table

It was straight forward, worked like a charm on the first try.

Thanks again Graham !!!

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Luis" <lrheimpel@...>
wrote:
>
>
>
> 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
<mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Luis
> > > Sent: Monday, 6 August 2012 15:39
> > > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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.
> >
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar