Jim Dettman
jimdettman at verizon.net
Mon Oct 3 08:04:43 CDT 2011
<<I always use unbound controls, and validate field by field, and then use SQL and refresh the form...>> Why are you bothering to use Access then? If your going to go through all that work, you might as well use something else that gives you more features and capabilities. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson (VBACreations.Com) Sent: Monday, October 03, 2011 12:31 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] 2001 Error - You cancelled the previous operation I never let Access Add New, I always use unbound controls, and validate field by field, and then use SQL and refresh the form... and I don't have these problems ;-) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms Sent: Monday, October 03, 2011 12:23 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] 2001 Error - You cancelled the previous operation After hours and hours of testing this, I came to the conclusion that unless I trap the vbKeyEscape in the KeyDown event handler, I am unable to add a new record to a form after an undo has occurred. I get this dreaded 2001 error which appears to be a misleading one. It appears that an UnDo condition throws the form into a tizzy-state. Any method of attempting to add a new record after an undo has occurred either with a RunCommand GotoRecord acNewrec directive or trying to do an AddNew and Bookmark ... all fail. When I kill the escape key, all is well..but of course, my users are mad.they cannot undo the record. Unless I'm missing something , this is definitely a bug, no ? -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com