在Microsoft Access“应用程序"中搜索字段引用. [英] Search for field references within a Microsoft Access "application"
本文介绍了在Microsoft Access“应用程序"中搜索字段引用.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我已经继承了MS Access应用程序",并希望跟踪对其中一个字段的所有引用.
I have inherited a MS Access "application" and would like to trace all references to one of the fields.
有没有一种搜索字段的方法(所有Google匹配都用于查询表格).
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.
推荐答案
- 转到工具">分析">文档记录器"
- 所有类别中的全选"项目
- 在选项"下,确保选中代码"(应为默认值)
- 运行文档记录器报告
- 导出为.rtf或其他文本格式
- 搜索您的字段名称
这是一个好方法,因为它快速,免费且完整.
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
orDescription
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.
- 如果文档管理器似乎提供了除对象名称之外的所有内容,则它在处理长文件路径时会遇到麻烦.将您的工作移到更靠近C驱动器的位置,以使文件路径更短,然后再次运行Documenter.
- 当然,如果数据库具有指向外部数据的链接,则必须处理这些链接!如果是Access数据库,则可以将报告合并为一个.
- 访问记录器
- 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屋!
查看全文