Locate string in queries

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brian (Brian_at_discussions.microsoft.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 07:51:04 -0800

When customizing an Access application for various clients, I have an
occasional need to go through my application to find and replace all
occurrences of a string (e.g. Change all references to [User1] field to
[User2] because the structure of a referenced ODBC database has changed). The
VBA part is easy using Search/Replace, but is there a way to search through
the contents of all queries to locate all occurrences of a string?

Right now, I must manually go through all the queries to find/replace the
references.

Relevant Pages

  • FindField function
    ... references to a given string. ... (in tables, forms, mods, queries, etc.) ...
    (microsoft.public.access.forms)
  • Re: Getting file name from the file path error
    ... I checked one users tools - References and it appears that it ... It is part of a code module in an Excel ... end of statement with the As highlighted after the(stFullName As String). ... Sub GetFileNameAs String ...
    (microsoft.public.excel.programming)
  • Re: accessors
    ... mentioned that returning references from functions makes using ... boundaries, but if i did, "string const& nameconst" is functionally ... the same as "string nameconst", so i don't see why i'd have to change ... anything (but if i did, the change does not really affect client code, ...
    (comp.lang.cpp)
  • Re: Importing Excel
    ... Function LastInStr(strSearched As String, strSought As String) As Integer ... Didn't realize you haven't set references yet. ... > named Microsoft Excel and select the box. ...
    (comp.databases.ms-access)
  • Re: Is garbage collection here yet?
    ... I don't consider tcl to be a fully higher-level language. ... Tcl has so many other cool features and such a clean ... As others have answered, Tcl does do ref-counting GC of its values, which works fine for strings as they can't contain circular references and are stateless/immutable. ... Basically, it's hard to distinguish a reference from any other string, which makes it difficult to know when it is safe to delete something. ...
    (comp.lang.tcl)