How can I display the current date automatically after I update each record to show the revision date? Also, how can display the date when I first entered someone into the database automatically (but I don't want the date to change each time I access or update someone's record)??? I have two date fields that I wish to customize.
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
- Thread starter avaffa
- Start date
LarryDeLaruelle
Technical User
Avaffa:
Sounds like you are almost there.
Do you have a command button to Add a record?
If so, simply do an assignment:
DateCreated = Date() in the add's On_Click event.
(Where DateCreated is the name of the storage field where you want the date to be.)
Does that answer your question?
Larry De Laruelle
larry1de@yahoo.com
Sounds like you are almost there.
Do you have a command button to Add a record?
If so, simply do an assignment:
DateCreated = Date() in the add's On_Click event.
(Where DateCreated is the name of the storage field where you want the date to be.)
Does that answer your question?
Larry De Laruelle
larry1de@yahoo.com
- Status
Similar threads
