Darryl Collins
Darryl.Collins at coles.com.au
Mon May 4 23:56:36 CDT 2009
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.