title: Calling An MS Access Function From VB.net
body: <p>Hi I'm very new to MS Access scripting and I was wondering how to call a function. I tried it like this:</p>
  
  <p>In VB.net -</p>
  
  <pre><code>oAccess.Run("AuditEditEnd", "zaudTmpFuelDispensed", "zaudFuelDispensed", "ID", "Nz(Me!ID, 0)", "bWasNewRecord")
  </code></pre>
  
  <p>In MS Access - </p>
  
  <pre><code>Function AuditEditEnd(sTable As String, sAudTmpTable As String, sAudTable As String, _
  sKeyField As String, lngKeyValue As Long, bWasNewRecord As Boolean) As Boolean
  </code></pre>
  
  <p>...and it's an <em>"invalid function call"</em> sorry I don't know the exact terms to Google for this but I'll keep trying.</p>
  
  <p><img src="https://i.stack.imgur.com/PHN6E.png" alt="enter image description here"></p>