TIP: Click on subject to list as thread! ANSI
echo: win_access
to: CINDY CHEEK
from: MIKE HENDRIX
date: 1996-12-12 19:44:00
subject: Create/Edit

Cindy Cheek wrote in a message to All:
 CC> Hello All!
 CC> Can anyone help.........?
 CC> I need two dates to appear in each record of a certain form. 
 CC> The first date will appear once and stay unchanged forever;
 CC> the created date.
 CC> The 2nd date will be a changing date but will change only when that
 CC> record is edited; the edited date. (hopefully entered
 CC> automatically). 
 CC> Does anyone know if this is possible?
 CC> I've checked the "Helps" but am not real versed in this sort of
 CC> thing.  Any help would be appreciated.
For the first date set the default value of the field to Date.
For the edit date create a field called say "DateLastChanged" then in the 
BeforeUpdate function of the form enter this:
  [DateLastChanged] = Date
I believe that will work.
Regards,
           Mike...
Fidonet:  1:147/114
Internet: hendrixm@msn.com
--- FMail/Win32 1.22
---------------
* Origin: -==- OKCity Ok (1:147/114)

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™.