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/