Access Object common properties.

[Gerry Abbott]

Access allows all objects, tables, forms, queries, macros, modules, to be
documented with common object properties, including Description, Type,
modified and created dates, owner, and some attributes, hidden and
replicable.

I have found the Name, DateCreated and DateUpdated properties of the
document class of the container object for the current database.

Is there a way to access the Description and the Attribures in a similar
way. ??
The description filed appears to be 255characters.

Thanks in advance.

--

Gerry
Mitas
Ryemont Abbey,
Leixlip,
Co. Kildare
Phone: [phone]
Fax:[phone]
In**@mitas.ie
www.mitas.ie
_______________

DISCLAIMER:
This e-mail may contain proprietary information,
and is covered by copyright. It may be legally privileged, and is for the
intended
recipient only. If you are not the intended recipient you must not use,
disclose, distribute, copy, print or rely on this e-mail.

[Allen Browne]

I don't believe you can get the Description through the Documents
collection.

You can get it through this kind of reference:
?
CurrentDb().TableDefs("MyTable").Fields("MyField") .Properties("Description")

Generates an trappable error if the Description does not exist.

--
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.

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:Q8*****************@news.indigo.ie...

Access allows all objects, tables, forms, queries, macros, modules, to be
documented with common object properties, including Description, Type,
modified and created dates, owner, and some attributes, hidden and
replicable.

I have found the Name, DateCreated and DateUpdated properties of the
document class of the container object for the current database.

Is there a way to access the Description and the Attribures in a similar
way. ??
The description filed appears to be 255characters.

[Gerry Abbott]

Thanks Allen,
But it that not the description of the field in a table.

I'm looking for the description of the form. or table or query.

Its the one which appears in the database window when the View/Details is
selected from the menu.
Its updated when the user right clicks on the object, selects properties,
and inserts the description.

Gerry


"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...

I don't believe you can get the Description through the Documents
collection.

You can get it through this kind of reference:
?
CurrentDb().TableDefs("MyTable").Fields("MyField") .Properties("Description")
Generates an trappable error if the Description does not exist.

--
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.

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:Q8*****************@news.indigo.ie...

Access allows all objects, tables, forms, queries, macros, modules, to be documented with common object properties, including Description, Type,
modified and created dates, owner, and some attributes, hidden and
replicable.

I have found the Name, DateCreated and DateUpdated properties of the
document class of the container object for the current database.

Is there a way to access the Description and the Attribures in a similar
way. ??
The description filed appears to be 255characters.

[Allen Browne]

If the table has a description, it is:
? CurrentDb().TableDefs("MyTable").Properties("Descr iption")

For queries, replace TableDefs with QueryDefs

For forms:
?
CurrentDb().Containers("Forms").Documents("MyForm" ).Properties("Description"
)

--
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.

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:gD*****************@news.indigo.ie...

Thanks Allen,
But it that not the description of the field in a table.

I'm looking for the description of the form. or table or query.

Its the one which appears in the database window when the View/Details is
selected from the menu.
Its updated when the user right clicks on the object, selects properties,
and inserts the description.
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...

I don't believe you can get the Description through the Documents
collection.

You can get it through this kind of reference:
?

CurrentDb().TableDefs("MyTable").Fields("MyField") .Properties("Description")

Generates an trappable error if the Description does not exist.
"Gerry Abbott" <pl****@ask.ie> wrote in message
news:Q8*****************@news.indigo.ie...

Access allows all objects, tables, forms, queries, macros, modules, to be documented with common object properties, including Description, Type, modified and created dates, owner, and some attributes, hidden and
replicable.

I have found the Name, DateCreated and DateUpdated properties of the
document class of the container object for the current database.

Is there a way to access the Description and the Attribures in a similar way. ??
The description filed appears to be 255characters.