p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Runtime Error 2001


Message #1 by "Jonathan M. Tarr" <TarrJM@s...> on Mon, 4 Jun 2001 18:40:27
I have a frontend access form that allows users to select a search 

criteria and then display the results in another form.  I am using visual 

basic to filter the data.  I stated receiving Runtime Error 2001 "Previous 

Operation Cancelled" message between forms access.  I can click debug and 

press the play button and the results form is displayed with the correct 

filtered records.  If I leave the results form open and select a new 

search criteria I do not get the message. 



I would appreciate help in doing away with the this message.



Thank You, 



Jonathan M. Tarr
Message #2 by "Hippygoth" <hippygoth@k...> on Mon, 4 Jun 2001 20:06:03 -0500
Jonathan,



Although not very discriptive, Technet reads error 2001 as the following:



Error		Severity

2001 		   10



Description

 Cannot use duplicate parameter names. Parameter name '%.*ls' listed more

than once.



Had the code been running before without problems or is this brand spanking

new code?



Let me know and I'll see what I can dig out.



Even better send me a copy of the offending code, and I'll take a peek.

(hippygoth@k...) I'm not sure how the group would feel about posting

code, so email it direct to me.



Thanks,

Eddie.





-----Original Message-----

From: Jonathan M. Tarr [mailto:TarrJM@s...]

Sent: Monday, June 04, 2001 6:40 PM

To: Access

Subject: [access] Runtime Error 2001





I have a frontend access form that allows users to select a search

criteria and then display the results in another form.  I am using visual

basic to filter the data.  I stated receiving Runtime Error 2001 "Previous

Operation Cancelled" message between forms access.  I can click debug and

press the play button and the results form is displayed with the correct

filtered records.  If I leave the results form open and select a new

search criteria I do not get the message.



I would appreciate help in doing away with the this message.



Thank You,



Jonathan M. Tarr



Message #3 by "Jonathan M. Tarr" <TarrJM@s...> on Tue, 5 Jun 2001 16:39:47
The code was working fine, then started receiving message.  No change had 

been made.  I will e-mail you the code.  I implemented a temp fix, but 

would like to know what happened.



Thanks,



Jonathan M. Tarr



> Jonathan,

> 

> Although not very discriptive, Technet reads error 2001 as the following:

> 

> Error		Severity

> 2001 		   10

> 

> Description

>  Cannot use duplicate parameter names. Parameter name '%.*ls' listed more

> than once.

> 

> Had the code been running before without problems or is this brand 

spanking

> new code?

> 

> Let me know and I'll see what I can dig out.

> 

> Even better send me a copy of the offending code, and I'll take a peek.

> (hippygoth@k...) I'm not sure how the group would feel about posting

> code, so email it direct to me.

> 

> Thanks,

> Eddie.

> 

> 

> -----Original Message-----

> From: Jonathan M. Tarr [mailto:TarrJM@s...]

> Sent: Monday, June 04, 2001 6:40 PM

> To: Access

> Subject: [access] Runtime Error 2001

> 

> 

> I have a frontend access form that allows users to select a search

> criteria and then display the results in another form.  I am using visual

> basic to filter the data.  I stated receiving Runtime Error 

2001 "Previous

> Operation Cancelled" message between forms access.  I can click debug and

> press the play button and the results form is displayed with the correct

> filtered records.  If I leave the results form open and select a new

> search criteria I do not get the message.

> 

> I would appreciate help in doing away with the this message.

> 

> Thank You,

> 

> Jonathan M. Tarr

> 


  Return to Index