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

Charlotte Foust cfoust at infostatsystems.com
Wed Jul 20 10:19:34 CDT 2005


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



More information about the AccessD mailing list