how do I set a timestamp but I don't want it to update?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to create a yes/no field for people to click on yes when they
check-in. I also want to create a field the shows the date and time they
checked in but I don't want the time to update. I want to be able to see
exactly what time they checked (even if I open the file up 3 days later I
don't want that time to update). Please help
 
well, not knowing anything about the tables design, or the form design that
the user is interacting with (hopefully you don't allow your users to open
tables directly), it's hard to give specific instructions. in general,
suggest the following: rather than adding a Yes/No field to the table, add
a Date/Time field. when people "check in", presumably by using a form, add a
"Check In" command button. add a macro or VBA code to the command button, to
set the value of the Date/Time field in the table to Now(). the Now()
function returns the current date and time, at the moment that the function
runs.

hth
 
I have done what you suggested but I don't want the timestamp to update
everytime I reopen the form. Can this be done
 
well, if the code is running from a command button, then the table will only
be updated when the button is clicked. if you want more specific help,
you'll need to explain specifically the table and form setup, what data
you're tracking, and how/where you're saving it.

hth
 
Back
Top