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.Table Defs!tablename. Properties!Desc ription

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.Table Defs("Table1"). Properties.("De scription")

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*******@colo nialfirststate. com.auwrote in message
news:11******** **************@ 51g2000cwl.goog legroups.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("MyTa ble").Propertie s("description" )
? dbengine(0)(0). QueryDefs("MyQu ery").Propertie s("description" )

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("MyTa ble").Propertie s("description" )
? dbengine(0)(0). QueryDefs("MyQu ery").Propertie s("description" )

Cheers,
--
Smartin