Run-time error 3061 Too few parameters Expected 1 Access 2007

Question

I have the following  set recordset  line that I cannot get working  The parameters seem correct according to all available help I can find on the subject   The error displays        Run-time error  3061   Too few parameters  Expected 1     Here is the line of code   Set rs   dbs OpenRecordset  SELECT Centre X  Centre Y FROM  qry all details   WHERE ID      amp  siteID  amp       dbOpenSnapshot   Where rs is the recordset  Dim rs As Recordset  and dbs   CurrentDb     Any help would be appreciated   I have tried removing the WHERE cause with no effect  and also using single quotes between double quotes  but no joy   Many thanks

User · Answer

I got the same error message before  in my case  it was caused by type casting   check if siteID is a string  if it is you must add simple quotes   hope it will help you

User · Answer

I got the same error with something like   Set rs   dbs OpenRecordset          SELECT Field1  Field2  FieldN        amp   FROM Query1        amp   WHERE Query2 Field1        amp  Value1  amp            dbOpenSnapshot       I fixed the error by replacing  Query1  with  Query2

User · Answer

For those who read all answers   My case was simply the fact that I created a SQL expression using the format Forms Table Control  That format is Ok within a query  but DAO doesn t recognize it  I m surprised that nobody commented this   This doesn t work   Dim rs As DAO Recordset  strSQL As String strSQL    SELECT   FROM Table1 WHERE Name   Forms Table Control   Set rs   CurrentDb OpenRecordset strSQL    This is Ok   Dim rs As DAO Recordset  strSQL  val As String val   Forms Table Control strSQL    SELECT   FROM Table1 WHERE Name       amp  val  amp       Set rs   CurrentDb OpenRecordset strSQL

User · Answer

In My case I had an INSERT INTO TableA           SELECT         from TableB  a run-time error of 33061 was a field error  As  david mentioned   Either it was a field error  what I wrote in SQL statement as a column name did not match the column names in the actual access tables  for TableA or TableB   I also have an error like  DATS but it was a run-time error 3464

User · Answer

My problem was also solved by the Single Quotes around the variable name

User · Answer

This Message is also possible to pop up  if there is a typo in the fields on which you define a join

User · Answer

you have   WHERE ID      amp  siteID  amp       dbOpenSnapshot    you need   WHERE ID        amp  siteID  amp        dbOpenSnapshot    Note the extra quotations           this kills me everytime  Edit  added missing double quote

User · Answer

Run-time error  3061   Too few parameters  Expected 1    I believe this happens when the field name s  in your sql query do not match the table field name s   i e  a field name in the query is wrong or perhaps the table is missing the field altogether

User · Answer

In my case  I had simply changed the way I created a table and inadvertently changed the field name I tried to query   Make sure the field names you reference in the query actually exist in the table query you are querying

User · Answer

Does the query has more than the parameter siteID  becouse if you want to run the query one parameter still isn t filled witch gives you the error

User · Answer

Thanks for John Doe s solution that helped a lot  Mine is very similar with some difference  using TempVars  Instead of          strSQL    SELECT   FROM Table1 WHERE Name   Forms Table Control     I used         strSQL    SELECT   FROM Query1     Query1 being common for other usage   Query1 as     Select Field1  Field2 from Table1 where Id   TempVars   MyVar    And similarly    removing  TempVars   MyVar  from view solved the problem

User · Answer

Make sure  qry all details  exists and is runnable  I suspect it or any query it uses  is missing the parameter

User · Answer

My problem turned out to be  I had altered a table to add a column called Char  As this is a reserved word in MS Access it needed square brakcets  Single or double quote are no good  in order for the alter statement to work before I could then update the newly created column

User · Answer

In my case  I got this error when I tried to use in a query a new column  which I added to MySQL table  linked to MS Access   but didn t refresh it inside MS Access   To refresh a linked remote table    Open  Linked Table Manager    External Data  tab on ribbon   Select a checkbox near the table you want to refresh  Press  OK  button

[ms-access] Run-time error '3061'. Too few parameters. Expected 1. (Access 2007)

Examples related to ms-access

Examples related to vba