News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • To few parameters

    Posted on WSLstclair55 Comment on the AskWoody Lounge

    This topic contains 1 reply, has 2 voices, and was last updated by  sourwood 3 weeks, 5 days ago.

    • Author
      Posts
    • #1876830 Reply

      WSLstclair55
      AskWoody Lounger

      Good morning,

      I am having problems with a piece of vba

      Set rs = CurrentDb.OpenRecordset(“SELECT * FROM qryPropertyMatching”, dbOpenDynaset, dbSeeChanges)

      The error that is coming back is Too few parameters, expected 3

       

      any ideas?

    • #2100170 Reply

      sourwood
      AskWoody Plus

      Have you tried running it with just the query name? Meaning, delete the select statement from before the query name.  If that doesn’t solve it, my next stop would be the query itself.

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: To few parameters

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.