<div>
THANKS FOR GREAT ASSIST, that did it simplified my code - since I need to change all my recordsets and sql strings to look at either local tables or external tables.
</div>


THANKS FOR GREAT ASSIST, that did it simplified my code - since I need to change all my recordsets and sql strings to look at either local tables or external tables.

<div>
<div class="content wysiwyg-content">
is it possible to use something like an &quot;In&quot; statement within the DCOUNT funciton, if so what is the proper syntax<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; i = DCount(&quot;RecordLock&quot;, &quot;tblInvoice&quot;, &quot;ContractNumber =&quot; &amp;&nbsp;Chr(34) &amp;&nbsp;_<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; gContractID &amp;&nbsp;Chr(34) &amp;&nbsp;&quot; and RecordLock = 0&quot;)<br />
<br />
I want to change the database source from local to an external mdb.<br />
&nbsp; &nbsp; &nbsp; &nbsp; i = DCount(&quot;RecordLock&quot;, &quot;tblInvoice IN '\\filepath\mdbname.mdb&quot;, &quot;ContractNumber =&quot; &amp;&nbsp;Chr(34) &amp;&nbsp;_<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; gContractID &amp;&nbsp;Chr(34) &amp;&nbsp;&quot; and RecordLock = 0&quot;)
</div>
</div>


is it possible to use something like an "In" statement within the DCOUNT funciton, if so what is the proper syntax

        i = DCount("RecordLock", "tblInvoice", "ContractNumber =" & Chr(34) & _
                    gContractID & Chr(34) & " and RecordLock = 0")

I want to change the database source from local to an external mdb.
        i = DCount("RecordLock", "tblInvoice IN '\\filepath\mdbname.mdb", "ContractNumber =" & Chr(34) & _
                    gContractID & Chr(34) & " and RecordLock = 0")

using external filepath within the DCOUNT

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.