timestamp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone,
I have a time stamp on my form. I was wondering how to make the time stamp
register changes made in my subform as well as changes made in the main form
all in the same time stamp.

Hope that makes sense.
Thanks!
 
Forms do not store data except while it is open. You need to have a field in
your table to store the time stamp.

How are you going to use the time stamp? Do you want to records time any
change was made to the record or just the last time the change was made.

If you want to record for all changes then you will need a one-to many
related table to capture the change time stamps.
 
Yes, I have a field in my table for Last_Modified. The subform within the
form has its own time stamp. (This has its own field in a different table).
Basically the form has dates and project names. the subform contains
comments about the projects. everytime a comment is made the timestamp
records it in the table for the subform. Everytime a change is made to the
form, like if a project manager changes, the time stamp for the main form
saves it. What i wanted is for this stamp to show on the main form if someone
added a new comment recently so its seen right away.
Does this apply for what you said about the one-to many relationships? How
do i go about doing that?
Thanks so much for your help
 
What i wanted is for this stamp to show on the main form if someone added a
new comment recently so its seen right away.
Does this apply for what you said about the one-to many relationships? How
do i go about doing that?

Do you want to record for all changes or just when the last change occurred?

Post the structure your tables - field names and datatypes. Relationship
between the tables.
 
Back
Top