473,395 Members | 1,393 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

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

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
3 2725
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
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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: gmccallum | last post by:
I am trying to convert the value of a string to a defined enum value such as follows. public enum MyEnum { One, Two }; string MyString = "One"; // or even this is fine string MyString2 =...
3
by: Vivek Sharma | last post by:
Hi, I have created a dropdownlist as a web user control. I am using its multiple instances on the webpage. How do I access the selectedValue of each instance? All the instances have different...
12
by: Phil Certain | last post by:
Hi, I'm trying to do something very simple...or at least it should be. I have created a host page (gen.aspx) and a very simple user control (us.ascx). The corresponding code-behind files are...
2
by: Prabhudhas Peter | last post by:
How to Create an User Defined Property, which stores value for each index of the Combo Box User Control.(each value is related to the item stored in the ComboBox) -- Peter...
3
by: David Davis | last post by:
I cannot get a web user control to validation client-side using a required field validator. It only validates server side. I have a web user control in .net 2.0. I have a single text box on it....
4
by: Peppie | last post by:
I have a (self proclaimed ) very nice and well designed database that organizes my clients, contacts, projects and documents sent to my clients (including a report generator in MS Word). At...
2
by: rn5a | last post by:
Assume that a user control has a TextBox (Page1.ascx) <asp:TextBox ID="txtName" runat="server"/> I am encapsulating the above user control in a ASPX page named Page1.aspx i.e. the ASPX page...
7
by: rodchar | last post by:
hey all, for simplicity's sake i have a single textbox inside a user control. once i drag that user control onto my page is there a way to attach a binding expression to it at runtime? thanks,...
4
by: =?Utf-8?B?UmljaEI=?= | last post by:
I am trying to create a project using the ASP.NET AJAX accordion control. I would like to dynamically add panes to the control with a form template added when the pane is added. I have tried...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.