Make Table query problem

[JMCS]

I am having a problem running a make-table query in VBA which I can run
directly from the database window without a problem.

The VBA is :

CurrentDb.Execute "qryTrackerMakeTable"

The error message is "Too few parameters - expecting 5"

Thanks
JMCS

 

[Paolo]

Hi JMCS,
in your query there are as parameters something from some forms?
Could you post the SQL of your make-table query

Cheers Paolo

 

[vanderghast]

You probably have 5 arguments of the form FORMS!FormName!ControlName.
CurrentDb.Execute does not solve automatically, for you, argument with the
syntax FORMS!FormName!ControlName. Use DoCmd.RunSQL instead, if this is the
case (and applicable in your case).


Vanderghast, Access MVP

 

[JMCS]

My thanks to both you and Paulo. You were both spot on; a little play around
with my query made the problem go away