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
| Function CreateInter()
Dim db As DAO.Database
Dim qry As DAO.QueryDef
Dim fld As DAO.Field
Dim newtbl As DAO.TableDef
Dim newfld As DAO.Field
Set db = CurrentDb
Set qry = db.QueryDefs("rSourceRac")
Set newtbl = db.CreateTableDef("tInter")
For Each fld In qry.Fields
If fld.Name = "PN" Then
newtbl.Fields.Append newtbl.CreateField(fld.Name, dbText, 6)
Else
newtbl.Fields.Append newtbl.CreateField(fld.Name, dbText, 20)
End If
Next
db.TableDefs.Append newtbl
db.TableDefs.Refresh
Set fld = Nothing
Set qry = Nothing
db.Close
Set db = Nothing
End Function |
Partager