Dan Waters
dwaters at usinternet.com
Thu Apr 24 15:07:36 CDT 2008
This code can be used to look for form dates: '-- Get Form Information intCount = 0 Set ctr = CurrentDB.Containers("Forms") DoCmd.SetWarnings False For Each DOC In ctr.Documents intCount = intCount + 1 stg = "INSERT INTO tblExportObjectsList ( ObjectName, ObjectType, LastModifiedDate, DateCreated ) " _ & " VALUES ('" & DOC.Name & "', 2, #" & DOC.LastUpdated & "#, #" & DOC.DateCreated & "#)" DoCmd.RunSQL stg Next DOC DoCmd.SetWarnings True However, this does not work in A2K through A2003. The .LastUpdated value is always the same as the .DateCreated value. Somewhere there is a MSKB article which explains that this is a fallout from the .mdb table structure that was introduced in A2000. But - could someone try this in A2007? Maybe it will work there. The same piece of code can be easily modified for reports and modules. Thanks, Dan -----Original Message----- Subject: [AccessD] Access 2007 Another feature? Folks, I am working on a clients application in Access 2007. I just noticed that when I look at the list of objects, forms in this case, in the database the Date Created and the Date Modified are the same. These dates should not be the same since I have been working on several forms. Is there a setting somewhere to get Date Modified to reflect the data that the form was last modified? Is this another new feature of Access 2007? Doug -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com