ado error -2147217904

Y

YisMan

hi
i have such a sub procedure which gives me error -2147217904 "one or more
required parameters are missing"

Sub SendReport3(inCustomerCode As Integer, stEMailAddr As String)
Dim rsTasks As New ADODB.Recordset

'NEXT LINE PRODUCES ERROR -2147217904

rsTasks.Open "select * from uqActSummary", CurrentProject.Connection
If Not rsTasks.EOF Then rsTasks.MoveLast
Do Until rsTasks.BOF
'some code........
rsTasks.MovePrevious
Loop
rsTasks.Close
End Sub

the sql string couldnt be much simpler but thats the error i get. please help.
PS ive recently installed winfx 2.0, it might have started then, though
other recordsets open no problem in the same project.
PPS the uqActSummary is a select query based upon a union query if it makes
any difference
id really appreciate any help
 
Top