Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu Sep 27 23:48:57 CDT 2007
That makes sense??!! I don't know what the hell I'm talkin' about! :)
Access. Ya gotta love it.
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 7:21 AM
To: accessd at databaseadvisors.com
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date: 9/27/2007
11:06 AM