Results 1 to 2 of 2
  1. #1
    bmschaeffer is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    24

    Find and Replace Within a Macro

    I have a large macro with a lot of actions to run reports and export them to a shared drive. I basically need to copy the macro, but make it run a different query/report. Is there any way to do a find and replace to change the query and report name within the macro in one step, opposed to going through all the action lines and changing it? This would save me a lot of time. Thanks in advance.

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    This is just a suggestion, but I would create a VBA Function for this and then just pass the name of the query/report to it. One piece of code - reusable for any of them. If you want, we can help you write it.

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

Similar Threads

  1. Find and Replace
    By Bedsingar in forum Access
    Replies: 1
    Last Post: 08-14-2011, 01:10 PM
  2. Find and replace tabs from data
    By mentose457 in forum Access
    Replies: 9
    Last Post: 12-06-2010, 09:11 AM
  3. Dumb question about find/replace
    By Perplexed in forum Access
    Replies: 11
    Last Post: 08-04-2010, 09:53 AM
  4. Find and Replace Query
    By randolphoralph in forum Queries
    Replies: 4
    Last Post: 03-17-2010, 07:25 AM
  5. Applying a find/replace function
    By Arr in forum Programming
    Replies: 2
    Last Post: 10-12-2009, 12:28 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