Search invalid forms and reports after design changes in tables

[Nicolae Fieraru]

Hi All,

I am working on an Access 2000 project where it was necessary to rename some
fields in a table or to delete some fields and to recreate new ones.
Now there are many forms and reports which were relying for data from the
fields which don't exist anymore. I wonder if there is a way of finding out
which forms and reports have to be modified, without having to open all the
forms and reports. I found some useful VBA code which is able to search for
a string in queries, using debug.print as output, maybe there is something
similar which can search the forms and reports

Any ideas appreciated

Regards,
Nicolae

[Pieter Linden]

"Nicolae Fieraru" <no****@please.cxm> wrote in message news:<40********@duster.adelaide.on.net>...

Hi All,

I am working on an Access 2000 project where it was necessary to rename some
fields in a table or to delete some fields and to recreate new ones.
Now there are many forms and reports which were relying for data from the
fields which don't exist anymore. I wonder if there is a way of finding out
which forms and reports have to be modified, without having to open all the
forms and reports. I found some useful VBA code which is able to search for
a string in queries, using debug.print as output, maybe there is something
similar which can search the forms and reports

Any ideas appreciated

Regards,
Nicolae

SpeedFerret or FindAndReplace will do it.