Results 1 to 2 of 2
  1. #1
    patrick17 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    1

    Adding a timestamp to a record

    I know that this is probably so simple that I seem to be over complicating things.



    I am working on creating a database to track our students time and reason for being in my area. I have created my table, built a form for the student to scan their badge, it auto-fills in the first/last name, what part of the curriculum they are in, and the reason they are here. I then have them click the Badge In button, which adds that information to the table (I was impressed I got this far!)

    What I need now, is a way for them to scan their badge (preferably the same line they use to badge in) and hit a Badge Out button. This button will then find their number in the table, and timestamp that record in the Time OUT column, and be blank for the next student. Where I am getting stuck is that I am trying to use the Update Query method, but can't figure out how to make it change just that 1 record, and not the whole table.

    Any help would be greatly appreciated!

    Patrick

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I have a timestamp field on the table w default set = NOW()
    everything added automatically gets the datestamp.

    for 1 record
    update qery: update .....[datestamp]=now() where [badgeID]="xxxx"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-19-2018, 07:57 PM
  2. Replies: 11
    Last Post: 03-09-2015, 02:56 PM
  3. Replies: 14
    Last Post: 05-25-2012, 02:40 AM
  4. Replies: 2
    Last Post: 11-11-2008, 01:12 PM
  5. Replies: 0
    Last Post: 11-06-2008, 12:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums