title: How to use MS Access Public Function from VB6
body: <p>I have a MS Access database with a Public Function defined in VBA, stored in Module1. I would like to include the function as part of a query which is handed to ADODB from VB6 by ADODB.RecordSet's Open method. </p>
  
  <p>The VBA function is called IsOpcodePresent and takes two parameters which are provided in the query.</p>
  
  <p>The query (abbreviated) is </p>
  
  <pre><code>SELECT * FROM tbl WHERE IsOpcodePresent(example,syl) order by syl;
  </code></pre>
  
  <p>Can this be done? If I use standard Access functions like IsNull, then it works. But with my own function it doesn't.</p>