Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    SF, CA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error Message (97-SR1)

    anyone know what this error message means?

    Too few parameters. Expected 1.

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Message (97-SR1)

    This message means that you are neglecting to give Access a value that it needs for execution... I have copied the help information from Access 97 so that you can read it for yourself...

    "Too few parameters. Expected <number>. (Error 3061)

    This parameter query requires the specified number of parameters, which you didn't supply. Provide the expected number of parameters, and run the query again.
    In some cases, this message is generated when unknown field names or expressions are interpreted as query parameters. Be sure to enclose field names containing spaces or punctuation with square brackets [ ]. "

    Check the fields and expressions in your query design and see if there is a field name you mistyped (or that doesn't exist anymore), etc....

    Hope this helps... but if not... try posting the SQL view and maybe that would be easier to help you with...
    Happy Friday! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Message (97-SR1)

    Oops... Almost forgot... The "Expected 1" part of the message means just that... There is 1 field it is looking for a value for...

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error Message (97-SR1)

    It depends on where you get it. You'll get that message if you try to run a parameter query from code without using the .Execute method of the querydef object and creating and passing a parameter value. You'll also get it if your parameter query has the parameters in the criteria but not actually in the query parameters themselves. Then when you try to run the query from code, it doesn't pop up the parameter message boxes, it simply gives you an error. The same query will probably run just fine from the user interface.
    Charlotte

Posting Permissions

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