Find and Clear unused code

[Lez]

Hey Guys,

Anyone know if it's possible to search and remove any redundant code in an
application?

TIA

Lez

 

[Graham Mandeno]

Hi Lez

Take a look at MZ-Tools 3.0 (http://www.mztools.com/). You'll wonder how
you ever managed without it... and it's FREE!

 

[John Griffiths]

Hey Guys,

Anyone know if it's possible to search and remove any redundant code in an
application?

TIA

Lez

If you load a module press Control-A (or select all)
then press the toolbar button to changed lines in
selection into comments.

Now compile the db on each not found error uncomment
only that element (const, variable, sub, function, ...) and compile
again.

This will slowly reveal dead code.

You can also use common sense to speed up the process.

A start - John

 

[Graham R Seach]

Except it won't report procedures referred to by macros or queries.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[LJG]

Cheers Guys,

That has helped

Lez

Except it won't report procedures referred to by macros or queries.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html