Solved

List of Built In Properties

Posted on 2006-10-31
11
321 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

830 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