?
Solved

List of Built In Properties

Posted on 2006-10-31
11
Medium Priority
?
329 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
9 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 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