[AccessD] Re: How to add a table description via code

Tom
 
Essentially you get a field def, dim a Property then do something like
 
    Set prp = fld.CreateProperty("Description")
    prp.Type = dbText
    prp.Value = "XYZ"
    fld.Properties.Append prp

 
 

Andy Lacey
http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/> 



-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: 18 March 2003 18:06
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Re: How to add a table description via code


DAO or ADO?  Either way, you may have to create a description property
for the table and then set its value.
 
Charlotte Foust

-----Original Message-----
From: t tom [mailto:ttom at accessyourdata.com] 
Sent: Tuesday, March 18, 2003 9:29 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Re: How to add a table description via code


Hi All
 
After creating a table with a Make table query , how can I add a
description via code ?
 
TIA
Tomt

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030318/3813ef64/attachment-0001.html>