Solved

global replace of form name in multiple queries

Posted on 2008-10-14
3
168 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 84

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Omit After Update event 5 45
Why can't I change data in my query? 3 37
Reoccurring Access Query 24 46
Creating a filter on a subform MS access 2010 6 13
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

734 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