Ricks27
Messages postés79Date d'inscriptionmardi 4 juin 2002StatutMembreDernière intervention29 juillet 2005 25 nov. 2004 à 10:59
Sub TableFields(ByVal DbName As String, ByVal TableName As String)
Dim WrkSpc As DAO.Workspace
Dim Db As DAO.Database
Dim T As Long, U As Long
Dim Mytable As DAO.TableDef
Set WrkSpc = DAO.CreateWorkspace("MyWorkspace", "admin", "", dbUseJet)
Set Db = WrkSpc.OpenDatabase(DbName, , , dbUseJet)
Set Mytable = Db.TableDefs(TableName)
For U = 1 To Mytable.Fields.Count - 1
Form1.cboFields.AddItem Mytable.Fields(U).Name
Next U
Db.Close
Set Db = Nothing
Set WrkSpc = Nothing
End Sub