• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

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.    
0
HLRosenberger
Asked:
HLRosenberger
  • 4
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
 
HLRosenbergerAuthor Commented:
that utility did not work for me.  IT got some runtime errors.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Rick Fisher's Find and Replace utility is used by countless thousands of users every day, on every conceivable platform, and it works very well. If you had issues installing it, I'm sure we could have helped with it had you posted back here.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
HLRosenbergerAuthor Commented:
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!
0
 
HLRosenbergerAuthor Commented:
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!
0
 
HLRosenbergerAuthor Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now