Access Database VBA script help -- 3
Budget: $2 – $8 USD
I need a very simple vba code added to email users that show up as a result of a filter.
Current Button = this button filters overdue appointments (this is already created). No changes needed.
Private Sub FilterOverDueAppointment_Click()
Dim strCriteria, task As String
strCriteria = "[Appointment] + 365 < Date()"
Me.Filter = strCriteria
Me.FilterOn = True
I have a split form that shows the results of these users.
I need to add 2 buttons added to send and email.
1st button will be to the primary and alternate, 2nd alternate (all of these columns are listed)
2nd button will be to the primary, alternate, 2nd alternate and leader (all of these columns are listed)
Essentially I need a basic code that selects those email columns and opens outlook and adds them to the TO block. and the email stays open. (.display)
Current Button = this button filters overdue appointments (this is already created). No changes needed.
Private Sub FilterOverDueAppointment_Click()
Dim strCriteria, task As String
strCriteria = "[Appointment] + 365 < Date()"
Me.Filter = strCriteria
Me.FilterOn = True
I have a split form that shows the results of these users.
I need to add 2 buttons added to send and email.
1st button will be to the primary and alternate, 2nd alternate (all of these columns are listed)
2nd button will be to the primary, alternate, 2nd alternate and leader (all of these columns are listed)
Essentially I need a basic code that selects those email columns and opens outlook and adds them to the TO block. and the email stays open. (.display)