List of MS Access properties available through CurrentDB.Properties
By Vishal Monpara | December 15, 2009 | 4 Comments
Category: MS Access Tags: currentdb, properties
CurrentDB.Properties is nothing but a collection. If you can iterate through a collection, you will be able to get the list of all the properties. Code to iterate through all properties is
Dim i As Integer For i = 0 To CurrentDb.Properties.count - 1 Debug.Print CurrentDb.Properties(i).Name Next
It gave me following list of properties.
Name
Connect
Transactions
Updatable
CollatingOrder
QueryTimeout
Version
RecordsAffected
ReplicaID
DesignMasterID
Connection
ANSI Query Mode
Themed Form Controls
AccessVersion
Build
ProjVer
StartUpForm
StartUpShowDBWindow
StartUpShowStatusBar
AllowShortcutMenus
AllowFullMenus
AllowBuiltInToolbars
AllowToolbarChanges
AllowSpecialKeys
UseAppIconForFrmRpt
Track Name AutoCorrect Info
Perform Name AutoCorrect
AppTitle
AppIcon
I don’t know the data types of the these properties but I put it for quick reference.
4 thoughts on “List of MS Access properties available through CurrentDB.Properties”
so you can get types too
Sub testCodeDBProperties()
On Error Resume Next
Dim prop As Variant
For Each prop In CodeDb.Properties
Debug.Print prop.name & “: ” & prop & ” type: ” & VarType(prop)
Next prop
End Sub
type names: http://www.java2s.com/Code/VBA-Excel-Access-Word/Data-Type/ValuesreturnedbytheVarTypefunction.htm
Sub prtyEnum()
Dim pr As Property
For Each pr In CurrentDb.Properties
Debug.Print pr.Name
Next
End Sub
I think that there are other Properties which were not enumerated. For example:
Auto Compact – boolean. Perform compact when the database is closed.
AllowBypassKey – boolean. Allow you to stop the AutoStar macro with Shift when starting the database.
Dror
Pingback: Vishal Monpara’s Blog » Change MS Access application title and icon using VBA