access-BuiltIn Properties and other...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get the BuiltIn or Custom Properties in ms access with VBA
(dsofile.dll does not work with it)
 
"Andi Mayer" ?????:


(in ms word i'we got it with activedocument.customproperties...etc)
Click to expand...

I had to look also where they are, run this and choose what you like,
but watch for line breaks

Sub test_abdgsjksjksdkj()

Dim i As Long, z As Long
On Error Resume Next
For z = 0 To CurrentDb.Containers("Databases").Documents.Count - 1

For i = 0 To _
CurrentDb.Containers("Databases").Documents(z).Properties.Count - 1
Debug.Print _
CurrentDb.Containers("Databases").Documents(z).Properties(i).name, _
CurrentDb.Containers("Databases").Documents(z).Properties(i).Value
Next i
Next z
End Sub
End Sub
 
Thank you,
Click to expand...
I'we got it with some modifing:

'Custom property
CurrentDb().Containers!Databases.Documents("UserDefined").Properties("MyProperty").Value

'BuiltIn property (TITLE)
CurrentDb().Containers!Databases.Documents("SummaryInfo").Properties("Title").Value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to Save Email and set Custom Properties 0
How to remove attachment in macro or vba code 0
hide access builtin menu and tolbars 1
inheretance is broken - sdprop adminsdholder, builtin container an 0
VBA-How to disable builtin controls 3
xp component needed to open mdb file 2
VBA Syntax 3
How to call PP's builtin commands in VBA 2

Back
Top