title: How to Trigger MS Access Code based on specific time of day rather than every second or minutes
body: <p>I have been trying to pull this off and maybe I am getting close.
  I have some code in Access I need to Run at a specific time of day. I do not want to use Windows Task Scheduler.</p>
  
  <p><strong><em>So I have this function:</em></strong></p>
  
  <pre><code>Public Function RunProgram()
  Dim RunDateFormat As String
  
  RunDateFormat = Format(Now(), "HH:MM:SS")
      If RunDateFormat = ("15:30:00") Then
  
  'Call these codes and other stuff in here
  
  End If
  </code></pre>
  
  <p>Then I create a Macro called Macro1 to call the function, the form On Timer calls
  the Macro as indicated below.</p>
  
  <p><img src="https://i.stack.imgur.com/mpW68.jpg" alt="enter image description here"></p>
  
  <p>The problem is if I set the interval to; example: 1000, I get an email every second and the program keeps running. </p>
  
  <p>Please help: I need to set this so the code runs at the exact time but only one time.</p>