John Bartow
john at winhaven.net
Wed Jul 20 09:46:07 CDT 2005
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