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 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
|
Function MAJ_BaseAffaire(oform As Form)
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim oControl As Control
Dim i As String
Dim j As Integer
Dim tampon As Variant
Set db = CurrentDb
Set rs = db.OpenRecordset("Référence LOC", dbOpenDynaset)
'i = UCase(Forms![référence]![liste1])
sSQL = "Select * From [Référence LOC] WHERE [LOC]= '" & i & "' ;"
Set rs = db.OpenRecordset(sSQL)
' order by [Référence LOC].[Date de Réference] DESC
rs.AddNew
rs![Loc] = oform.liste1
rs![Date de Réference] = oform.Texte108.Value
rs![Axe long E1] = oform.Axe_long_E1.Value
rs![Axe1 E1] = oform.Axe1_E1.Value
rs![Axe2 E1] = oform.Axe2_E1.Value
rs![ML long E1] = oform.ML_E1.Value
rs![Axe long E2] = oform.Axe_long_E2.Value
rs![Axe court E1] = oform.Axe1_E2.Value
rs![Axe2 court E1] = oform.Axe2_E2.Value
rs![ML E2] = oform.ML_E2.Value
rs![Axe court E1] = oform.Axe_court_E1.Value
rs![Axe1 court E1] = oform.Axe1_court_E1.Value
rs![Axe2 court E1] = oform.Axe2_court_E1.Value
rs![ML court E1] = oform.ML_court_E1.Value
rs![Axe court E2] = oform.Axe_court_E2.Value
rs![Axe1 court E2] = oform.Axe1_court_E2.Value
rs![Axe2 court E2] = oform.Axe2_court_E2.Value
rs![ML court E2] = oform.ML_court_E2.Value
rs![Espace 90 E1] = oform.DDM_90_E1.Value
rs![Espace 150 E1] = oform.DDM_150_E1.Value
rs![Fsc1 E1] = oform.Fsc1_E1.Value
rs![Fsc2 E1] = oform.Fsc2_E1.Value
rs![Espace 90 E2] = oform.DDM_90_E2.Value
rs![Espace 150 E2] = oform.DDM_150_E2.Value
rs![Fsc1 E2] = oform.Fsc1_E2.Value
rs![Fsc2 E2] = oform.Fsc2_E2.Value
rs![Clr 1 E1] = oform.Clr_1_E1.Value
rs![Clr 2 E1] = oform.Clr_2_E1.Value
rs![Clr 1 E2] = oform.Clr_1_E2.Value
rs![Clr 2 E2] = oform.Clr_2_E2.Value
For j = 2 To 29
If (rs.Fields(j) = Null) Then
DoCmd.GoToRecord , , acPrevious
tampon = rs.Fields(j)
DoCmd.GoToRecord , , acNext
rs.Fields(j) = tampon
End If
Next
rs.Update
rs.Close
Set rs = Nothing |
Partager