Access custom document property in vba

[cesarone82]

On the document property window I created a custom variable named "DIRMOD".

I'm trying to get the value in it in VBA, but I get a object required error using the following sintax:

Dim als As String


als = ActiveDocument.CustomDocumentProperties("DIRMOD"). Value

What is the correct sintax to get a custom document property value?

[orange]

You may get some insight from the Similar Threads at the bottom of this page.
This Word info may be helpful

[Welshgasman]

Ever thought of Googling?

https://www.devhut.net/access-playin...se-properties/

[cesarone82]

Hi, sorry I tried googling but for some reason I seem unable to make it work, this is my user property (DIRMOD):



If I use CurrentDb.Properties("DIRMOD") I get a property not found error


If I use oCurrentDb.Properties("DIRMOD") I get runtime error 424 object required.

Sorry but I can t figure out, any help appreciated

[cesarone82]

I can confirm that listing db.properies the custom ones are not in the list, for those interested here is the solution:


ms access 2016 - get custom database properties in vba - Stack Overflow

[Welshgasman]

I can confirm that listing db.properies the custom ones are not in the list, for those interested here is the solution:


ms access 2016 - get custom database properties in vba - Stack Overflow

I have only played with properties once before, but that code works for me.
However there was a glaring error with that code in that oCurrentDB was not defined and set?

[orange]

See this Create databaseproperty
My guess is that you used Daniel Pineault's approach with oCurrentDB but have not Dimmed that object.

Your earlier post sounded like you were working with a Word activedocument.