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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Stamp, when a record is updated
- Thread starter jeff1
- Start date
LonnieJohnson
Programmer
There are a few ways. Here is one.
1. Create a Date/Time field on the record.
2. Now on the form that is used to update the record (I am assuming these updates come from a form) create an invisible textbox with the new Date/Time field as the ControlSource.
3. Set the format of this textbox to General Date if you wish to include the time also.
4. In the Form's BeforeUpdate event put
TextBoxName = Now()
B-)
Good luck ljprodev@yahoo.com
ProDev, MS Access Applications
1. Create a Date/Time field on the record.
2. Now on the form that is used to update the record (I am assuming these updates come from a form) create an invisible textbox with the new Date/Time field as the ControlSource.
3. Set the format of this textbox to General Date if you wish to include the time also.
4. In the Form's BeforeUpdate event put
TextBoxName = Now()
B-)
Good luck ljprodev@yahoo.com
ProDev, MS Access Applications
- Thread starter
- #3
LonnieJohnson
Programmer
Again this is the most novice approach...
1. Create a Date/Time field in the table.
2. Now in the query is used to update the record add this Date/Time field and in on it's Update To line put Now()
B-)
Will that work?
ljprodev@yahoo.com
ProDev, MS Access Applications
1. Create a Date/Time field in the table.
2. Now in the query is used to update the record add this Date/Time field and in on it's Update To line put Now()
B-)
Will that work?
ljprodev@yahoo.com
ProDev, MS Access Applications
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
