Geek Answers Handbook

MS Access Properties

Where can I find my own list of MS Access properties available through:

CurrentDb.Properties("Property_Name_Here")

For example, I know;

  • AppTitle is available to access the name of the application
  • AppIcon is available to access the path to the icon used for the application

For different versions, I am sure that there are different properties. Are there any version lists? So, for example, MS Access 2003 has these properties ... while MS Access 2007 has these properties ... etc.

+7
vba ms-access
source share
4 answers

I do not believe that there is a list anywhere. Tho, the Properties property is a collection. You can iterate over them and get all related. You will need to make all versions of MS Access that interest you. For further discussion, almost all internal objects, for example. tables, fields, queries, etc. have properties. Field properties are especially useful as you can designate as MS Access links and display the field for the user.

+9
source share

There is a collection of properties:

 Sub ListProps() For i = 0 To CurrentDb.Properties.Count - 1 Debug.Print CurrentDb.Properties(i).Name Next End Sub
+7
source share

It is hard to find such information.

I found a link here for the DAO properties defined for access

+3
source share

Will it be ok? :)

 Option Compare Database Option Explicit Private Sub btnShowDbProps_Click() On Error GoTo Err_btnShowDbProps_Click Dim prp As DAO.Property Dim dbs As Database Dim strProps As String Set dbs = CurrentDb For Each prp In dbs.Properties Dim propval As String propval = "<not defined>" On Error Resume Next propval = CStr(prp.value) If propval = vbNullString Then propval = "<empty>" strProps = strProps & prp.Name & "=" & propval & " (" & PropertyType(prp.Type) & ")" & vbNewLine Debug.Print strProps Next MsgBox strProps Exit_btnShowDbProps_Click: Exit Sub Err_btnShowDbProps_Click: MsgBox Err.Description Resume Exit_btnShowDbProps_Click End Sub Function PropertyType(intType As Integer) As String Select Case intType Case dbBoolean PropertyType = "dbBoolean" Case dbByte PropertyType = "dbByte" Case dbInteger PropertyType = "dbInteger" Case dbLong PropertyType = "dbLong" Case dbCurrency PropertyType = "dbCurrency" Case dbSingle PropertyType = "dbSingle" Case dbDouble PropertyType = "dbDouble" Case dbDate PropertyType = "dbDate" Case dbText PropertyType = "dbText" Case dbLongBinary PropertyType = "dbLongBinary" Case dbMemo PropertyType = "dbMemo" Case dbGUID PropertyType = "dbGUID" Case Else PropertyType = "Unknown:" & intType End Select End Function
+1
source share

More articles:


All Articles