[AccessD] Access 2007 Another feature?

Doug Murphy dw-murphy at cox.net
Thu Apr 24 19:34:04 CDT 2008


Thanks Dan, but I'd like to be able to just look at the file properties and
see the modified date as in previous versions.   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Thursday, April 24, 2008 1:08 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 Another feature?

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list