[AccessD] Retrieve VBA Code in a form, module, class, report

Thnx, for the replies!

Charlotte....MZ-Tools we've got that one. Is it
possible to do what i described below?

SD

--- Charlotte Foust <cfoust at infostatsystems.com>
wrote:

> Or MZ-Tools 3.0 (free).  http://www.mztools.com 
> 
> Charlotte Foust
> 
> 
> -----Original Message-----
> From: John Bartow [mailto:john at winhaven.net] 
> Sent: Wednesday, July 20, 2005 7:46 AM
> To: 'Access Developers discussion and problem
> solving'
> Subject: RE: [AccessD] Retrieve VBA Code in a form,
> module, class,
> report
> 
> 
> Agree. Another is Speed Ferret 
> http://www.speedferret.com/ 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On
> Behalf Of Heenan,
> Lambert
> Sent: Wednesday, July 20, 2005 9:02 AM
> To: 'Access Developers discussion and problem
> solving'
> Cc: 'Sad Der'
> Subject: RE: [AccessD] Retrieve VBA Code in a form,
> module, class,
> report
> 
> Well you are going to have to work with the
> HasModule and Module
> properties of forms and reports. 
> 
> But first you should go back to the bean counters
> and tell them that for
> the cost of your development time they could
> purchase a copy of Rick
> Fisher's Find and Replace (just $37 for the Access
> 2000 and greater
> version, my preferred tool -
> http://www.rickworld.com) every hour or so,
> or Total Access Analyzer  every few hours. There is
> just no point
> reinventing the wheel when others before us have
> already done such a
> good job.
> 
> Lambert
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On
> Behalf Of Sad Der
> Sent: Wednesday, July 20, 2005 9:42 AM
> To: Acces User Group
> Subject: [AccessD] Retrieve VBA Code in a form,
> module, class, report
> 
> 
> Hi group,
> 
> We've got a large Access database 150+ tables, 80+
> forms and 175+
> reports. Anyway I think it's very big.
> 
> I just found the AutoCorrect function and we've got
> a big change comming
> up.
> 
> What I want is to build a small app that checks all
> code in the
> application for any changes logged to the table
> "Name AutoCorrect Log". 
> 
> My Question: How can I retrieve the VBA code in a
> form, report, module
> and/or class?
> 
> SD
> 
> PS: Yes, I know Total Access Analyzer can do the job
> but the fuckers
> here rather spend ?10.000 then ?1.000 for the
> application.
> 
> 
> 		
> __________________________________
> Yahoo! Mail for Mobile
> Take Yahoo! Mail with you! Check email on your
> mobile phone. 
> http://mobile.yahoo.com/learn/mail
> --
> 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
> 



		
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs