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

查看:88
本文介绍了在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.

推荐答案

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

这是一个好方法,因为它快速,免费且完整.

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

  • 查询中的标准SQL ALIAS.
  • 使用表字段的CaptionDescription属性.
  • 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.
  • 如果文档管理器似乎提供了除对象名称之外的所有内容,则它在处理长文件路径时会遇到麻烦.将您的工作移到更靠近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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆