[AccessD] Help with syntax please....OpenRecordset

Kath Pelletti KP at sdsonline.net
Tue Oct 12 20:46:10 CDT 2004


I am trying to use a saved query for my recordset source....but keep getting an error 'Too few parameters - expected 1' on the line 'Set rs = '
After many hours, I can't fix it so would appreciate the help.....


Code:

--------------------------------------------------------------------------------

Public Function EmailWebLetterRecipients()
Dim strerrormsg, strsql, StrQueryName As String
Dim VarEmailto As Variant
Dim intrecno, IntWebLetterID As Integer
Dim db As Database
Dim rs As DAO.Recordset
Set db = CurrentDb


StrQueryName = "QryWebLetter_ReadRecipientsEmail"
  
Set rs = db.OpenRecordset(StrQueryName, dbOpenDynaset)     ' Open recordset on saved query        ERROR HERE

With rs
    .MoveFirst
    .Edit

     VarEmailto = .Fields("LoginEmail")
    .Update
    .close
End With
'MsgBox ("Going to " & VarEmailto)

'Call Send_Email(VarEmailto, StrNamePDFFile)

Normal_exit:
    DoCmd.SetWarnings True
    Exit Function

Err_Handler:
    MsgBox "Error: [" & Err.Number & "]  " & IIf(Len(strerrormsg) > 0, strerrormsg, Err.Description), vbCritical, "Error Message"
    Resume Normal_exit
End Function


--------------------------------------------------------------------------------

Kath Pelletti
Software Design & Solutions Pty Ltd.
Ph: 9505-6714
Fax: 9505-6430
KP at SDSOnline.net


More information about the AccessD mailing list