Where is the DateModified Property?

[Kan D.]

In Access 2003, when I programmatically refer to an objects "LastUpdated"
property, it returns the same value for "DateCreated".

THIS IS INCORRECT

And when I try this...

====
dim accObj as AccessObject
dim myDate as string

for each accObj in CurrentProject.AllForms

mydate = accObj.DateModified

next accObj
====

.... It returns the date I'm looking for.... The MODIFIED date.

BUT What is the MODIFIED date for Tables and Queries? There's no such thing
as CurrentProject.AllTables, or CurrentProject.AllQueries

Please Help...

Thank you

 

[Douglas J. Steele]

It's been broken ever since Access 2000 introduced the concept of
"monolithic save" (i.e.: the entire database gets saved each time, not just
specific objects within it).

The AllTables and AllQueries collections are part of CurrentData, not
CurrentProject.

 

[strive4peace]

Thanks, Doug!

I wondered why that happened -- I have some code that worked in 97 and
now the Date Updated isn't right anymore...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*