[AccessD] error 3061 too few parameters 2003

Stuart McLachlan stuart at lexacorp.com.pg
Mon Dec 4 18:46:19 CST 2006


On 5 Dec 2006 at 10:06, Kath Pelletti wrote:

> Anyone know why this code would give me error 3061 - 'too few parameters' when I run it in Access 2003 (it runs fine in A2K).
...
> strsql = "SELECT * FROM QryHistory_PortfolioMVandIncome"

Does QryHistory_PortfolioMVandIncome contain any criteria that point to a control on a Form?
If so, you need to use a work-round such as a static function to pass that parameter to the query rather than a control 
reference. (Search the archives for "Static function")

But then, that shouldn't work in A2K either :-(











More information about the AccessD mailing list