[AccessD] 2001 Error - You cancelled the previous operation - THE FINAL WORD

Jim Dettman jimdettman at verizon.net
Mon Oct 3 16:31:24 CDT 2011


>From that other thread:

"I've exported my 80 forms and reports using SaveAsText (programmatically)
and then manually opened each text file and searched for "Empty"."

  EatBloat really missed the boat...would have been a real seller.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Monday, October 03, 2011 04:48 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] 2001 Error - You cancelled the previous operation -
THE FINAL WORD

> All in all: It was definitely a bug.....tested in AC2010 - orig
> release,
> using a SplitForm.
> I'll bet it's still in AC2007-SP2.

What a story!! Ported the FE and BE to AC2007. However, I had a use a HEX
EDITOR to make the 2010 BE compatible with AC2007. This is well documented:
http://www.utteraccess.com/forum/print.html&client=printer&f=54&t=1948489
BTW: I used Winhex - greatly recommended.

Strangely, on my first test in AC2007, I initially was getting a DIFFERENT
ERROR MESSAGE.
One related to disabling a control that had the focus.
My GUI is complex and so that is a typical overlooked situation.
I fixed that problem and of course the rest is history:
No more 2001 errors - that was bogus. No need for Requery.

Problem was totally and completely in AC2010 - an error condition occurred
that was not trapped by "ON ERROR..."
THAT'S IT. I cannot imagine what OTHER situations I am going to encounter in
2010. This could be scary.



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list