MS Access-全局搜索关键字(在查询，表单，报告中) [英] MS Access - GLOBAL search for keyword (in queries, forms, reports)

问题描述

[此问题与Access 2003有关] 我需要在使用其他特定条件(a)的任何地方向查询添加一个附加条件(b)，因此我需要对(a)的发生率进行全局搜索

[This questions pertains to Access 2003] I need to add an additional criteria (b) to a query wherever another specific criteria (a) is being used, so I need to do a global search for incidences of (a)

因此，我可以在VBA代码中进行全局搜索，没问题. 要查询查询，我可以说:

So, I can do a global search in VBA code, no problem. To look in queries, I can say:

SELECT MSysQueries.*
FROM MSysQueries
WHERE (((MSysQueries.Expression) Like "*myCriteriaA*"));

但是，我无法找到一种在表单或报表recordsource属性中查找SQL中出现的情况的方法.

But, I can't figure out a way to find any occurences in SQL within a form or report recordsource property.

我想我可以编写VBA来迭代所有寻找它的对象，但是没有更简单的方法来做到这一点吗? (希望没有求助于第三方插件，除非它免费)

I suppose I could write VBA to iterate all the objects looking for it, but is there no simpler way to do this? (Hopefully without resorting to a 3rd party add-in, unless its free)

推荐答案

Rick Fisher的查找并替换在免费版本中为您提供了两个搜索条件字段.我已经使用该工具大约15年了.有关其他解决方案，请参阅Microsoft Access第三方上的扫描并替换实用程序部分.我的网站上的实用程序，产品，工具，模块等页面.

Rick Fisher's Find and Replace gives you two search criteria fields in the free version. I've been using that tool for probably 15 years now. For other solutions see the Scan and replace utilities section at the Microsoft Access third party utilities, products, tools, modules, etc. page at my website.

这篇关于MS Access-全局搜索关键字(在查询，表单，报告中)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！