Fancy-Filters-Form.jpg

<div>
Which video were you viewing? For some reason, it's not linked here.<br />
<br />
In most cases, you just check to see if the user has entered values in your Start and End date boxes, and then move along from there. For example:<br />
<br />
If Nz(Me.txtStart, &quot;&quot;) = &quot;&quot;&nbsp;And Nz(Me.txtEnd, &quot;&quot;) = &quot;&quot;&nbsp;Then<br />
&nbsp; '/ user did NOT enter any dates<br />
&nbsp; DoCmd.OpenReport &quot;YourReport&quot; etc etc<br />
Else<br />
&nbsp; '/ user did enter dates, so create the filter below<br />
<br />
End If
</div>


Which video were you viewing? For some reason, it's not linked here.

In most cases, you just check to see if the user has entered values in your Start and End date boxes, and then move along from there. For example:

If Nz(Me.txtStart, "") = "" And Nz(Me.txtEnd, "") = "" Then
  '/ user did NOT enter any dates
  DoCmd.OpenReport "YourReport" etc etc
Else
  '/ user did enter dates, so create the filter below

End If

<div>
This solution goes far beyond my expectations. &nbsp;As a novice ACCESS developer I was looking for a verse and got the BIBLE!<br />
<br />
Thanks,<br />
<br />
Wayne
</div>


This solution goes far beyond my expectations.  As a novice ACCESS developer I was looking for a verse and got the BIBLE!

Thanks,

Wayne

<div>
<div class="content wysiwyg-content">
Excellent video. &nbsp;I am a novice so don't assume I know anything. <br />
<br />
In the example code with a Start and End date in the criteria form it doesn't appear to allow for running the report with NO start and end date. &nbsp;i.e. unfiltered. &nbsp;<br />
<br />
Please show the code needed to do that
</div>
</div>


Excellent video.  I am a novice so don't assume I know anything. 

In the example code with a Start and End date in the criteria form it doesn't appear to allow for running the report with NO start and end date.  i.e. unfiltered.  

Please show the code needed to do that

How to run a report with no criteria

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.