Navigation Pane Entries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wes - 31 Mar 2007 02:06 GMT

My Access 07 navigation pane includes the name of the object (Query, Table)
and also the date created and last modified. How can I get it to just show
the name and not show the dates?

By the way, even after I modify a query it doesn't seem to change the 'last
modified' date.

Wes

Reply to this Message

Allen Browne - 31 Mar 2007 03:13 GMT

To show the names only in the Navigation pane, right-click the top of the
Nav Pane and choose:
View By | List

How are you modifying the query, Wes? I just tested it, and the modified
date/time property updated correctly when changed through the interface. (If
you change the SQL property of the QueryDef in code, the property is
updated, though the update is not displayed immediately.)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> My Access 07 navigation pane includes the name of the object (Query,
> Table)
[quoted text clipped - 6 lines]
>
> Wes

Reply to this Message

Wes - 31 Mar 2007 06:48 GMT

Thanks Allen - exactly what I needed. I just couldn't find it.

As for changes appearing I think that minor changes to a report format don't
"count" but generally if I make changesI now see they do appear.

Again - thanks.

Wes

> To show the names only in the Navigation pane, right-click the top of the
> Nav Pane and choose:
[quoted text clipped - 15 lines]
> >
> > Wes

Reply to this Message