Sub Misajour() Dim secondquarter As String Dim db As DAO.Database Dim tbl As DAO.Recordset Dim fld(5) '*************** nombre des champs Set db = CurrentDb() Set tbl = db.OpenRecordset("secondquarter", dbOpenDynaset) tbl.MoveFirst Do Until tbl.EOF For i = 0 To 4 '*************** nombre des champs -1 fld(i) = tbl.fields(i) Next tbl.MoveNext If Not tbl.EOF Then tbl.Edit For i = 0 To 4 '*************** nombre des champs -1 If fld(i) <> "" Then tbl.fields(i) = fld(i) Next tbl.Update End If Loop End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSub Misajour() Dim secondquarter As String Dim db As DAO.Database Dim tbl As DAO.Recordset db.Source = seconquarter Set db = CurrentDb() Set tbl = db.OpenRecordset("secondquarter", dbOpenDynaset) Do Until tbl.EOF tbl.MoveFirst Loop If secondquarter = "" Then Else tbl(nom_serveur) = "coucou" End If tbl.Update tbl.MoveNext tbl.Close End Sub