Hi Guys, i have a call logging database for which i would like to have a date & time stamp included on a form called "History". The form has 4 fields: Comment, Hrs, mins, Date. The "Date" field will be the one to contain the Date/time stamp. I have tried using =Now() but that's not going to help as it would change the time on past entries to today's date and time whenever that record is opened. I want a time stamp that saves the date and time an entry was made for ever.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TIME STAMP RECORDS IN ACCESS 1
- Thread starter barry2004
- Start date
-
1
- #2
In the field in the table set the default value to Now() or if you have two fields set them to Date() and to Time(). The time will be stamped when the record is first created.
You can either not show the field on the form or just show it using a 'locked' text field so that the user can see it but not change it.
Use the format property to show the data the way you want to have it displayed.
This will not affect existing records - the default value in the table field only applies to new record creation.
You can either not show the field on the form or just show it using a 'locked' text field so that the user can see it but not change it.
Use the format property to show the data the way you want to have it displayed.
This will not affect existing records - the default value in the table field only applies to new record creation.
- Status
Similar threads
