[AccessD] DAO: Find the key field in a tdf?

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






More information about the AccessD mailing list