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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling Access 'form' from other applications 0
Macro to use information in a cell to locate and send files using outlook 0
Cancel button in a form 5
Pass information from form to QUERY CRITERIA 1
extra class objects 1
Access Access Report Works on One Machine but not Another 3
Code accompanying Form 1
Access Need help in making asset history in my current database. 1

Back
Top