Hello Matthew!
Saturday December 14 1996 10:05, Matthew Johnson wrote to Cindy Cheek:
CC>> The first date will appear once and stay unchanged forever; the
CC>> created date.
CC>> The 2nd date will be a changing date but will change only when
CC>> that record is edited; the edited date. (hopefully
CC>> entered automatically).
MJ> The second date is easy... Just have the field on the form, locked and
MJ> disabled (even invisible if you like). In the OnUpdate Event, put the
MJ> value of the date in the field.
When I did that nothing happened..... (hummmmmm....)
How (exactly) do you write the value of the date...is it date()?
MJ> The first date is similar, except you will have to check for an empty
MJ> field, and if it is empty put the date in. If it is not, then don't.
I got the "created" date by entering Date() in the default value.
Date
MJ> Did you get that? The specifics I don't know because I don't keep
MJ> this stuff in my head. But I do have this function of a DB I work on
MJ> at work.
I know what ya mean. There are a few people in this echo that are trying
to help too....hopefully I'll understand soon.
Thanks,
Cindy
--- Hertzian Mail+
---------------
* Origin: Hertzian Intercept-San Diego 619-578-9247 (6pm-1pm) (1:202/731)
|