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
| Dim dbs As Database
Dim qdf As QueryDef
Dim rst As Recordset
Dim n As Integer
Dim resultat As Integer
Dim varId As Integer
Dim strSQL As String
n = 2
Set dbs = CurrentDb
'Set qdf = dbs.CreateQueryDef
strSQL = "SELECT * FROM T1"
Set rst = dbs.OpenRecordset(strSQL)
Do While Not rst.EOF
resultat = n Mod 2
If resultat = 0 Then
dbs.Execute " INSERT INTO T2 (IdProd1, DesignProd1, PhotoProd1,IdProd2, DesignProd2, PhotoProd2) VALUES" _
& "(" & rst.Fields(0) & ", '" & rst.Fields(1) & "', '" & rst.Fields(2) & "', null, null, null);"
varId = rst.Fields(0)
ElseIf resultat = 1 Then
dbs.Execute " UPDATE T2 SET IdProd2= " & rst.Fields(0) & ", DesignProd2 = '" & rst.Fields(1) & "', PhotoProd2 = '" & rst.Fields(2) & "' " _
& " WHERE IdProd = varId;"
End If
n = n + 1
rst.MoveNext
Loop
rst.Close |
Partager