Andy Lacey
andy at minstersystems.co.uk
Fri Jul 9 10:59:08 CDT 2004
In fact I think you have to look in the Indexes collection of the Tabledef and then look at its Fields property. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: Access Developers discussion and problem solving <accessd at databaseadvisors.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Subject: RE: [AccessD] DAO: Find the key field in a tdf? Date: 09/07/04 13:56 > > I forget the exact syntax, but I know one way to do it is to look at the Attributes of the field, if you look in help you should be able to find it. > > -Chris Mackin > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Christopher > Hawkins > Sent: Thursday, July 08, 2004 11:23 PM > To: accessd at databaseadvisors.com > Subject: [AccessD] DAO: Find the key field in a tdf? > > > It's been sooooo long since I did this. > > I'm looping through the fields in a tabledef object. > > What's the syntax to figure out if a field is the key field (or a key > field)? > > -Christopher- > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > > ________________________________________________ Message sent using UebiMiau 2.7.2