How can I determine which forms use a particular macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access 2000 how can I identify Queries and Macros that are not used by any
Forms or Reports to comfirm that they can safely be deleted?

Also, How can I determine where a particular Query or Macro is used so I can
identify which Forms or Reports will be effceted if I modify the Query or
Macro?
 
TOOLS - ANALYZE - DOCUMENTER
Click on Queries - select all
Click on Macros select all
Click on Forms select all
Click on Reports select all

Click option - select SQL and nothing for everything else.

Click Ok. You can take the resulting file to MS Word and search for the
tables.
 
Back
Top