Solved

List of Built In Properties

Posted on 2006-10-31
11
320 Views
Last Modified: 2010-04-06
Where in MS Access Help or elsewhere can I get a list of, and information on, MS Access's built-in properties, such as the Description property of the tabledef object, or the startupform property of the database object?
0
Comment
Question by:Milewskp
  • 5
  • 4
11 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 17843517
Why dont u just go thru the list of properties that can exist?

Public Sub ListProps()

    Dim prp As DAO.Property
   
    On Error Resume Next
   
    For Each prp In CurrentDb.Properties
        Debug.Print prp.Name, prp.Value
    Next prp
End Sub


Or is there more u need
Have u looked in (from main access window)

Tools/Startup
File/Database Properties

to see some of the other properties


0
 
LVL 1

Author Comment

by:Milewskp
ID: 17843649
rocki,
This only shows the properties that exist, for example, if the database doesn't have a startupform, the property won't show up. I am looking for a complete list of all of Access's built-in property
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17843800
ok, I remember seeing somewhere on the MS site, cant remember if its msdn or technet, it listed properties
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 65

Expert Comment

by:rockiroads
ID: 17843802
urm forgot to say, let me see if I can find it
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 17843877
bugger, I typed a post in and got white screen of death

anyways what I said earlier

I found my link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acproAllowFullMenus.asp

Ive given url to one property, use the left hand side to navigate to see others (if u scroll up, u can see the top node - called Properties)
then see from there

there is a lot but should hopefully help u out somewhat
0
 
LVL 1

Author Comment

by:Milewskp
ID: 17873564
rocki,
That's an excellent reference; thanks. But maybe you can help me navigate through it. For instance, if I wanted to know all of the properties for the database object (including AllowFullMenus property), where would i go?
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17974029
Howdo, Ive searched hi and lo and couldnt find a definitive reference

Regarding the link above, I can only think of the painstaking task of going thru and look for words like

"append it to the Properties collection of the Database object."

Database object is the key

Sorry pal, I cant think of another way since I failed to find a definitive list.



0
 
LVL 1

Author Comment

by:Milewskp
ID: 17975001
Hi rocki,
Don't beat yourself up over this too much, your's is the best answer so far, and it's a great general reference to boot.
0
 
LVL 1

Author Comment

by:Milewskp
ID: 18388269
I support giving rocki full points and an A. I was hoping for a better answer, but I shouldn't have waited this long to accept. My apologizes.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question