Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    This is probably very dangerous if it exists, but I have inherited a database with several reports where a designated level of hierarchy is "hard coded" into the queries as selection criteria and other places. Is there a way to replace all occurences of a string (e.g. "Region") with a replacement string ("Division") in all queries, reports, forms and in the VBA code at one time?

    Thanks for your ideas.

    Ken

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Download and install the utility Find and Replace for Microsoft Access from Rick Fisher.
    It's not free, but you can try it out without cost for thirty days. This utility is well worth its modest price, by the way.

    Find and Replace lets you replace all occurrences of a string throughout the database.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Thanks, I'll give it a try.

    [quote name='HansV' post='776478' date='22-May-2009 12:52']Download and install the utility Find and Replace for Microsoft Access from Rick Fisher.
    It's not free, but you can try it out without cost for thirty days. This utility is well worth its modest price, by the way.

    Find and Replace lets you replace all occurrences of a string throughout the database.[/quote]

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    "Find and Replace" is my utility of choice also. "Speed Ferret" is another similiar utility; it has a good reputation (I've never used it personally), but it is more expensive.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Appologies for gate crashing on the post, but what does the third party search and find software do that the normal Access find and replace wont't do? Thanks

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Access 2000 and later have a Name AutoCorrect feature but it's known to cause many problems: it slows down Access considerably, it makes reports lose their page settings and it isn't very reliable either. So it's best to turn it off.

    The Visual Basic Editor has an excellent replace feature that can work across the entire database, but it is limited to VBA code, it doesn't affect the design of database objects.

    The Find and Replace add-in lets you search for and replace any string of text in the design of tables, queries, forms, reports, macros, pages *and* in VBA code. You can specify precisely which objects to include. So it's much more powerful.
    The paid version has some additional features such as a cross-reference tool that shows where database objects are used.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •