TIP: Click on subject to list as thread! ANSI
echo: win_access
to: MATTHEW JOHNSON
from: CINDY CHEEK
date: 1996-12-29 15:54:00
subject: EDIT/CREATE

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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.