?
Solved

global replace of form name in multiple queries

Posted on 2008-10-14
3
Medium Priority
?
178 Views
Last Modified: 2013-11-28
I've inherited a db and would like to change the name of one of the forms that is used to run multiple reports. However, the form name is used in multiple queries. Is there a way to do a global replace of the form name in all affected queries?

Thanks
0
Comment
Question by:Scott Helmers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 22716194
You'll want to use a Find and Replace tool, like the one from Rick Fisher: www.rickworld.com. Access has a builtin F&R, but it won't work with query SQL. MZ-Tools has one as well, but I'm not sure it works on queries either: www.mz-tools.com
0
 
LVL 31

Author Comment

by:Scott Helmers
ID: 22717636
Perfect answer -- Rick Fisher's find and replace did the trick. Funky UI but highly functional code.

I'm also glad to know that I hadn't overlooked a built-in Access function that did this.

Thanks,
Scott
0
 
LVL 31

Author Closing Comment

by:Scott Helmers
ID: 31506068
Terrific answer -- spot on.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question