Access 2007: Creation date of objects and filter question

M

M Skabialka

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

Allen Browne

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.
 
M

M Skabialka

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top