title: Access 2007 VBA DoCmd.SetParameter replacement?
body: <p>I've inherited an Access Database that has a lot of tables, forms, and queries in it. However, I'm a PHP programmer and VBA is pretty foreign to me. I was asked to make some changes, which over the course of a few days I was able to get working (with a lot of help from old random SO posts). </p>
  
  <p>After passing the database back to the users, the code that works on my computer is not working on theirs. It seems I have Access 2010 and they have 2007. As best I can tell, the function DoCmd.SetParameter doesn't exist in VBA in Access 2007.</p>
  
  <p>Here's a snippet of the code :</p>
  
  <pre><code>DoCmd.SetParameter "ReportYear", Year.Value
  DoCmd.SetParameter "ReportMonth", Month.Value
  DoCmd.OpenQuery "doFillData"
  </code></pre>
  
  <p>doFillData is a query inside of Access that inserts in to another table automatically, requiring 2 parameters (year and month) before running.</p>
  
  <p>The obvious answer is, make them upgrade to 2010, but I don't have that power. I assume I'll be able to create conditional code to do something different in 2007, but I can't find a similar function to use. Anyone have any ideas?</p>