Problems with error 2001 still...
From: Mitch (anonymous_at_discussions.microsoft.com)
Date: 09/15/04
- Next message: J Worsley: "RE: How can I print more than one copy of a report by clicking a comm."
- Previous message: TT: "Snapshot viewer not working"
- Next in thread: Mitch: "Problems with error 2001 still..."
- Reply: Mitch: "Problems with error 2001 still..."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Sep 2004 10:14:57 -0700
..Hi again.
I posted the other week about the error message "Run-time
error 2001 - you cancelled the previous operation" and
someone suggested I check the spelling in the code, qry
and form realted to the problem. I have checked and run
over the problem again but I cannot find any typos that
would throw this error up. Here is the code behind the
form that I am using...
Private Sub cboIssue_AfterUpdate()
Dim strRez As Variant
'strRez = DLookup("[resolution]", "qryRez", "[Issue]=" &
Forms!frmsprt!cboIssue)
strRez = DLookup("[resolution]", "qryRez", "[Issue]='" &
Forms!frmsprt!cboIssue & "'")
If IsNull(strRez) Then
Me.txtDetail.Visible = True
Me.sfmResolution.Visible = False
Else
Me.txtDetail.Visible = False
Me.sfmResolution.Visible = True
End If
Me.sfmResolution.Requery
End Sub
And the qry is as follows...
SELECT tblIssue.Issue, tblIssue.Resolution
FROM tblIssue
WHERE (((tblIssue.Issue)=[form]![frmsprt]![cboIssue]) AND
((tblIssue.Resolution) Is Not Null));
This should be a very simple function but it is proving
hard to correct !!
Any advice greatly apreciated,
Mitch...
- Next message: J Worsley: "RE: How can I print more than one copy of a report by clicking a comm."
- Previous message: TT: "Snapshot viewer not working"
- Next in thread: Mitch: "Problems with error 2001 still..."
- Reply: Mitch: "Problems with error 2001 still..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
