By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,948 Members | 1,559 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,948 IT Pros & Developers. It's quick & easy.

Search invalid forms and reports after design changes in tables

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.