[AccessD] Access 2007 Another feature?

Dan Waters dwaters at usinternet.com
Fri Apr 25 06:56:47 CDT 2008


I certainly would also!

But I was just guessing that you may have wanted a potential way to actually
determine what those dates were.

In A2000 - A2003, the forms and reports are correctly reported in the
database window, but the .LastUpdated property is incorrect.

Also in A2000 - A2003, the database window will show the date you last
compiled for ALL the modules, and since you should compile frequently those
dates are fairly useless.  The .LastUpdated property for modules is also
incorrect.

Apparently in A97, all works that way we would like it to work now!  :-(

Dan

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

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

-- 
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