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

It came to pass on 12/05/96 that CINDY CHEEK wrote concerning Edit/Create...
 
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; the
CC> 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?
The second date is easy... Just have the field on the form, locked and 
disabled (even invisible if you like). In the OnUpdate Event, put the 
value of the date in the field.
The first date is similar, except you will have to check for an empty 
field, and if it is empty put the date in.  If it is not, then don't.
Did you get that? The specifics I don't know because I don't keep this 
stuff in my head. But I do have this function of a DB I work on at 
work.
Cya Matt               __  _     ____            ____
                 ---+=| =\|=| ==| ===) =========| ===' =============+---
matthewj@gil.com.au   |_|\__|ew |_|\_\esolution |____,ommunications
 * RM 1.31 3332 * Am I ignorant or apathetic?  I don't know and don't care!
--- 
(3:640/404)
---------------
* Origin: Past the Black Stump BBS 07-54-656667 Laidley.. Q'land.

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