List all User Defined Properties

[lameid]

Anyone know of an easy way to list all the User defined properties for an object?

A way would be to check the name of the property against a list of all built-in property names but this seems like a lot of work to make the list and may change with subsequent Access versions. Unless there is a clever way to get at the list of built in properties using VBA, this does not seem viable... Any thoughts?

 

[vbajock]

Try this:

http://www.jkp-ads.com/articles/ObjectLister.asp

 

[lameid]

The ambiguous licensing issue for the dll is enough to stear me clear of it, although on the surface it looks like it is likely functional. Too bad I don't have a full version of VB6.

 

[dhookom]

You can go into any module and View->Object Browser (or press F2). This browser displays properties, constants, events, and methods.

Duane
Hook'D on Access
MS Access MVP

 

[lameid]

Duane,

I am looking for a VBA soltuion (I know how to post in the right forum or at least usually ) as more of a way to do a prelminary mapping of a database for documentation and investigative purposes.

Obviously I can loop through the properties collection of related objects, but I do not see a way to identify the User defined Properties.

At first I was hoping I could say the built in properties have a count of x for an object type so that any properties beyond x-1 would be user definded. What surprised me is the fact that I saw the OrderBy property on some tables and not others. I assume that I sorted the table at some point which caused the table to have that property added.

I think doing this natively in Access is a lost cause. It would be more of a nice to have kind of thing and there are ways to cope manually...

I think it is one of those not solvable issues.

Many thanks to all, for all the suggestions.