Sorry for the unplanned hiatus…

… but I’ve been running on overdrive for the last month or so, with no vacation or slow down in sight. When I finally sit down to unwind, it’s already past midnight and I’m a walking zombie. Sigh. At least I’ve been able to follow up on the comments. I’ll try to write a couple of more…


New Field List Task Pane

Another addition to Access 2007 is a new version of the old Field List dialog/toolbar. Besides retaining the old functionality of adding fields based on the record souce, the new task pane adds a couple of new features. For starters, you can now see which table are the fields coming from. Instead of a plain…

3

Access 2007 Beta 2 Misconception #2 – Ribbons morph completely depending on context

Another misconception that I read is regarding the new Ribbon interface: some people apparently are expecting the tabs on the ribbon to change completly as the context changes. This is very untrue: each of the tabs in the ribbon are pretty much fixed (I’m sure that there is the odd exception somewhere, but this is…

1

Totals Row

Another new feature for datasheets in the Totals Row. At the bottom of any datasheet view, one can opt to show a row that will do a number of canned aggregation formulas applied to each column, independently. You can see it in action here, where the # of items is shown as “8”. Depending on…

1

Access 2007 Beta 2 Misconception #1 – ADPs are gone

I’ve heard this one already from multiple people, so it’s worth dispelling it: ADPs are not gone from Access. Here’s how to create one: Boot Access; Click on the “Blank Database” button in the middle of the screen (under the “New Blank Database” section); On the right side of the screen, right by the name…