在 Microsoft Access“应用程序"中搜索字段引用 [英] Search for field references within a Microsoft Access "application"

问题描述

我继承了一个 MS Access应用程序"，并希望跟踪对其中一个字段的所有引用.

I have inherited a MS Access "application" and would like to trace all references to one of the fields.

有没有办法搜索字段(所有谷歌搜索都是为了查询表格).

Is there a way to search for the field (all google hits are for querying the table).

注意:我不是在寻找任何 SQL 帮助，我想要类似 Visual Studio 的右键单击 -> 查找所有引用类型的东西.

NOTE: I am not looking for any SQL help, I'd like something like the Visual Studio right-click -> find all references type thing.

推荐答案

1. 转到工具">分析">文档器"
2. 全选"所有类别的项目
3. 在选项下，确保选中代码"(应该是默认值)
4. 运行 Documenter 报告
5. 导出为 .rtf 或其他文本格式
6. 搜索您的字段名称

这是一个很好的方法，因为它快速、免费且完整.

This is a good method because it is fast, free, and complete.

• 查询中的标准 SQL ALIAS.
• 使用表字段的Caption 或Description 属性.

• Standard SQL ALIAS in a query.
• Use of the Caption or Description property of a table field.

• VBA 中从查询对象调用的用户函数.
• 在 VBA 中使用来自控件的 Tag 属性的值.

• a user function in VBA that is called from a query object.
• Use in VBA of the value from a control's Tag property.

• 如果 Documenter 似乎提供了除对象名称之外的所有内容，那么它就无法处理长文件路径.将您的工作重新放置在靠近 C 驱动器的位置，使文件路径更短，然后再次运行 Documenter.
• 当然，如果数据库有指向外部数据的链接，您必须处理这些！如果是 Access 数据库，您可以将报告合并为一个.
• Access Documenter 不会显示通过导航窗格访问的对象描述.对象描述允许您将一些文本附加到对象.它曾经用于提供设计评论很方便，但从 2007 版开始，它几乎没有用了.老实说，我不会担心它，因为它自然而然地不再使用了；但它从记录器中的遗漏是愚蠢和可悲的.

• If the Documenter seems to have provided everything except the object names, then it's having trouble coping with a long file path. Relocate your work closer to the C Drive so the file path is shorter, then run the Documenter again.
• Of course if the database has links to outside data, you must deal with those! If it's an Access database, you can combine the reports into one.
• The Access Documenter won't reveal the Object Description, as accessed through the Navigation Pane. The Object Description allows you to attach a bit of text to an object. It was once handy for providing design comments, but since version 2007 it is practically useless. Honestly I wouldn't worry about it, as it's naturally fallen out of use; but its omission from the Documenter is silly and sad.

这篇关于在 Microsoft Access“应用程序"中搜索字段引用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！