How can I determine which forms use a particular macro?

  • Thread starter Lloyd @ Air Car
  • Start date
L

Lloyd @ Air Car

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?
 
K

KARL DEWEY

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.
 
Top