How to show MS Access query descriptions in 2007 the way they showed in Access 2003

I just upgraded one of my users from MS Office 2003 to 2007 on Windows XP SP3. She was telling me this morning at her office that she has descriptions for all of her Access queries and that in Access 2003 she could see these descriptions alongside the other information about the query, like name, etc. I created a ticket for this issue, and to get her request into written form for the ticket, I googled "can't see query descriptions in access 2007" and found the following post in a forum (See "FORUM POST I FOUND"). I sent this to her and she agreed that it accurately described the problem, but added some comments (see "MY USER'S ADDITIONAL COMMENTS").

My user said that our DBA (who is on vacation right now so I can't talk to her) posted the question on her Access listserv and some DBAs said they could see it the way my user wanted in Access 2007 and others said they could not, but no one seems to know how to get Access 2007 to get it that way. Therefore my question to this group.

FORUM POST I FOUND
In Access 2000/03 I could sort and view my list of queries by the description, which was entered through a dialog box for each query. I cannot find the settings for Nagivation pane that allow me to see the description and sort by like I did in the database window in Access 2000/03..

MY USER'S ADDITIONAL COMMENTS
I think that's an accurate description of the problem. I would add that in Access 2003, query filename, create date, modify date, and description were arranged horizontally and you could sort with a single click on the column header. In Access 2007, they have replaced that arrangement with a left frame (aka the Navigation pane). Create dates, modified dates (and descriptions if they appear), are listed beneath the query filename. To sort, one has to right click on the header for the query list, then click on the sort order desired.
donanderAsked:
Who is Participating?
 
anyoneisSoftware DeveloperCommented:
This problem is described here: http://msmvps.com/blogs/access/archive/2009/05/01/navigation-pane-description-missing-access-2007-sp2.aspx
There is a hotfix available which will fix the problem with the object descriptions showing up when they feel like it, for as long as they feel like. It does not appear, however, that there is any way to sort objects in the Navigation Pane by the description.
David
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you right-click in the Navigation pane (not on an Object, but on a blank section, or on the Title bar) and select View By - Details, the user will be able to see their Descriptions. There are also several Sort By options available when right-clicking.
0
 
donanderAuthor Commented:
I forwarded the comment to the user, then went to her office to check. She showed me that she already has Details view selected but the descriptions don't appear. See attached screen shot.
Access-2007-View-By.JPG
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If the descriptions are available, they'll appear. I just checked it on my install of 2007 and I see them. However, when you convert to a newer format those sorts of things may be lost.

Have your user check to see if the Description is still available. Right click the table/query, and select Object Properties. If there's nothing in the Description box, then they'll have to re-enter that data.
0
 
hnasrCommented:
I agree with LSMConsulting.
Ask your user to select a table and select properties and enter a description then check the view.
0
 
donanderAuthor Commented:
Her is the user's response.

Nada. The descriptions are available but they do not appear unless I right click and choose object properties. I found a query without a description and added one, just to see if the system required that the descriptions be added in Access 2007 in order for them to show. That didn't work either.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
That's not consistent with what I found. I did this, using a query with no existing Description:

1) Right click somewhere in the NavPane or TitleBar and select View By - Details
2) Right click on a Query, select Object Properties
3) Enter a value in the "Description" box in that dialog

After doing that, I saw the value I entered. If your user cannot see it after doing that, then either they are not following the steps outlined above, or they have an issue with their installation of Access/Office.

Your user will NOT see descriptions that may already be existing; they would need to edit the description. In many cases, Access will not transfer over the correct Property in order to show this (a property does not exist until it is created in some cases).
0
 
hnasrCommented:
donander,
Looks like your user is doing his homework correctly.
I tried to reproduce the issue, by creating a new (mdb) database, discription did not show!!!!!.
0
 
donanderAuthor Commented:
My user is very detail oriented. I believe she is doing the procedure correctly. Also, our DBA has seen this symptom on the user's computer and the DBA is even more detail oriented.

I see that hnasr is having the same result as my user. This is EXACTLY what our DBA found when she posted this issue on her Access listserv, which has mostly DBA's on it. About half said "you're crazy! I can see them fine", and the other half said "No, you're crazy. I don't see it at all." Is there some arcane setting in Access 2007 that is preventing this from working?

The install is our standard Office Enterprise 2007 install. She had Office 2003 before so the install was an upgrade.
0
 
donanderAuthor Commented:
To clarify, when I say "This is EXACTLY what our DBA found when she posted this issue on her Access listserv..." what I mean by "this" is the disagreement among experts, not the symptom. Some saw what LSMConsulting saw and some saw what my user and hnasr saw.
0
 
hnasrCommented:
donander,
I actually saw what LSMConsulting is saying. But after his latest comment, I wanted to create a new database and upload.
The new database did not show the details, so I turned to the old database. Even that gobbled the description.!!!!

I was displaying the description using code:
Private Sub Command5_Click()
On Error GoTo myError

    Dim t As TableDefs
    Set t = CurrentDb.TableDefs
    For i = 0 To t.Count - 1
      Debug.Print t(i).Name & ", " & t(i).Properties("Description") ' can modify to append to a table
    Next i
    Beep
    Exit Sub
myError:
    Debug.Print t(i).Name & ", " & "Properties not defined"
    Resume Next
End Sub
0
 
hnasrCommented:
Just to show that a description exists in the display: (details view)

Navigation pane: Show hidden objects.
Table properties: Hidden
You see the description!

Unhide the table, description istill showing
Navigation pane: Uncheck show hidden objects, description disappears.!!!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I have nothing checked in Navigation Options - Display Options. When I select View By - Details, I see the Description that I've entered. I did this with (a) an existing .mdb file, (b) a new .mdb file, (c) an existing .accdb file and (d) a new .accdb file. In each case, when I selected View By - Details, I saw the Description with the table/query. I did not do this via code, since I presume the user is not doing this through code but rather through the interface.

I did not find the behavior that hnasr describes in the latest post. Regardless of what I do with the Hidden property, the Description still remains.

<She had Office 2003 before so the install was an upgrade>

This could be your issue. There have been reports of problems with upgraded versions. I'm using a fresh install of 07 on a vmWare instance, running Windows Vista (and I checked on Windows 7 + Office 2007 with the same results).

If you run the code that hnasr posted, does it return the descriptions as you expect?
0
 
donanderAuthor Commented:
I'm sure the user is doing it via the interface, not using code. For anything involving code, the users ask our DBA to do.

I will try it on a machine with an original install of Office 2007 as opposed to the upgrade and report the results. How would I be able to see the user's queries on the fresh install machine? Would all the queries be contained in a single .mdb file?  My knowledge of Access is limited.

LSMConsulting, can you send a screen shot showing the view where you see the query descriptions so I can show it  to the user and she can verify that is what she is trying to accomplish? I want to make sure we are all talking about the same thing.
0
 
hnasrCommented:
anyoneis's comment did help in fixing the display of description!
0
 
donanderAuthor Commented:
I downloaded the hotfix mentioned in the link anyoneis provided and installed it on the user's computer and it fixed the problem as anyoneis described it would so I will accept that comment as the answer.
0
 
donanderAuthor Commented:
I said the solution was partially complete because the hotfix fixed one of the two problems the user was reporting, but the user is very happy. The partially rating applies only to the hotfix, not to the comment made by anyoneis.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.