Adding New Record with Time Stamp

  • Thread starter Thread starter James Fillmore via AccessMonster.com
  • Start date Start date
J

James Fillmore via AccessMonster.com

I'm creating a database for a community center. We want to keep a record
of the date and time when a member visits. So far, I have a table, Member,
that lists members name, and it is linked by MemberID to a table, TimeStamp
(with fields: MemberID, TimeStampID, Time Stamp). I want to make a form
that allows the member to select their name from a list box and click ok
(upon doing so, I hope to make a new record in TimeStamp with that members
MemberID and record the date and time in the Time Stamp field).
 
Run the SQL append query in the after update event of the list box (though
that will write duplicate records if the user selects hte wrong list entry
first). You'd be better off grabbing network username ...

http://www.mvps.org/access/api/api0008.htm

...and using that instead of relying on the user making the right choice.
Would also mean that you could use a more sensible event then the after
update of a combo.
 
Back
Top