How do you comment an MS-access Query?

ms-access ms-office
Varun Mahajan picture Varun Mahajan · Oct 31, 2008 · Viewed 138k times · Source

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?

Answer

Dan picture Dan · Jan 22, 2015

I decided to add a condition to the Where Clause that always evaluates true but allows the coder to find your comment.

Select
   ...
From
   ...
Where
   ....
   And "Comment: FYI, Access doesn't support normal comments!"<>""

The last line always evaluates to true so it doesn't affect the data returned but allows you to leave a comment for the next guy.

Related questions

Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb

It has been a good number of years since I did some programming with Classic ASP and Microsoft Access where we used "Microsoft.Jet.Oledb" driver to access and display the data. I have been asked to do some work …

Read More
“User-defined type not defined” error in VB in Access 2007

I'm receiving a compile error on the following line of code: Dim oXL As Excel.Application The code is in VB in MS Access 2007. The line above is the beginning of a segment to generate an MS Excel file. The …

Read More
How to display record data in a table in MS Access Form

I am working in Offiice Access on a form. I notice that there are not a lot of controls available to use but I have a requirement to display data in a table like structure(not listbox or combobox). How …

Read More