Results 1 to 2 of 2
  1. #1
    chris.emery is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2015
    Posts
    1

    Find and Replace in macro code


    I maintain a database that had some big macros which covered a couple of screens using the pre 2010 table-based system. Now they occupy over 20 screens and finding occurrences of a control is very time consuming and potentially inaccurate. What is the best way of searching the code? (This is my first post, thanks in advance). Chris.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I don't use macros, so can not advise specifically on that issue. Are you dealing with a desktop application or web based?

    There may be a few options with desktop:
    (with vba --- and I'm not sure about macros)
    1)
    - you could write some code to document your tables and queries, then
    - you could also write some code to identify every control on every form and report
    - you could create a small data dictionary/repository system to parse your database on startup.

    2)
    -you can search the posts in forum looking for Rick Fisher Find and Replace. I think June7 uses this. It is a commercial product (cost about $50-60 US, if I recall correctly).

    3)
    - you ca research vTools. It is a free product that is mentioned on forums.
    That would give you current info. Depending on the dictionary repository functions, you could query the dictionary to get info.

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

Similar Threads

  1. Code/Macro for Find and Replace with Checkbox
    By mortonsafari in forum Access
    Replies: 3
    Last Post: 07-21-2015, 06:51 PM
  2. Find and Replace in Macro and VB
    By Baldeagle in forum Macros
    Replies: 4
    Last Post: 01-28-2014, 10:32 AM
  3. Find and Replace Macro
    By TrevorM in forum Macros
    Replies: 11
    Last Post: 12-28-2013, 06:11 PM
  4. Replies: 8
    Last Post: 01-17-2012, 02:43 PM
  5. Find and Replace Within a Macro
    By bmschaeffer in forum Access
    Replies: 1
    Last Post: 12-20-2011, 11:27 AM

Tags for this Thread

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