Solved

global replace of form name in multiple queries

Posted on 2008-10-14
3
170 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 250 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 30

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 30

Author Closing Comment

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

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

696 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