[AccessD] OT Gustav

Gustav
 
Can you contact me of list.
 
 
martinreid at gmail.com
 
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Gustav Brock
Sent: Mon 26/02/2007 16:53
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] You canceled the previous operation (but I didn't)



Hi Rocky

Try with:

    If Me.RecordsetClone.NoMatch = True Then
        MsgboxUni Me.hWnd, TranslateMsgbox("PartNumberNotFound"), ,
vbExclamation
        Me.RecordsetClone.MoveFirst
    End If
    Me.Bookmark = Me.RecordsetClone.Bookmark
    'Me.cmdExitDemandSide.SetFocus
    'cboPartsList.Visible = False

Also, you should assign RecordsetClone to a Recordset and then manipulate that.

/gustav


>>> rockysmolin at bchacc.com 26-02-2007 17:39:07 >>>
Dear List:

Can anyone see why I should get an error "2001 - you cancelled the previous
operation" on the statement Me.Bookmark = Me.RecordsetClone.Bookmark in the
following?

    Me.RecordsetClone.FindFirst "[PartNumber] = '" & Me.cboPartsList.Value &
"'"
    MsgBox Me.RecordsetClone.NoMatch
    If Me.RecordsetClone.NoMatch = True Then
        MsgboxUni Me.hWnd, TranslateMsgbox("PartNumberNotFound"), ,
vbExclamation
        DoCmd.GoToRecord , , acFirst
    Else
        Me.Bookmark = Me.RecordsetClone.Bookmark
        'Me.cmdExitDemandSide.SetFocus
        'cboPartsList.Visible = False
    End If

Interestingly, if I hit debug to the error message (and it opens the code
page with that statement highlighted) and I pressF5, it carries on just
fine.

MTIA,

Rocky

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