[AccessD] 2 Questions concerning lists of fields and indexes

Dim fld as Field
Dim db as DAO.Database
Dim rs as DAO.Recordset

Set rs = db.OpenRecordset("tblFoo")
For Each fld In rs.Fields
    msgbox fld.Name 
Next fld
rs.Close
Set rs = Nothing
 

HTH

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Wednesday, October 17, 2012 6:14 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] 2 Questions concerning lists of fields and indexes

I'm having a senior moment. I can't remember how, given a table name, to:

1. Iterate through its field list
2. identify the field(s) involved in its PK

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com