?
Solved

List of Built In Properties

Posted on 2006-10-31
11
Medium Priority
?
325 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

764 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