1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT T_dossierAléa.DC,T_dossierAléa.motifPrincipale,T_dossierAléa.observation,T_dossierAléa.clientAviseAtemps,T_dossierAléa.fournisseurAvise FROM T_dossierAléa inner JOIN T_Revue ON (T_dossierAléa.DESTINATION = T_Revue.destination) AND (T_dossierAléa.ORIGINE = T_Revue.Origine) where DC_prévu > DC_Reel and (T_dossierAléa.DateEngaTheo between #" & Format(Me.ld_revueDateEngaDeb, "mm/dd/yy") & "# and #" & Format(Me.ld_revueDateEngaFin, "mm/dd/yy") & "# )order by T_dossierAléa.DC ", dbOpenDynaset)
Dim str As String
Dim Motif As String
Dim observation As String
Dim clientAviseAtemps As String
Dim fournisseurAvise As String
str = ""
Motif = ""
observation = ""
clientAviseAtemps = ""
fournisseurAvise = ""
While Not rs.EOF
str = str & rs.Fields("DC") & Chr(47)
Motif = Motif & rs.Fields("motifPrincipale") & Chr(47)
observation = observation & rs.Fields("observation") & Chr(47)
clientAviseAtemps = clientAviseAtemps & rs.Fields("clientAviseAtemps") & Chr(47)
fournisseurAvise = fournisseurAvise & rs.Fields("fournisseurAvise") & Chr(47)
rs.MoveNext
Wend
'MsgBox clientAviseAtemps
DoCmd.RunSQL "UPDATE T_revue INNER JOIN T_dossierAléa ON (t_revue.destination = T_dossierAléa.DESTINATION) AND (t_revue.Origine = T_dossierAléa.ORIGINE) SET T_revue.DC=" & Chr(34) & str & Chr(34) & ",T_revue.observation=" & Chr(34) & observation & Chr(34) & ", T_revue.motifPrincipale = " & Chr(34) & Motif & Chr(34) & ",T_revue.clientAviseAtemps = " & Chr(34) & clientAviseAtemps & Chr(34) & ",T_revue.fournisseurAvise = " & Chr(34) & fournisseurAvise & Chr(34) & " where DC_prévu > DC_Reel;" |
Partager