• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Objects, Properties, Methods,... > Properties Introduced with Access 20...

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


					  


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint