1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| Dim Plongee, MaDate, ClientEnCours As String
Set TAbClient = CurrentDb.OpenRecordset("TAB_CLIENT", dbOpenTable)
Set TabPlongClient = CurrentDb.OpenRecordset("TAB_PLONGEE_CLIENT", dbOpenTable)
Set TabPlongee = CurrentDb.OpenRecordset("TAB_PLONGEE", dbOpenTable)
TabPlongee.MoveFirst
While Not TabPlongee.EOF
Plongee = CStr(TabPlongee("PLONG_ID"))
MaDate = CStr(TabPlongee("PLONG_DATE"))
TabPlongClient.MoveFirst
While Not TabPlongClient.EOF
If CStr(TabPlongClient("PLONG_ID")) = Plongee Then
ClientEnCours = CStr(TabPlongClient("CLIENT_PRENOM"))
TAbClient.MoveFirst
While Not TAbClient.EOF
If CStr(TAbClient("CLI_ID")) = ClientEnCours Then
TAbClient.Edit
TAbClient("DER_DATE_PLONG") = MaDate
TAbClient.Update
End If
TAbClient.MoveNext
Wend
End If
TabPlongClient.MoveNext
Wend
TabPlongee.MoveNext
Wend |
Partager