Results 1 to 3 of 3
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    find & change


    Hi all. Using ms access 2010. I've search the internet with no avail. Asked this question in another forum but wanted to see if I got any other suggestions. Is there a
    vba code to search and change all default values in tables or criteria in
    queries from one word or number to another word or number at the same time? Ex.
    I would like to search if a default value is = to "odd" change to "even" or
    criteria in a number in a query = 213 change to 214. I have several tables and
    queries and don't know which contain the words or values need to change and it
    would be very time consuming design viewing all the objects to find them. Thank
    you

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,619
    Need third-party software. I use Rick Fisher's Find and Replace. Cost about $50. Saved my sanity a few times.

    Or you could write your own Add-in program. I recommend just buying Fisher's.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Here is a link to Rick Fisher's Find and Replace (30 day trial - Registration cost is $37 per copy)
    http://www.rickworld.com/products.html

    Also a link to V-Tools
    http://www.skrol29.com/us/vtools.php

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

Similar Threads

  1. Change Change FormHeader Color
    By burrina in forum Forms
    Replies: 4
    Last Post: 12-19-2012, 08:18 PM
  2. Replies: 1
    Last Post: 11-30-2012, 05:57 AM
  3. I can't find the bug. Please help
    By sharVyn in forum Programming
    Replies: 5
    Last Post: 08-27-2012, 03:39 PM
  4. Replies: 3
    Last Post: 07-20-2012, 11:41 AM
  5. Find a SUM
    By jcsports31 in forum Access
    Replies: 8
    Last Post: 09-14-2010, 10:07 AM

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