3061 too few paramters on db.execute - Huh?

[Tony Vrolyk]

Any reason a make table query that will run succesfully when double-clicked
will generate a 3061 too few parameters error?

The thing that gets me is that this has been working for ages and I just
made a very minor tweak in the query and suddenly it stopped working. I can
run it manually by double-clicking but when I run it from code I get that
error.

Here is what I am doing

Dim db As DAO.Database
Set db = CurrentDb()
db.Execute "qry_Participants_NWExportMakeTable"

Pretty smiple. The query does reference a form for its criteria. The form is
open and the field referenced has data (A date in this case). this is really
buggin me. any ideas?

Tony

 

[Alex Dybenko]

Hi,
db.Execute does not evaluate form references. so you have to either replace
reference to form's parameter with actual value (by modifying SQL for
example) or use docmd.openquery

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Tony Vrolyk]

So why has it worked all this time? That part of the query that I recently
changed is not the part that references the form. I just added an additional
field from the table. And isn't that negated since I am referencing a named
query rather than using a sql string variable?

I wlll follow your advice though. I can change this by moving it to a string
variable and in setting that variable reference the form field so that it is
entered as a value as you suggest.

BTW this is Access 2002.

Tony