Charlotte Foust
cfoust at infostatsystems.com
Wed Jul 20 13:10:46 CDT 2005
I'm not clear on exactly what you want to do with the tool. MZ-Tools will do find and replace, as will the other apps suggested, but beyond that, what do you want it to do? Charlotte Foust -----Original Message----- From: Sad Der [mailto:accessd666 at yahoo.com] Sent: Wednesday, July 20, 2005 9:26 AM To: Access Developers discussion and problem solving Subject: RE: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com