[AccessD] You Canceled the Previous Operation

Hi Rocky

OK, that makes sense.

/gustav

>>> rockysmolin at bchacc.com 27-09-2007 16:09 >>>
The list box with the short list is not visible.  When the user clicks the
"Short List" command button, the list box becomes visible.  I had some code
in the lost focus event  of the list box to make it disappear in case the
user left the list box without making a selection.  But if they did make a
selection I got the error.  Removed the Lost Focus code and it works.  And
since the Current event is triggered by the Bookmark, I disappear the list
box in the current event.

It was only left to figure out how to disappear the list box if they didn't
make a selection.  So I made the "Short List" command button toggle the list
box on and off.  Best I could figure out.  If they hit the short list
command button then decide they don't want to make a selection they have to
hit the command button again to make it go away.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, September 27, 2007 12:44 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] You Canceled the Previous Operation

Hi Rocky

So what was the real problem?

/gustav

>>> rockysmolin at bchacc.com 27-09-2007 05:03 >>>
Yeah, found.  What I have found from searching the Internet is that the
error I'm getting generally has little to do with what the real problem is.

Rocky
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Wednesday, September 26, 2007 7:09 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] You Canceled the Previous Operation

Rocky: Maybe late for this discussion but have you checked to see whether a
match was indeed found? Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Wednesday, September 26, 2007 8:14 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] You Canceled the Previous Operation

Dear List:
 
Does anyone know why the code:
 
    Me.RecordsetClone.FindFirst "PersonID = " & Me.lstShortList.Column(0)
    Me.Bookmark = Me.RecordsetClone.Bookmark

generates an error 2001 - You Canceled the Previous Operation?
 
The value in Me.lstShortList.Column(0) is a valid PersonID.  It happens on
the second line.
 
MTIA
 
Rocky