retrieving the description field in Table/Query properties through code

[Bob]

Hi all,

I write the description of a lot of my tables and queries in the
description section in the properties (when you right click on the
table or query). Is there a method or a property that use use to
retrieve that description from code somehow?

Cheers

[Marshall Barton]

Bob wrote:

>I write the description of a lot of my tables and queries in the
description section in the properties (when you right click on the
table or query). Is there a method or a property that use use to
retrieve that description from code somehow?

Just refer to the object's Description property:

CurrentDb.TableDefs!tablename.Properties!Descripti on

The tricky part is that you will get a trappable error if
you have not set the description. Just check the error
number and do something appropriate.

--
Marsh

[Allen Browne]

If the table has a Description, you can get it from:
CurrentDb.TableDefs("Table1").Properties.("Descrip tion")

If it has no description, that will generate an error, so use error
handling.

For a query, replace TableDefs with QueryDefs. However, if the query has no
description, Access may get confused and give you the description of one of
the tables in the query instead of recognising that there's none.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob" <sc*******@colonialfirststate.com.auwrote in message
news:11**********************@51g2000cwl.googlegro ups.com...

>
I write the description of a lot of my tables and queries in the
description section in the properties (when you right click on the
table or query). Is there a method or a property that use use to
retrieve that description from code somehow?

Cheers

[Smartin]

Bob wrote:

Hi all,

I write the description of a lot of my tables and queries in the
description section in the properties (when you right click on the
table or query). Is there a method or a property that use use to
retrieve that description from code somehow?

Cheers

Hi Bob, yes there is:

? dbengine(0)(0).TableDefs("MyTable").Properties("de scription")
? dbengine(0)(0).QueryDefs("MyQuery").Properties("de scription")

Cheers,
--
Smartin

[Bob]

Thanks everyone!

Smartin wrote:

Bob wrote:

Hi all,

I write the description of a lot of my tables and queries in the
description section in the properties (when you right click on the
table or query). Is there a method or a property that use use to
retrieve that description from code somehow?

Cheers

Hi Bob, yes there is:

? dbengine(0)(0).TableDefs("MyTable").Properties("de scription")
? dbengine(0)(0).QueryDefs("MyQuery").Properties("de scription")

Cheers,
--
Smartin