Need help in running the code automatically on a daily basis

Need help in running the code automatically on a daily basis

Post by FA » Fri, 10 Feb 2006 02:58:10


Hi Freinds, I have this problem hoping one of you expert can resolve
the issue. Here is my code to send the email.
Private Sub SendEmailToAssignedTo_Click()
On Error GoTo Err_SendEmailToAssignedTo_Click
DoCmd.SendObject , "", "", Me![PRA_CTAC_NME], "", "", Me![SYS_NME],
"Please Respond with some more Data in order to proceed in
scheduling.", False, ""
Exit_SendEmailToAssignedTo_Click:
Exit Sub
Err_SendEmailToAssignedTo_Click:
MsgBox Err.Description
Resume Exit_SendEmailToAssignedTo_Click
End Sub

Here is my question:
SendEmailToAssignedTo is a command button on a from called frmPRA. On
the same form i have a control called RIT_AT_SCORE.
I want to send this email message on a daily basis until i have some
value in Me.RIT_AT_SCORE

That means i want this code to run once a day until i have some value
in Me.RIT_AT_SCORE.

Can someone help me out with this please.

Thanks
Moe
 
 
 

Need help in running the code automatically on a daily basis

Post by Ron200 » Tue, 21 Feb 2006 22:25:20

Has anyone ever replied to you on this?

Do you still need suggestions?

Ron