<div>
The above assumes ClientiD is Numeric.<br />
<br />
If it is TEXT, use this:<br />
<br />
sqlCode = &quot;SELECT * FROM imail_tblIMail where [ClientID] = '&quot; &amp;&nbsp;strClient &amp;&nbsp;&quot;' And [EnvelopeImageName] &nbsp; Like &nbsp;'&quot; &amp;&nbsp;strDoc &amp;&nbsp;&quot;*'&quot;<br />
<br />

</div>


The above assumes ClientiD is Numeric.

If it is TEXT, use this:

sqlCode = "SELECT * FROM imail_tblIMail where [ClientID] = '" & strClient & "' And [EnvelopeImageName]   Like  '" & strDoc & "*'"



<div>
In case that doesn't work, try this:<br />
<br />
sqlCode = &quot;SELECT * FROM imail_tblIMail where [ClientID] = &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;strClient &amp;&nbsp;Chr(34) &amp;&nbsp;&quot; And [EnvelopeImageName] Like &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;strDoc &amp;&nbsp;Chr(34) &amp;&nbsp;&quot; * &quot;&quot;&quot;<br />
<br />
mx
</div>


In case that doesn't work, try this:

sqlCode = "SELECT * FROM imail_tblIMail where [ClientID] = " & Chr(34) & strClient & Chr(34) & " And [EnvelopeImageName] Like " & Chr(34) & strDoc & Chr(34) & " * """

mx

<div>
opps ... typo:<br />
<br />
sqlCode = &quot;SELECT * FROM imail_tblIMail where [ClientID] = &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;strClient &amp;&nbsp;Chr(34) &amp;&nbsp;&quot; And [EnvelopeImageName] Like &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;strDoc &amp;&nbsp;Chr(34) &amp;&nbsp;&quot;*&quot;<br />
<br />
<br />
mx
</div>


opps ... typo:

sqlCode = "SELECT * FROM imail_tblIMail where [ClientID] = " & Chr(34) & strClient & Chr(34) & " And [EnvelopeImageName] Like " & Chr(34) & strDoc & Chr(34) & "*"


mx

<div>
thanks for the alternative mx :)<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I get a compile error. expected expression.<br />
<br />
sqlCode = &quot;SELECT * FROM imail_tblIMail where [ClientID] = &nbsp;&amp; strClient &amp;&nbsp;&quot; And [EnvelopeImageName] &nbsp; Like &nbsp;'&quot; &amp;&nbsp;strDoc &amp;&nbsp;&quot;*'&quot;<br />
<br />
surely it's a single or double quote I'm missing but am stuck. :(<br />
<br />
Any ideas?
</div>
</div>


I get a compile error. expected expression.

sqlCode = "SELECT * FROM imail_tblIMail where [ClientID] =  & strClient & " And [EnvelopeImageName]   Like  '" & strDoc & "*'"

surely it's a single or double quote I'm missing but am stuck. :(

Any ideas?

compile error. expected expression.

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.