Make Table query problem

  • Thread starter Thread starter JMCS
  • Start date Start date
J

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
 
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
 
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
 
My thanks to both you and Paulo. You were both spot on; a little play around
with my query made the problem go away
 
Back
Top