Hello Jim!
Tuesday December 10 1996 10:08, Jim Chevraux wrote to Cindy Cheek:
Sorry I haven't been in touch for such a long time, this project
got shelved and is now on the burner again.
 CC>> The first date will appear once and stay unchanged forever;
 CC>> the created date.
 JC>         Set the "Default Value" of the field in the table or form to
 JC> Date() and whenever you open a new record, it'll fill in the current
 JC> date automatically.  You can optionally set the Locked property for
 JC> that text box on the form to No, which will prevent anyone from being
 JC> able to edit that field (in which case, I'd also set Tab Stop for that
 JC> text box to No).
Ok, I understand that, but didn't you mean to say, set the Locked
property to Yes?
 CC>> The 2nd date will be a changing date but will change only when
 CC>> that record is edited; the edited date. (hopefully entered
 CC>> automatically).
 JC> I've never found a really good way to do this, so perhaps
 JC> someone else will mention something easier to do than this, but
 JC> here's one way to do it:
 JC> Anyways, what you could do is add a routine into the On Change
 JC>  property for each field that can be edited that simply replaces that
 JC> field with the current date.
Each field???  Geez, there's a mongo amount of fields (like 70) ... I don't 
suppose there's any easier way?
 JC> For example, if you had a [PaidOn] field and the field you wanted to
 JC> contain the last modified date was called [Modified] , the On Change
 JC> property for the [PaidOn] text box would look like this:
 JC>         Private Sub PaidOn_Change()
 JC>           Modified = Date
 JC>         End Sub
Cindy
--- Hertzian Mail+
---------------