If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Where is the DateModified Property?
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 |
#2
|
|||
|
|||
Where is the DateModified Property?
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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Kan D." wrote in message ... 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 |
#3
|
|||
|
|||
Where is the DateModified Property?
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 * Douglas J. Steele wrote: 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. |
Thread Tools | |
Display Modes | |
|
|