<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=470344119-18032003><FONT face=Arial color=#0000ff
size=2>Tom</FONT></SPAN></DIV>
<DIV><SPAN class=470344119-18032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=470344119-18032003><FONT face=Arial color=#0000ff
size=2>Essentially you get a field def, dim a Property then do something
like</FONT></SPAN></DIV>
<DIV><SPAN class=470344119-18032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=470344119-18032003><FONT face=Arial color=#0000ff
size=2> Set prp =
fld.CreateProperty("Description")<BR> prp.Type =
dbText<BR> prp.Value = "XYZ"</FONT></SPAN></DIV>
<DIV><SPAN class=470344119-18032003><FONT face=Arial color=#0000ff
size=2> fld.Properties.Append prp<BR></DIV></FONT></SPAN>
<DIV> </DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A><BR><BR></FONT></P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com]
<B>On Behalf Of </B>Charlotte Foust<BR><B>Sent:</B> 18 March 2003
18:06<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Re: How to add a table description via code<BR><BR></FONT></DIV>
<DIV><SPAN class=478220518-18032003><FONT face="Comic Sans MS" color=#0000ff
size=2>DAO or ADO? Either way, you may have to create a description
property for the table and then set its value.</FONT></SPAN></DIV>
<DIV><SPAN class=478220518-18032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=478220518-18032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> t tom
[mailto:ttom@accessyourdata.com] <BR><B>Sent:</B> Tuesday, March 18, 2003
9:29 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] Re: How to add a table description via code<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi All</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>After creating a table with a Make table query
, how can I add a description via code ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>TIA</FONT></DIV>
<DIV><FONT face=Arial
size=2>Tomt</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>