473,434 Members | 1,620 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,434 software developers and data experts.

2001 error, 'You canceled the previous operation

I am very confused for this error. I was just try to put a dynamic filter on a query. The error comes after I did this:


Expand|Select|Wrap|Line Numbers
  1. 33    me.filter = " [par_year] = '2005' "
  2. 34    me.filterOn =  (me.filter > "")
Error on line 34. Any hints on this bug. (I tried another program sample and that works fine).. Dont' know if I have some setting wrong. Thanks

chiu1010
Aug 23 '07 #1
4 2134
missinglinq
3,532 Expert 2GB
You have inadvertently posted your question in the Articles section rather than in the Forum section of our site, so I have moved it across to the Forum for you.

Welcome to TheScripts!

Linq ;0)>
Aug 23 '07 #2
JKing
1,206 Expert 1GB
The filterOn Property excepts the values true and false I believe.

Try Me.filterOn = True
Aug 23 '07 #3
NeoPa
32,556 Expert Mod 16PB
The filterOn Property excepts the values true and false I believe.

Try Me.filterOn = True
That's not a problem JK. It accepts a Boolean value. True & False are both boolean values but it will accept any expression which resolves to a boolean (which the OP's code should do happily).
Aug 24 '07 #4
NeoPa
32,556 Expert Mod 16PB
I am very confused for this error. I was just try to put a dynamic filter on a query. The error comes after I did this:


Expand|Select|Wrap|Line Numbers
  1. 33    me.filter = " [par_year] = '2005' "
  2. 34    me.filterOn =  (me.filter > "")
Error on line 34. Any hints on this bug. (I tried another program sample and that works fine).. Dont' know if I have some setting wrong. Thanks

chiu1010
I'm afraid that, as it is clear that this portion of code has not been Copy/Pasted in, it is not something we can rely on. I appreciate that your intention was probably to keep it brief, but you must nevertheless copy/paste it in, otherwise it's almost useless to work from I'm afraid.
Certainly I can see nothing wrong with the code as posted, although I doubt the actual code will be the cause as such.
Aug 24 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: RWC | last post by:
Hi, I'm running into a problem with Access XP (SP2) that's driving me up the wall. It's Error 2001 "You canceled the previous operation". There is no voodoo going on really when I get this...
2
by: Ronny Sigo | last post by:
Hello all, When copying a routine while only altering some field names, at runtime I get the error message "You canceled the previous operation". When I click on help, I get a blank screen......
2
by: Ronny Sigo | last post by:
Hello all, I already put the same question, only now I have more to tell ... Although I used this code before in the same routine (only the fieldname of the table differs) ___ at this point in the...
1
by: John A. | last post by:
This is a database in use on Terminal server, been reliable, no corruption problems. (so far) Designing a form, asked to save objects, Access put up a dialog box for the current form asking me...
2
by: Richard Hollenbeck | last post by:
I got this: "Error 2001 You cancelled the previous operation" with this: Private Sub courseCode_GotFocus() Dim myDLookupResults As String myDLookupResults = DLookup("courseID", "courses",...
2
by: John A. | last post by:
I've received this error several times, and have only been able to get around it by deleting the offending form(s) and importing them from backup - Here's the sequence: 1. I'm editing a form or...
20
by: Crayola465 | last post by:
I have been trying to figure this out for a couple weeks and after reading every post in the forum about the subject I have not found anything that works. I have two tables; 1) has company...
1
by: paulw4 | last post by:
I have the code below to run a query, that is created from a "fill in the blanks" form. I am now getting the error "You cancelled the previous operation" Earlier when I got this I closed the...
1
by: Heather M | last post by:
I am receiving a Run-time 2001 You canceled the previous operation. I have a form which has unbound boxes where you select the date and set a role. The query runs for one role for every month. ...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.