Getting LastModified Time for a code "module" (Acc2002)

[Paul Johnston]

I've been trying to use VB.Net 2003 and the
System.Data.OleDb.GetOleDbSchemaTable() routine but I can't bloody find
where this info is.

Has anybody else tried to find/sort their most recent changes as far as
individual codificated Access objects (modules, class modules, forms,
reports, etc.) are concerned? Since the entire VBA project is contained in
one massive binary entry now in one of the System tables, is there anywhere
individual object info is contained?

I'm moving onto something else for now, I guess ...

 

[Graham R Seach]

Paul,

CurrentProject.AllModules("modMyModule").DateModified

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Ju Chao]

Yeah, but don't all the modules have the same "last used" date? just
like the guy said, in Access (ever since 2000) all vba is stored in
one go... therefore modMyModule.datamodified will have the date of the
last saved module or form module, not necessarily that one .. ? (this
is what made all my DB comparision routines dead since 97 !) damn
thing

Dr Ju Chao
Dip Ed psc Honours

 

[Graham R Seach]

Yes, that's true, and it's something I didn't know before.

Oh well. ;-7

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html