VBA run Access Report with Parameter based on query
<p>I want to automate some of our Access Reports with a VBA script. But when I want to run them with <code>DoCmd.OpenReport</code>, I have the problem that every Report has a Popup for some Parameters coming from the underlying Query. </p>

<p>This is how the Parameter looks like in the Query: </p>

<pre><code>PARAMETERS [Time] Text ( 255 );
</code></pre>

<p>I googled a lot and tried with:</p>

<pre><code> DoCmd.OpenReport "B_My_Report", acViewPreview, , "[Time]= 423"
</code></pre>

<p>But this didn't work; the popup still comes and when I enter nothing, the query will fail because <em>Time</em> parameter is empty. </p>

<p>Is there a way I can call the Report with the Parameter value. I read a lot of Suggestion to remove the Parameter completely and use the <code>where</code> condition in <code>OpenReport</code>. But I can't change these Queries because they aren't made and maintained by me. I only have to run them sometimes. So I would love to have a solution without touching the Report or the Query.</p>