grabbing CustomDocumentProperties

[Randall Arnold]

I have set up several custom properties in my Access database. I want to
pull these values into certain forms. I know how to do this in Excel and
Word using ThisWorkbook and ThisDocument, but I can't find the corresponding
object for Access.

Does anyone know this?

Thanks,

Randall Arnold

 

[Marshall Barton]

I have set up several custom properties in my Access database. I want to
pull these values into certain forms. I know how to do this in Excel and
Word using ThisWorkbook and ThisDocument, but I can't find the corresponding
object for Access.

That dependes on which Container and which Document you
created the properties in. If you're talking about the ones
You can set in the Database Properties list, the the
Container is Databases and the Document is UserDefined.
E.g.

CurrentDb.Containers!Databases.Documents!UserDefined.Properties("Version")

There are many other Containers and Documents where you can
create custom properties, so, if the above doesn't find what
you want, you should read up on Containers and Documents and
play around with creating and retrieving custom properties.

 

[Randall Arnold]

That was it! Beautiful! I couldn't find anything anywhere in Help or
Internet searches that provided that info. Many thanks, Marshall!

Randall Arnold