<div>
<div class="content wysiwyg-content">
Hi..... my VB application uses an MS Access database.. I need to learn to use ADO filtering capabilities as an addition to SQL statements for records retrieval..<br />
In the following code I used and SQL statement to get all AC_NO that matches the value of texbox txtSearchPlane... <br />
<br />
rsDefects.Open &quot;Select * From Defects where AC_No = '&quot; &amp;&nbsp;txtSearchPlane &amp;&nbsp;&quot;'&quot;, _<br />
cnAP, adOpenKeyset, adLockOptimistic<br />
<br />
Supposing I want to filter the resulting recordset by a criteria that filters all AC_No that match the value of &nbsp;textOutOfService...?<br />
<br />
A couple of examples would help... thanks<br />

</div>
</div>


Hi..... my VB application uses an MS Access database.. I need to learn to use ADO filtering capabilities as an addition to SQL statements for records retrieval..
In the following code I used and SQL statement to get all AC_NO that matches the value of texbox txtSearchPlane... 

rsDefects.Open "Select * From Defects where AC_No = '" & txtSearchPlane & "'", _
cnAP, adOpenKeyset, adLockOptimistic

Supposing I want to filter the resulting recordset by a criteria that filters all AC_No that match the value of  textOutOfService...?

A couple of examples would help... thanks


using Filters with ADO recordsets

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.