[AccessD] You Canceled the Previous Operation

Rocky,
It may just be that your recordset is not bookmarkable.
I suggest you test if me.bookmarkable then

The sort of code I use (aircode) is:

Dim rst as dao.recorset, sqlFind as string
If me.bookmarkable then
Strfind = "yourteststringhere", ie: strfind = "RecordID=" & lngID
set rst = me.recordsetclone
Rst.findfirst strfind
If not rst.nomatch then
Me.bookmark = rst.bookmark
Else
Msgbox "Not found"
Endif
Set rst = nothing


Regards
Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Wednesday, September 26, 2007 5:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [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

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