j'ai modifier le nom de ma variable recipients en v_recipients mais j'ai toujours la même erreur
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Public Function GetRecipients(ByVal taskId As Long) As recipients
Dim v_recipients As recipients
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset( _
"SELECT Tbl_WD11_Contacts.contactEmailBus " & _
"FROM Tbl_WD11_Contacts INNER JOIN (Tbl_WD22_Tasks INNER JOIN Tbl_WD25_TaskInvolvement ON Tbl_WD22_Tasks.taskId = Tbl_WD25_TaskInvolvement.InvolvTaskId) ON Tbl_WD11_Contacts.ContactId = Tbl_WD25_TaskInvolvement.involvContactId " & _
"WHERE (((Tbl_WD22_Tasks.taskId)=" & taskId & "))" _
)
Do While Not rs.EOF
v_recipients.Add (rs.Fields("contactEmailBus"))
Loop
GetRecipients = v_recipients
rs.Close
End Function |
L'erreur se produit au moment du :
v_recipients.Add (rs.Fields("contactEmailBus"))
Partager