<div>
If DCount(&quot;[Part_Number]&quot;, &quot;Etching_Schedule&quot;, &quot;[Part_Number] = '&quot; &amp;&nbsp;Me.txtPart_Number &amp;&quot;'&quot;) &gt;&nbsp;0 Then<br />
<br />
<br />
Me.txtPart_Number &nbsp;must be aoutside the double quotes for it to be evaluated
</div>


<div>
Would you provide an example for the DATE data type?<br />
Thanks,<br />
Brooks
</div>


<div>
<br />
<br />
If DCount(&quot;[Part_Number]&quot;, &quot;Etching_Schedule&quot;, &quot;[Part_Number] = '&quot; &amp;&nbsp;Me.txtPart_Number &amp;&quot;' And [datefield]=#&quot; &amp;&nbsp;date() &amp;&nbsp;&quot;#&quot;) &gt;&nbsp;0 Then
</div>


<div>
<div class="content wysiwyg-content">
I'm using this code:<br />
<br />
If DCount(&quot;[Part_Number]&quot;, &quot;Etching_Schedule&quot;, &quot;[Part_Number] = 'Me.txtPart_Number'&quot;) &gt;&nbsp;0 Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MsgBox &quot;That part number already exists for that date and shift.&quot;<br />
End If<br />
<br />
The code executes without error. &nbsp;That part number does exist and it should go to the message box, but does not.<br />
<br />
If I change the &gt;&nbsp;to =, the message box does come up.<br />
<br />
I don't understand why it is not finding the matching record.<br />
<br />
Thanks,<br />
Brooks<br />

</div>
</div>


I'm using this code:

If DCount("[Part_Number]", "Etching_Schedule", "[Part_Number] = 'Me.txtPart_Number'") > 0 Then
            MsgBox "That part number already exists for that date and shift."
End If

The code executes without error.  That part number does exist and it should go to the message box, but does not.

If I change the > to =, the message box does come up.

I don't understand why it is not finding the matching record.

Thanks,
Brooks


If DCount(&quot;[Part_Number]&quot;, &quot;Etching_Schedule&quot;, &quot;[Part_Number] = &#39;&quot; &amp; Me.txtPart_Number &amp;&quot;&#39;&quot;) &gt; 0 Then


Me.txtPart_Number  must be aoutside the double quotes for it to be evaluated

Would you provide an example for the DATE data type?
Thanks,
Brooks



If DCount(&quot;[Part_Number]&quot;, &quot;Etching_Schedule&quot;, &quot;[Part_Number] = &#39;&quot; &amp; Me.txtPart_Number &amp;&quot;&#39; And [datefield]=#&quot; &amp; date() &amp; &quot;#&quot;) &gt; 0 Then

Access 2007 VBA DCount() problem

I&#39;m using this code:

If DCount(&quot;[Part_Number]&quot;, &quot;Etching_Schedule&quot;, &quot;[Part_Number] = &#39;Me.txtPart_Number&#39;&quot;) &gt; 0 Then
            MsgBox &quot;That part number already exists for that date and shift.&quot;
End If

The code executes without error.  That part number does exist and it should go to the message box, but does not.

If I change the &gt; to =, the message box does come up.

I don&#39;t understand why it is not finding the matching record.

Thanks,
Brooks


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.