<div>
for ADO it's .State. I am not sure for DAO though. Might be the same, try it.
</div>


for ADO it's .State. I am not sure for DAO though. Might be the same, try it.

<div>
Testing Is Nothing only works if the object is actually set to nothing in the code. &nbsp;If someone closes the recordset without setting it to nothing, you wouldn't know if it was open or not. &nbsp;You can test that yourself.
</div>


Testing Is Nothing only works if the object is actually set to nothing in the code.  If someone closes the recordset without setting it to nothing, you wouldn't know if it was open or not.  You can test that yourself.

<div>
<div class="content wysiwyg-content">
<br />
<br />
Hi,<br />
<br />
I searched on this web site, and some people suggest to compare it with Nothing, but I am not quite sure about it...<br />
<br />
Is there an attribute or something for DAO recordset...for example...state, status, or something<br />
<br />
Thanks
</div>
</div>




Hi,

I searched on this web site, and some people suggest to compare it with Nothing, but I am not quite sure about it...

Is there an attribute or something for DAO recordset...for example...state, status, or something

Thanks

how to check if the recordset is opened or close with DAO

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.