Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Database - Display a list of fields in a table
0 views
Skip to first unread message
Morris
Oct 27, 1997, 3:00:00 AM10/27/97
to
How can I display a list of field in a table?
I am using this code to display a list of table in a database.
Dim db As Database
Dim td As TableDef
DatDatabase.DatabaseName = TxtText1.Text
Set db = OpenDatabase(TxtText1.Text)
For Each td In db.TableDefs
List1.AddItem td.Name
Next
COGioia
Oct 27, 1997, 3:00:00 AM10/27/97
to
Dim fld as Field
For Each fld in db.TableDefs(tablename).Fields
List1.AddItem fld.Name
Next
Amfuzzy
Oct 30, 1997, 3:00:00 AM10/30/97
to
Morris <mor...@chch.planet.org.nz> wrote in article
<3453B8...@chch.planet.org.nz>...
> How can I display a list of field in a table?
the listfields method will allow you to create a snapshot of the fields in
a recordset.
--
---------------------------------------------------------------------------
Ken Hagans
k...@kgh.com
http://www.kgh.com
0 new messages