Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169

    Unanswered: SQL too few parameters

    I have inserted this code into my VBA background module and I am getting an error when i run it

    Too few parameters, expected one.

    I know this is down to setting parameters and have experienced this problem before but i have forgotten how i fixed it??

    I thought with numbers that you didnt have to set parameters

    Code:
    SQL = "Select [POLTable].*"
        SQL = SQL + " From [POLTable]"
        SQL = SQL + " Where ((([POLTable].POLHID) = (forms!POHeader!POHID)))"
    Any Ideas?

  2. #2
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169
    Its ok sorry, i have sorted it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •