Previous Thread

6/29/2006 8:18:02 PM    how do I set a timestamp but I don't want it to update?
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



6/30/2006 3:47:42 AM    Re: how do I set a timestamp but I don't want it to update?
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 
 
"Michele" <Michele@discussions.microsoft.com> wrote in message 
 
news:2F6E8723-297F-469D-A03D-E2C860CD47BD@microsoft.com...