[AccessD] Tracking real edits

John W. Colby jwcolby at colbyconsulting.com
Sun Jan 9 20:13:36 CST 2005


I have wondered for a long time how to track real edits.  Issues:

User starts to edit a field, hits the escape key and undoes edit.  The
AfterUpdate of a given control tells me the user started an edit.  In Access
XP the Escape causes OnUndo to fire, I can determine that the undo happened.
Notice that A2K and previous do not even have OnUndo.

However, if the user edits a control and leaves that control, then the
AfterUpdate fires, I know the control was edited, but if they then hit
Escape, the control edit is undone, but OnUndo DOES NOT FIRE, thus I
incorrectly think that the control is still edited.

My client wants to create date stamp fields for groups of fields, i.e. a
NameDateStamp, AddressDateStamp, PhoneDateStamp etc.  Thus I need to know
that an edit happened and that the edit actually stored.  I've never really
figured out a satisfactory way to do this.  Does anyone have a method that
they use that appears to correctly handle all the nefarious things that a
user can do?

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/





More information about the AccessD mailing list