Finding all references to a field

M

Microsoft

I've inherited a rather large access database.

I've been asked to change a field size (3 decimal positions instead of the
current 2).

I know how to find every place that field is used in code (project-wide
"find"), but is there an easy way that I can find every place that field is
used in a query, form, and report?

Any help is appreciated.

Dave
 
L

Les

Dave,
This is probably not the most high-tech way, but it
works. Go into Tools, Analyze, Documenter. Select all
your queries, forms, etc. Set any options that you want.
Then click ok. It creates a report for you. You can then
go to File, Output to, and save it as an rtf format file.
You can then open this file and use find command with your
editor.
 

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

Top