[AccessD] error 3061 too few parameters 2003

ok - thanks Susan. Must be a red herring. I'll look at the underlying queries

Kath
  ----- Original Message ----- 
  From: Susan Harkins 
  To: 'Access Developers discussion and problem solving' 
  Sent: Tuesday, December 05, 2006 10:23 AM
  Subject: Re: [AccessD] error 3061 too few parameters 2003


  Runs fine for me in 2003. 

  Susan H. 

  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


  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com