Hi all, I have the following code in a module
"Sub exeProperties()
Dim db As Database
Dim tbl As TableDef
Dim prp As Property
Dim str As String
Set db = CurrentDb
Set tbl = db!Books
str = ""
For Each prp In tbl.Properties
str = str & prp.Name
str = str & " = " & prp.Value
str = str & " (" & prp.Type & ") "
str = str & prp.Inherited & vbCrLf
Next prp
MsgBox "Books has " & tbl.Properties.Count _
& " Properties: " & vbCrLf & str
End Sub"
but the line "str = str & prp.Inherited & vbCrLf"
is coming back with this error "Compile Error: Method or data member not found" and I suspect I need to add a reference for the .inherited property ?
Can anyone point me in the rigth direction if that is not the case or tell me which reference I need to add in order for this to work ?
Thanks in advance,
Mitch....
"Sub exeProperties()
Dim db As Database
Dim tbl As TableDef
Dim prp As Property
Dim str As String
Set db = CurrentDb
Set tbl = db!Books
str = ""
For Each prp In tbl.Properties
str = str & prp.Name
str = str & " = " & prp.Value
str = str & " (" & prp.Type & ") "
str = str & prp.Inherited & vbCrLf
Next prp
MsgBox "Books has " & tbl.Properties.Count _
& " Properties: " & vbCrLf & str
End Sub"
but the line "str = str & prp.Inherited & vbCrLf"
is coming back with this error "Compile Error: Method or data member not found" and I suspect I need to add a reference for the .inherited property ?
Can anyone point me in the rigth direction if that is not the case or tell me which reference I need to add in order for this to work ?
Thanks in advance,
Mitch....
Last edited:
