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