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
| Private Sub Commande20_Click()
Dim dbsTest As Database
Dim requetedef As QueryDef
Dim tdfNewtbl As TableDef
Dim rstRequete As DAO.Recordset
Dim rstTable As DAO.Recordset
Set dbsTest = CurrentDb
Set rdf = dbsTest.CreateQueryDef("Query", "SELECT champ1, " & _
"champ2, FROM Table1")
Set rstRequete = dbsTest.OpenRecordset("Query", dbOpenDynaset)
Set tdfNewtbl = dbsTest.CreateTableDef("Table2")
With tdfNewtbl
.Fields.Append .CreateField("champ1t2", dbLong, 25)
.Fields.Append .CreateField("champ2t2", dbText, 25)
End With
dbsTest.TableDefs.Append tdfNewtbl
While rstRequete.EOF <> True
Set rstTable = dbsTest.OpenRecordset("Table2", dbOpenDynaset)
tdfNewtbl.AddNew
rstTable!champ1t2 = rstRequete!champ1
rstTable!champ2t2 = rstRequete!champ2
tdfNewtbl.Update
rstRequete.MoveFirst
Wend
End Sub |
Partager