Results 1 to 2 of 2
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919

    How to find stuff, like table names in queries

    Example: Given a table name, how can one find all references to the table were one in need of changing its name? Easy to find such references in modules, but buried somewhere in a query def escapes me. Or, like in the RecordSource as a report property.

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    db documenter will provide sql, control source and rowsource properties. You would then have to output that to something like Word to use Find tool.
    Or there is code that you can write or find that will do the same. Code seems much more involved to me, but I suppose it could also provide the means for altering the property values.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 03-21-2018, 04:58 AM
  2. If no match after find first record, do stuff
    By boboivan in forum Access
    Replies: 3
    Last Post: 02-26-2016, 04:07 AM
  3. Find similar names in two tables
    By Ruegen in forum Queries
    Replies: 1
    Last Post: 08-17-2014, 07:25 PM
  4. How to find all queries related to a table
    By shanmugamgsn in forum Queries
    Replies: 9
    Last Post: 10-18-2011, 01:14 PM
  5. Quick way to stuff field names into text field
    By kfinpgh in forum Programming
    Replies: 0
    Last Post: 01-04-2007, 01:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums