[AccessD] Setting Filter Error

Rats.  Well, at least I know I'm not alone.  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Monday, May 04, 2009 9:57 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Setting Filter Error


I don't have an answer, but I have had this error before and this sort of
thing seems to be faily common in Access 2007. I wish I could recall what I
did to fix it?

I have had to mod a fair bit of VBA code to get things to work as expected
again. :-/

I also note that they still haven't fixed up the spelling error on this
form.  would be nice if 'cancelled' was spelt correctly.

oh well...

regards
darryl.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin
Sent: Tuesday, 5 May 2009 2:47 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Setting Filter Error


Dear List:

We've been over this before I think but I can't find it in the archives.

An mdb in 2003 runs the code:

Me.FilterOn = False

Me.Filter = ""

just fine. But when I run that mdb in A2007 the line Me.FilterOn = False
throws an error: Error 2001: You canceled the previous operation.

Oddly, very oddly indeed, if I click Debug, and the F8 key, I can step
through that line of code with no problem.

Does anyone have a clue here what could be causing this?

BTW, I also get this same error in this form with:

Me.OrderByOn = False

Me.OrderBy = ""



MTIA

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/>

www.bchacc.com <http://www.bchacc.com/>






This email and any attachments may contain privileged and confidential
information and are intended for the named addressee only. If you have
received this e-mail in error, please notify the sender and delete this
e-mail immediately. Any confidentiality, privilege or copyright is not
waived or lost because this e-mail has been sent to you in error. It is your
responsibility to check this e-mail and any attachments for viruses.  No
warranty is made that this material is free from computer virus or any other
defect or error.  Any loss/damage incurred by using this material is not the
sender's responsibility.  The sender's entire liability will be limited to
resupplying the material.


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