How can I extract the date of last update / modified ?

[Wes1961]

I have a user that generates data and then emails the table to vendors. Sometimes they forget to upadte the data before they email.

When I look at the table view with details I can see the attributes of modified and created. I want to able to extract the modified attribute and use in in a comparison to make sure that the table has a current date.

How can I do this?

 

[drctx]

this should help:

Private Sub Command2_Click()
Dim db As DAO.Database, t As DAO.TableDef
Set db = CurrentDb()
Set t = db.TableDefs("DBNames")

MsgBox "Name: " & t.Name _
& vbCrLf & _
"Last Modified: " & t.LastUpdated

db.Close
End Sub