Looking for Access constants?
Say you're creating fields on a table using VBA and the field collections. You're trying to figure out what the possible values are for the field types. And you've managed to figure out something like the following code.
Dim dbsupdate As Database, wrkDefault As Workspace
Dim tdfUpdate As TableDef, tdfField As Field, prp As Property, idxUpdate As Index
Set dbsupdate = wrkDefault.OpenDatabase(strDatabasePathandName, True)
' Update the Equipment table
Set tdfUpdate = dbsupdate.TableDefs("Equipment")
Set tdfField = .CreateField("eUnitNbr", dbText, 6)
Set tdfField = .Fields("eUnitNbr")
Set prp = tdfField.CreateProperty("Caption", dbText, "Unit #")
Set idxUpdate = .CreateIndex("eUnitNBR")
idxUpdate.Unique = True
But now you're thinking. "Ok, I remembered the dbText constant. How do I find the other constants?" And Access help may or may not work.
In the VBA editor on the menu bar select View >> Object Browser or press F2. Key in the constant you managed to dredge up from the dim recesses of your memory dbText in the appropriate field and hit the Search icon. And now you get the very handy screen as below.