By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Access Object common properties.

P: n/a
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: 01 6104509
Fax:01 601 4716
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.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

Nov 12 '05 #2

P: n/a
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.


Nov 12 '05 #3

P: n/a
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.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.