Results 1 to 2 of 2
  1. #1
    seth1685 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    10

    Too few parameters. expected 1.

    Hello!



    I am having trouble with this:

    x = numEEID
    strARG = "select * from tblJUNCTION where ID = x"
    Set Rs = db.OpenRecordset(strARG)

    bit of code producing the "Too few parameters. expected 1." error

    it works if instead of x, there is for example a 1 or 2 instead of the x

    x and numEEID are int

    if there is any additional info you need, just ask!

  2. #2
    seth1685 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    10
    never mind, its me being a fool

    strARG = "select * from tblJUNCTION where ID =" & x

    thatws what i needed to do

Please reply to this thread with any new information or opinions.

Similar Threads

  1. 3061 Error. Too few parameters. Expected 1.
    By rghollenbeck in forum Queries
    Replies: 5
    Last Post: 09-28-2011, 12:12 PM
  2. Replies: 1
    Last Post: 05-21-2011, 01:33 AM
  3. Too few parameters expected 4
    By forestgump in forum Programming
    Replies: 1
    Last Post: 04-15-2011, 09:10 AM
  4. Run-time '3051' - Too few parameters. Expected 1
    By jgelpi16 in forum Programming
    Replies: 3
    Last Post: 04-11-2011, 07:17 AM
  5. Too few parameters. Expected 2.
    By PPCMIS2009 in forum Access
    Replies: 0
    Last Post: 01-28-2009, 01:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums