none
What does “Clean Project” do? RRS feed

  • Question

  • I just noticed in the VBE File Menu the item “Clean Project”. I can’t find any documentation thereon.

    What does it do?


    peter n roth - http://PNR1.com, Maybe some useful stuff

    Sunday, April 9, 2017 8:33 PM

Answers

  • This is not a native command.  You must have an add-in installed and would have to check the documentation associated with it.

    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    • Marked as answer by Peter N Roth Monday, April 10, 2017 12:45 AM
    Sunday, April 9, 2017 10:06 PM
  • Hi Peter,

    What happens if you click on it? I get a Save As dialog box, and from what I can tell, it commits all unsaved changes to the project code.

    Just my 2 cents...

    • Marked as answer by Peter N Roth Monday, April 10, 2017 12:46 AM
    Sunday, April 9, 2017 10:36 PM
  • Do you have Mz-Tools installed?  If so, could it be: https://www.mztools.com/v8/onlinehelp/index.html?clean_project.htm ?

     

    I've seen mention of this type of code cleanup before, but always relative to Excel files, never Access.  Even the help file is referring to userforms and xlsm files (all Excel stuff).  I'm truly not sure it applies to Access and would definitely backup my db before trying it out in Access, or any non-Excel app.

     

    You could always contact Carlos and ask.  He's very good for that type of thing.  Very receptive to comments, input, ...  Truly a nice guys in my experience.


    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net



    Sunday, April 9, 2017 11:19 PM

All replies

  • This is not a native command.  You must have an add-in installed and would have to check the documentation associated with it.

    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    • Marked as answer by Peter N Roth Monday, April 10, 2017 12:45 AM
    Sunday, April 9, 2017 10:06 PM
  • Hi Peter,

    What happens if you click on it? I get a Save As dialog box, and from what I can tell, it commits all unsaved changes to the project code.

    Just my 2 cents...

    • Marked as answer by Peter N Roth Monday, April 10, 2017 12:46 AM
    Sunday, April 9, 2017 10:36 PM
  • Do you have Mz-Tools installed?  If so, could it be: https://www.mztools.com/v8/onlinehelp/index.html?clean_project.htm ?

     

    I've seen mention of this type of code cleanup before, but always relative to Excel files, never Access.  Even the help file is referring to userforms and xlsm files (all Excel stuff).  I'm truly not sure it applies to Access and would definitely backup my db before trying it out in Access, or any non-Excel app.

     

    You could always contact Carlos and ask.  He's very good for that type of thing.  Very receptive to comments, input, ...  Truly a nice guys in my experience.


    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net



    Sunday, April 9, 2017 11:19 PM
  • Daniel is correct – it is an comes from MZTools add-in.

    It works in Access as well as the other Microsoft Office software.

    Clicked on it, and it did what the documentation says.

    Since MZTools is free, this looks like a good way to salvage projects.


    peter n roth - http://PNR1.com, Maybe some useful stuff

    Monday, April 10, 2017 12:49 AM