fr**********@btconnect.com wrote in
news:11*********************@v3g2000hsg.googlegrou ps.com:
Hi i wonder if anyone can point me in the right direction.
I am trying to design a system using a barcode scanner to scan
membership cards, which pulls a specific record out of a table to
display as a form.So far this is ok what i want to do is record
the number of times this record has been accessed, and the last
date it was accessed on so i can keep track of attendance and card
usage.I am using a query with a filter to pull the specific record
from the table but as my novice status shows i cant work out how
to log this event in the specific table record.
Any pointers would be much appreciated.
Cheers
Mart
Basically what you want to do is get the existing attendance count
from the membership record, add 1 if it contains a number, or put 1
if it is null, and put the current date and time into the table.
Not knowing exactly what you are doing to retrieve the record, I'd
say the most probable way is to put the statements to update the two
textboxes with those values in the form's before update event, and
put a big "Save" button on the form
The before update event would simply contain the
update statements
me.txtAttendanceCount = nz(me.attendancecount,0) +1
me.dtLastAttendance = now()
and the button's code would be
me.dirty = false
But better than that, create a new table with 2 fields, the
membershipID number and the AttendanceDate.
Add a record for each attendance. This gives a list of who attended
what, which may prove more useful than just the count. You can also
get the number of events and the lastAttended date from this sub-
table by getting the count and max(attendanceDate) via Totals
query.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from
http://www.teranews.com 
