jwcolby
jwcolby at colbyconsulting.com
Sat Jul 10 06:43:25 CDT 2004
Just remember that if the original developer used natural keys, there may be a multi-field key, thus several fields may be "the key field". John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher Hawkins Sent: Friday, July 09, 2004 8:42 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] DAO: Find the key field in a tdf? Aaaaaah, yes. I think you're right. I'll go try it. -C- ---- Original Message ---- From: andy at minstersystems.co.uk To: accessd at databaseadvisors.com, Subject: RE: [AccessD] DAO: Find the key field in a tdf? Date: Fri, 9 Jul 2004 16:59:08 +0100 >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 > >-- >_______________________________________________ >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