I am trying to set up my database to check the local time and then, if the time is after 16:30 run an update. my update is a form that runs from the on click of a command button on another form. My question... after searching the forum and finding nothing, is... how do I make access click the button for me? My code looks like this so far. I have the time set for 09:30 right now for testing purposes.
Option Compare Database
Public Function TaskUpdater()
If Time() > "9:30:00" Then
DoCmd.OpenForm "frm_training", acNormal, "", "", acEdit, ""
End If
End Function
Help?
Option Compare Database
Public Function TaskUpdater()
If Time() > "9:30:00" Then
DoCmd.OpenForm "frm_training", acNormal, "", "", acEdit, ""
End If
End Function
Help?