TIP: Click on subject to list as thread! ANSI
echo: win_access
to: PETER ORTNER
from: CINDY CHEEK
date: 1997-01-05 11:41:00
subject: Create/Edit

Hello Peter!
Monday December 23 1996 01:26, Peter Ortner wrote to Cindy Cheek:
 PO> This is only a guess, but there should be an event which is triggered
 PO> when a record editing is started (or finished). The idea is to write a
 PO> function to set the value of a field so that the date is updated.
 PO> If this is not enough then write back. Good luck!
I GOT IT! HALLELUJAH!  Thanks for your input!
Cindy
--- Hertzian Mail+
Hello Mike!
Monday December 30 1996 06:30, Mike Hendrix wrote to Cindy Cheek:
 CC>> and nothing happened... any idea what I'm doing wrong?
 MH> Did you put this in the function Before_Update for the form?
Geeeezzzzz...I get it now.  Thanks for the clarification!
 CC>> Why would I put this in the BeforeUpdate instead of AfterUpdate
 CC>> or OnChange?
 MH> Putting it in the before_update changes the value to date just prior
 MH> to the recorded being saved so the new value is saved in the table.
 MH> If you put it in the after_update it changes the value in the field on
 MH> the form after the record is saved therefore it wasn't committed to
 MH> the database just the form and at this point the form is either
 MH> closing or moving to the next record.
 MH> With the before update you won't see the new date on the form when you
 MH> edit that record but the next time you edit that record it should show
 MH> the last time it was edited.
Ohhhhhh, I see said the blind man to the deaf dog.   I get it!
Thanks a bunch for your instructions and most of all, patience!  IT WORKS!
Cindy
--- Hertzian Mail+
---------------
* Origin: Hertzian Intercept-San Diego 619-578-9247 (6pm-1pm) (1:202/731)
* 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™.