By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,928 Members | 1,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,928 IT Pros & Developers. It's quick & easy.

How to add comments / documentation

P: n/a
How can I add comments / documentation to an Access database, so that the
next person programming the database will understand what s/he is looking
at?

For example, I might have a select query, where one of the columns specifies
that TransActionCode = 1 or 3 or 5 or 8. How can I leave a comment "This
selects only West Coast transactions"?

(I know how to comment VB code. That is not what I am asking about here)

Thanks!
Alex
Dec 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 6 Dec 2006 14:05:58 -0800, "Alex Chun" <ac***@nospam.u.washington.edu>
wrote:
>How can I add comments / documentation to an Access database, so that the
next person programming the database will understand what s/he is looking
at?

For example, I might have a select query, where one of the columns specifies
that TransActionCode = 1 or 3 or 5 or 8. How can I leave a comment "This
selects only West Coast transactions"?

(I know how to comment VB code. That is not what I am asking about here)

Thanks!
Alex
Each database object has a "Description" property which can be used for this
purpose.

Highlight the required object in the database window and then select
"Properties" from the view menu. Enter your description in the form provided.

From the View menu select "Details". The description you have entered will now
show next to the object name in the database window.

Wayne Gillespie
Gosford NSW Australia
Dec 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.