Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Macros / January 2006

Tip: Looking for answers? Try searching our database.

Inactive Macros

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Candyman - 31 Jan 2006 17:13 GMT
I want to clean up my db. How do I tell what macros are no longer used?

Jerry Whittle - 31 Jan 2006 17:37 GMT
The registered verion of Rich Fisher's Find and Replace has a cross-reference
report which can find orphaned queries, modules, macros, and other objects.
It's a bargin for $37.

http://www.rickworld.com/
Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I want to clean up my db. How do I tell what macros are no longer used?
>  
KARL DEWEY - 31 Jan 2006 20:58 GMT
You might use the Documentor.   It is more work.

Click on TOOLS - Analyze - Documentor.  This opens another window.

Click on Queries and select all.  Click on Options and select SQL and
Nothing for everything else. Click OK.
Click on Form and select all.  Click on Options and select Properties and
Names and Properties. Click OK.
Click on Reports and select all.  Click on Options and select Properties and
Names and Properties. Click OK.

Run.  Save to Word using Office Links icon on the tool bar and search Word
for the macro name.

> The registered verion of Rich Fisher's Find and Replace has a cross-reference
> report which can find orphaned queries, modules, macros, and other objects.
[quoted text clipped - 4 lines]
> > I want to clean up my db. How do I tell what macros are no longer used?
> >  
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.