Cleaning Up Old Code

[Anthony Viscomi]

Is there any utility "out there" that can go through my VBA code and remove
anything that my reference deleted objects?

Thanks!
Anthony

 

[Jeff Conrad]

FMS has a product called "Total Access Analyzer":

http://www.fmsinc.com/Products/analyzer/index.html

Not cheap, but well worth the money if you do
a lot of heavy Access programming.

I'm not sure if it will "remove" code since I have
not used their product, but it will point out problems
just like you mention.

 

[Anthony Viscomi]

Thanks, I've seen this before.

FMS has a product called "Total Access Analyzer":

http://www.fmsinc.com/Products/analyzer/index.html

Not cheap, but well worth the money if you do
a lot of heavy Access programming.

I'm not sure if it will "remove" code since I have
not used their product, but it will point out problems
just like you mention.

 

[John Vinson]

Is there any utility "out there" that can go through my VBA code and remove
anything that my reference deleted objects?

Total Access Analyzer, as Jeff suggests, is very good at this. More
effort on your part but less of a hit on the checkbook would be Find
and Replace or Speed Ferret:

Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com


John W. Vinson[MVP]

 

[Anthony Viscomi]

Thanks John! taking it easy on the checkbook is always a good thing.