لطفا منتظر باشید ...
Properties Introduced with Access 2002 and Access 2003
In addition to the properties listed as new to Access 2002, two other properties are worth mentioning. They are the DateCreated and DateModified properties. They are available for all Access objects. Here's an example that shows the use of these properties with the AllTables collection:Public Sub GetDates()
'Declare looping variable
Dim vnt As Variant
'Loop through each table in the database
'referenced by the CurrentData object
With CurrentData
For Each vnt In .AllTables
'Print the name, date created, and the date the table was last modified
Debug.Print vnt.Name & ", " & _
vnt.DateCreated & ", " & _
vnt.DateModified
Next vnt
End With
End Sub
This code loops through each table stored in the database referenced by the CurrentData object. The name, creation date, and last modification data are all printed to the Immediate window.
