I am trying to set reminders for a couple things but they require a time after the dates that are entered in the form. For Example, I need a reminder to send a survey 2 weeks after the customer is invoiced. The invoiced column has a date format 00/00/0000 and the survey box has a combo Yes/No drop down. I need to figure out the code to look up how many need a survey sent based on these two criteria.
This is what I have
Private Sub Form_Load()
Survey = DCount("Survey", "Database", [Survey] = No And [Date] >= d14)
If Survey > 0 Then
Me.SurveyReminder.Caption "You have" & Survey & "survey Reminders"
End If
End Sub
This is what I have
Private Sub Form_Load()
Survey = DCount("Survey", "Database", [Survey] = No And [Date] >= d14)
If Survey > 0 Then
Me.SurveyReminder.Caption "You have" & Survey & "survey Reminders"
End If
End Sub