Dim i As Integer Dim db As DAO.Database Dim ajout As DAO.Recordset Dim tbl As DAO.Recordset Dim fld() Dim modif As DAO.Recordset Dim mot As String mot = "serveur1" Set db = OpenDatabase("c:\facture.mdb") Set tbl = db.OpenRecordset("salut") tbl.Index = "PrimaryKey"'Set ajout db.OpenRecordset("select * from temporaire where nom_serveur'" & mot & "';") Set ajout = db.OpenRecordset("select * from temporaire") Do Until ajout.EOF tbl.Seek "=", ajout("nom_serveur") If tbl.NoMatch Then tbl.AddNew tbl("nom_serveur") = ajout("nom_serveur") Else tbl.Edit End If For i = 0 To ajout.Fields.Count - 1 If Not IsNull(ajout.Fields(i)) Then tbl.Fields(i) = ajout.Fields(i) Next tbl.Update ajout.MoveNext Loop
Dim i As Integer Dim db As DAO.Database Dim ajout As DAO.Recordset Dim tbl As DAO.Recordset Dim fld() Dim modif As DAO.Recordset Dim mot As String mot = "serveur1" Set db = OpenDatabase("c:\facture.mdb") Set tbl = db.OpenRecordset("salut") tbl.Index = "PrimaryKey"Set ajout db.OpenRecordset("select * from temporaire where nom_serveur'" & mot & "';") Do Until ajout.EOF tbl.Seek "=", ajout("nom_serveur") If tbl.NoMatch Then tbl.AddNew tbl("nom_serveur") = ajout("nom_serveur") Else tbl.Edit End If For i = 0 To ajout.Fields.Count - 1 If Not IsNull(ajout.Fields(i)) Then tbl.Fields(i) = ajout.Fields(i) Next tbl.Update ajout.MoveNext Loop
Dim i As Integer Dim db As DAO.Database Dim ajout As DAO.Recordset Dim tbl As DAO.Recordset Dim fld() Dim modif As DAO.Recordset Dim mot As String mot = "serveur1" Set db = OpenDatabase("c:\facture.mdb") Set tbl = db.OpenRecordset("salut") tbl.Index = "PrimaryKey"Set ajout db.OpenRecordset("select * from temporaire where nom_serveur'" & mot & "';") Do Until ajout.EOF tbl.Seek "=", ajout("nom_serveur") If Not tbl.NoMatch Then tbl.Edit For i = 0 To ajout.Fields.Count - 1 If Not IsNull(ajout.Fields(i)) Then tbl.Fields(i) = ajout.Fields(i) Next tbl.Update End If ajout.MoveNext Loop
E.B.
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionE.B.
Dim i As Integer Dim db As DAO.Database Dim ajout As DAO.Recordset Dim tbl As DAO.Recordset Dim fld() Dim modif As DAO.Recordset Dim mot As String mot = "serveur1" Set db = CurrentDb db.Execute "Delete * From salut where nom_serveur ='" & mot & "';" Set tbl = db.OpenRecordset("salut")Set ajout db.OpenRecordset("select * from temporaire where nom_serveur'" & mot & "';") Do Until ajout.EOF tbl.AddNew For i = 0 To ajout.Fields.Count - 1 tbl.Fields(i) = ajout.Fields(i) Next tbl.Update ajout.MoveNext Loop
Dim db As DAO.Database Dim mot As String mot = "serveur1" Set db = CurrentDb db.Execute "Delete * From salut where nom_serveur ='" & mot & "';" db.Execute "Insert into salut Select * From temporaire where nom_serveur ='" & mot & "';"