title: Too few parameters. (1) expected
body: <p>I'm using VBA to pass a parameter to a stored query, but keep getting the error. Here is the stored query:</p>
  
   
  
  <pre class="lang-sql prettyprint-override"><code>PARAMETERS Parm1 Long;
  UPDATE tJ010_SRP4Codes INNER JOIN tZ100_VendorProfiles 
  ON tJ010_SRP4Codes.SRP4Code = tZ100_VendorProfiles.JdeSRP4Code 
  SET tJ010_SRP4Codes.Vendor = 'TEST'
  WHERE ((([Parm1]=tZ100_VendorProfiles.VendorID)));
  </code></pre>
  
  <p>Here is the VBA that calls the query:</p>
  
   
  
  <pre class="lang-vb prettyprint-override"><code>Dim Parm1 As Long
  db.QueryDefs(!QueryName).Parameters(Parm1) = intVdrProfileID
  db.Execute !QueryName, dbFailOnError
  </code></pre>
  
  <p>I've tried with and without the "Parameters..." line in the stored query. Same error both ways.
  The stored query works fine on it's own, just not when called from VBA. </p>