Error Message (97-SR1)

Topic

New Reply

anyone know what this error message means?

Too few parameters. Expected 1.

Reply | Quote

Replies

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 . (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!

Reply | Quote

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

Reply | Quote

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.

Reply | Quote