您如何评论 MS-access 查询? [英] How do you comment an MS-access Query?

问题描述

如何向 MS Access 查询添加评论，以提供对其作用的描述?

How does one add a comment to an MS Access Query, to provide a description of what it does?

一旦添加，如何以编程方式检索此类评论?

Once added, how can one retrieve such comments programmatically?

推荐答案

注意: 用 Access 2003 确认，不知道早期版本.

NOTE: Confirmed with Access 2003, don't know about earlier versions.

对于 MDB 中的查询，您可以在查询设计器中右键单击(在表所在的空白区域中的任何位置)，从上下文菜单中选择属性，然后在描述中输入文本财产.

For a query in an MDB you can right-click in the query designer (anywhere in the empty space where the tables are), select Properties from the context menu, and enter text in the Description property.

您被限制为 256 个字符，但总比没有好.

You're limited to 256 characters, but it's better than nothing.

您可以通过以下方式以编程方式获取描述:

You can get at the description programatically with something like this:

Dim db As Database
Dim qry As QueryDef

Set db = Application.CurrentDb
Set qry = db.QueryDefs("myQuery")

Debug.Print qry.Properties("Description")

这篇关于您如何评论 MS-access 查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！