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

How to get user defined property value using VBA in .ADPs?

P: n/a
Hi All,

This works for .MDBs:

?Currentdb.Containers!Databases.Documents!UserDefi ned.Properties("<YourPrope
rtyNameHere>").Value

How to get user defined property for .adp?

Thanks,
Shamil
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Apr 14 2005, 02:45 pm, "Shamil Salakhetdinov" <sh****@users.mns.ru>
wrote in news:11***************@x-files.mns.ru:
Hi All,

This works for .MDBs:

?Currentdb.Containers!Databases.Documents!UserDefi ned.Properties("<Your
Prope rtyNameHere>").Value

How to get user defined property for .adp?


Looks like you cannot. In Access 2002, go to VBA Help, type "database
properties" in the Answer Wizard box, get this:

....
Note The Database properties of a Microsoft Access project (.adp) are not
available using Visual Basic.
....

--
remove a 9 to reply by email
Nov 13 '05 #2

P: n/a
That's a pity but thanks, anyway, Dmitry!

Now, that's a challenge to find a way how to read these properties in .adp?
:)

I guess there should a way to read them because these are similar to
..CustomDocumentProperties of MS Word doc and MS Excel workbook and other VBA
enabled MS Office apps/documents. So the general idea of these properties
was too keep additional user-defined attributes/properties within Word
document, Excel workbook, MS Access project (.adp/.mdb),... -
strange MS didn't make available a common interface to handle
these properties from

Application.<SomethingActiveCommonToAllOfficeApps> ...

object? Will that be available in the next MS Office version?
Somebody from MS here - any ideas?

Shamil

"Dimitri Furman" <df*****@cloud99.net> wrote in message
news:Xn****************************@127.0.0.1...
On Apr 14 2005, 02:45 pm, "Shamil Salakhetdinov" <sh****@users.mns.ru>
wrote in news:11***************@x-files.mns.ru:
Hi All,

This works for .MDBs:

?Currentdb.Containers!Databases.Documents!UserDefi ned.Properties("<Your
Prope rtyNameHere>").Value

How to get user defined property for .adp?
Looks like you cannot. In Access 2002, go to VBA Help, type "database
properties" in the Answer Wizard box, get this:

...
Note The Database properties of a Microsoft Access project (.adp) are

not available using Visual Basic.
...

--
remove a 9 to reply by email

Nov 13 '05 #3

P: n/a
"Shamil Salakhetdinov" <sh****@users.mns.ru> wrote in
news:11*************@x-files.mns.ru:
I guess there should a way to read them because these are similar
to .CustomDocumentProperties of MS Word doc and MS Excel workbook
and other VBA enabled MS Office apps/documents. So the general
idea of these properties was too keep additional user-defined
attributes/properties within Word document, Excel workbook, MS
Access project (.adp/.mdb),... - strange MS didn't make available
a common interface to handle these properties from


This is the result of the irrational fear of Jet that is reflected
in the whole justification for ADPs. They re-invent the wheel
(imperfectly, as you've discovered) to avoid something that
wasn't really a problem in the first place.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.