[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