[AccessD] You Canceled the Previous Operation

Try checking for NoMatch on a DAO recordset or Not .EOF and Not .BOF on
an ADO recordset.  Even though the value is there, it might provide
enough of a pause to keep Access from falling over its feet.

Charlotte Foust 

-----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 9:07 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] You Canceled the Previous Operation

Gustav:

I added DIM rst as Recordset because rst was undefined and changed  rst
= Me.RecordsetClone to Set rst = Me.RecordsetClone.

Hope that's right.

Anyway, I still get the error on the Me.Bookmark = rst.Bookmark.

Again, if I use a breakpoint and step through the code, it works.

Thanks and regards,

Rocky





 	
	

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

Hi Rocky

Try to hold the Recordset:

    rst = Me.RecordsetClone
    rst.FindFirst "PersonID = " & Me.lstShortList.Column(0) 
    If rst.NoMatch = False Then
      Me.Bookmark = rst.Bookmark
    End If
    rst.Close
    
/gustav


>>> rockysmolin at bchacc.com 26-09-2007 17:13 >>>
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.30/1030 - Release Date:
9/25/2007
8:02 AM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com