Access 2007: Creation date of objects and filter question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M Skabialka - 22 Jan 2008 17:18 GMT

1) When using Access 2007 I am able to see the names of all of the tables,
forms, reports, etc over to the left. But how do I see the creation or
modification date of these objects that I could see in Access 2003?

2) When I right-click on a field in a form, I have all sorts of filtering
choices, but how so I filter for everything after an alpha character, e.g. I
want all of the names after "Jones". In Access 2003 I'd filter for

> "Jones"

My only choices involve, begins, ends, contains, equals - there is no longer
a >, <=, etc, and it waon't accept those in the equals choice.

Reply to this Message

Allen Browne - 23 Jan 2008 14:46 GMT

A1. Right-click the nav pane header, and choose:
View By | Details
It's pretty ugly, i.e. you can't see very many objects vertically once the
details are there. You probably want to show the Search Bar.

A2. You can still use Filter By Form if you need.
On the Home tab of the ribbon, Sort & Filter chunk, Advanced.

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.

> 1) When using Access 2007 I am able to see the names of all of the tables,
> forms, reports, etc over to the left. But how do I see the creation or
[quoted text clipped - 6 lines]
> My only choices involve, begins, ends, contains, equals - there is no
> longer a >, <=, etc, and it waon't accept those in the equals choice.

Reply to this Message

M Skabialka - 24 Jan 2008 13:27 GMT

Thanks - this is what I needed.
Sometimes I think MS is trying to "improve" on somethings that works
prefectly well in the first place! <sigh>
Mich

> A1. Right-click the nav pane header, and choose:
> View By | Details
[quoted text clipped - 16 lines]
>> My only choices involve, begins, ends, contains, equals - there is no
>> longer a >, <=, etc, and it waon't accept those in the equals choice.

Reply to this Message