1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Dim DB As Database
Dim Req As QueryDef
Set Req = DB.CreateQueryDef("", "UPDATE Zones SET " & _
" DateInit =" & DateInit.Text & _
", DateFin =" & DateFinale.Text & _
", SA =" & SA.Text & _
", PopU =" & CDbl(Pop.Text) & _
", NatInitU =" & CDbl(NatInit.Text) & _
", NatFinU =" & CDbl(NatFin.Text) & _
", NatIFU =" & CDbl(NatIF.Text) & _
", NatPIU =" & CDbl(NatPI.Text) & _
", MortInitU =" & CDbl(MortInit.Text) & _
", MortFinU =" & CDbl(MortFin.Text) & _
", MortPIU =" & CDbl(MortPI.Text) & _
", MortIFU =" & CDbl(MortIF.Text) & _
" WHERE NomZone=" & "'" & Trim(NomZone.Text) & "'")
Req.Execute |
Partager