Kath Pelletti
kp at sdsonline.net
Mon Dec 4 17:06:13 CST 2006
Anyone know why this code would give me error 3061 - 'too few parameters' when I run it in Access 2003 (it runs fine in A2K). (I have created the references and there is a ref to DAO) Dim db As Database Dim strsql As String Dim rs As DAO.Recordset Set db = CurrentDb() On Error GoTo Err_Handler strsql = "SELECT * FROM QryHistory_PortfolioMVandIncome" Debug.Print strsql Set rs = db.OpenRecordset(strsql) 'error here ______________________________________ Kath Pelletti Software Design and Solutions Pty Ltd. Ph: 9505-6714 Fax: 9505-6430 Email: KP at SDSOnline.net