Solved

List of Built In Properties

Posted on 2006-10-31
11
319 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
 
LVL 65

Expert Comment

by:rockiroads
ID: 17843802
urm forgot to say, let me see if I can find it
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

948 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now