HLRosenberger
asked on
searching Access forms
I need to make a global change to an Access 2007 database. The underlying data source is a linked SQL database.
I need to change all references to a sets of table. I can search the code on the VB side easily enough. What about properties and bound controls on Forms or Report? Is there a way to search for text? I want to search for the table names.
I need to change all references to a sets of table. I can search the code on the VB side easily enough. What about properties and bound controls on Forms or Report? Is there a way to search for text? I want to search for the table names.
There is no builtin method to do this. Most use Rick Fisher's Find & Replace utility (www.rickworld.com) to do this. It can show you all instances of the phrase in every area of Access.
ASKER
that utility did not work for me. IT got some runtime errors.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My apologies. This utility does work well. My initial problem was that I selected for searching tables that were linked. This failed, but I did not want to search the linked tables anyway. If I select just Forms, Reports, Modules and Macros, it works great.
Thanks for your assistance!
Thanks for your assistance!
ASKER
My apologies. This utility does work well. My initial problem was that I selected for searching tables that were linked. This failed, but I did not want to search the linked tables anyway. If I select just Forms, Reports, Modules and Macros, it works great.
Thanks for your assistance!
Thanks for your assistance!
ASKER
My apologies. This utility does work well. My initial problem was that I selected for searching tables that were linked. This failed, but I did not want to search the linked tables anyway. If I select just Forms, Reports, Modules and Macros, it works great.
Thanks for your assistance!
Thanks for your assistance!