- Joined
- Apr 9, 2007
- Messages
- 4
- Reaction score
- 0
I am looking to add START DATE, COMPLETION DATE, START TIME, & FINISH TIME
buttons to an existing form, so that when you press the START DATE button it
would insert the current date into the field; when you press the START TIME -
the current time is inserted and so on. Is this possible? I have tried the following event procedure, but it didn't work :
To insert the time:
Me.[START TIME] = Time
If you wanted to insert both the date and time into one text box named
StartDateTime:
Me.[StartDateTime] = Now()
Is this the only way or is there a better way? I've been looking on all Access forums, but to no avail.
buttons to an existing form, so that when you press the START DATE button it
would insert the current date into the field; when you press the START TIME -
the current time is inserted and so on. Is this possible? I have tried the following event procedure, but it didn't work :
To insert the time:
Me.[START TIME] = Time
If you wanted to insert both the date and time into one text box named
StartDateTime:
Me.[StartDateTime] = Now()
Is this the only way or is there a better way? I've been looking on all Access forums, but to no avail.