How do I remove all the obsolete code?

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

For a long time we have not been removing the code when we delete form
buttons, combo boxes etc.,

and so a lot of obsolete VB code has accumulated in our database.



Is there some automatic way to remove all this old code?



Please help, Frank.
 
No, not unless there is some third-party tool. I know that one/some of the
software tools from FMS, Inc. will identify unused code. You might take a
look at their site, http://www.fmsinc.com and see if they have something of
interest.

Larry Linson
Microsoft Access MVP
 
Frank Martin said:
For a long time we have not been removing the code when we delete form
buttons, combo boxes etc.,
and so a lot of obsolete VB code has accumulated in our database.
Is there some automatic way to remove all this old code?
Click to expand...

Any form code which no longer is connected to an object will be in the
Declarations section of the code window. You cannot just grab all the code
and delete it though, as the Declarations section will contain valid code as
well. You can, however delete any Declarations code which is obviously
connected to a control. This is much easier if you used a standard naming
convention for your controls.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top