Results 1 to 2 of 2
  1. #1
    boywonder is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Dec 2010
    Location
    Memphis, TN
    Posts
    60

    Run-time error 3061


    I'm getting Run-time error 3061; Too few parameters. Expected 1.
    Here is the code I'm using:

    Set rsQry = db.OpenRecordset("SELECT CUST.[FULL NAME], CUST.STORE, " _
    & "CUST.PASSWORD FROM [CUST] WHERE " _
    & "(((CUST.PASSWORD) =" & strPassword & "));")

    Can not see what I'm doing wrong.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    it should be:

    Code:
    Set rsQry = db.OpenRecordset("SELECT CUST.[FULL NAME], CUST.STORE, " & _
    
    "CUST.PASSWORD FROM [CUST] WHERE " & _
    
    "CUST.PASSWORD = '" & strPassword & "'")

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

Similar Threads

  1. Run-Time error 3061
    By boywonder in forum Programming
    Replies: 12
    Last Post: 05-24-2011, 10:15 AM
  2. Replies: 1
    Last Post: 05-21-2011, 01:33 AM
  3. db.Execute Error 3061
    By JimG in forum Programming
    Replies: 5
    Last Post: 05-17-2010, 09:34 AM
  4. Error 3061 in VBA program
    By fbou in forum Programming
    Replies: 5
    Last Post: 10-07-2009, 11:00 AM
  5. Error 3061
    By Shanks in forum Queries
    Replies: 4
    Last Post: 09-16-2009, 07:13 AM

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