Third Of Five - just another voice in the Collective

Currently talking about Access 2007 and other random topics...

Well, I'm back (and moving)

After a long hiatus, I'm back to blogging.And I also decided to move my blog elsewhere. Please do...

Author: ThirdOfFive Date: 07/04/2008

All good things...

I have decided to pursue other interests and will no longer be able to maintain this blog. It was a...

Author: ThirdOfFive Date: 10/24/2006

Access 2007's Improved Command Buttons

Up until this point, Access has supported command buttons with text or a picture, but never both at...

Author: ThirdOfFive Date: 10/19/2006

The New Import/Export Specifications UI

As I previously mentioned, we are now exposing Import/Export Specifications (Imex Specs) in the OM...

Author: ThirdOfFive Date: 10/17/2006

Customizing the Office Button Menu (aka File Menu) and No-Ribbon Custom Solutions

Even though most of the information on how to customize the Ribbon in Access 2007 is already out,...

Author: ThirdOfFive Date: 10/13/2006

The New Import/Export Specification OM

In previous versions of Access (such as Access 2003), you can save the steps from an import or...

Author: ThirdOfFive Date: 10/12/2006

Changing Default Control and Form/Report Settings

This is one of those features that almost nobody knows about because it isn't very discoverable. In...

Author: ThirdOfFive Date: 10/10/2006

The New Access 2007 Switchboards

Now that Access 2007 Beta 2 Technical Refresh (B2TR) is out, you will notice that we changed the...

Author: ThirdOfFive Date: 10/05/2006

Quick Trick: Copying Embedded Macros from one Property to another

Now that we spent all this time talking about templates, how about we put to use something we...

Author: ThirdOfFive Date: 09/28/2006

Templates: How to create your own

Now that we discussed extensively all about templates, we can talk about how this all this can be...

Author: ThirdOfFive Date: 09/27/2006

Templates: Programmability

Now that we talked about what Access 2007 templates are made of and how Access makes use of them to...

Author: ThirdOfFive Date: 09/21/2006

In case you are having issues installing Office 2007 Beta 2 Techinical Refresh (B2TR)

For troubleshooting Office 2007 Beta 2 Technical Refresh (B2TR) installs, you might want to check...

Author: ThirdOfFive Date: 09/20/2006

Templates: SharePoint comes into Play

When you go create your new database from a template using Access 2007, you will notice a checkbox...

Author: ThirdOfFive Date: 09/19/2006

Office 2007 Beta 2 Technical Refresh (B2TR) is out

I haven't seen any news about this yet, but it's already available for download. Check out this post...

Author: ThirdOfFive Date: 09/14/2006

Templates: The Template Store

No, that is not a new franchise opening near you. So far we talked a lot about what templates are,...

Author: ThirdOfFive Date: 09/14/2006

Templates: The Instantiation Process

As we’ve seen in the previous posts, Access 2007 templates are not really database files per se, but...

Author: ThirdOfFive Date: 09/12/2006

Templates: Where did the embedded macros go?

Now that we saw how macros, queries, forms, reports and tables are persisted in templates, we can...

Author: ThirdOfFive Date: 09/07/2006

Templates: Access Objects parts

Last week I talked about how the template core data is laid out. Now, I’ll focus on the actual...

Author: ThirdOfFive Date: 09/05/2006

Templates: Quick Overview of SaveAsText and LoadFromText (aka let’s get boring again)

Before we dive into the way the Access Objects are persisted in the Access 2007 template files, I...

Author: ThirdOfFive Date: 08/31/2006

Happy Birthday

It would be a shame to miss noting this blog's first birthday. Or at least it's first post's first...

Author: ThirdOfFive Date: 08/31/2006

Templates: The Meat of the ACCDT Template Files

In my previous post, we cracked open an Access 2007 template file. For this post, I’d like to delve...

Author: ThirdOfFive Date: 08/28/2006

Templates: Cracking open ACCDT files

(This post was pre-recorded. I'll follow up on any comments when I'm back). Since the Access 2007...

Author: ThirdOfFive Date: 08/24/2006

Templates: Quick overview of Open XML files (aka boring as hell post)

(This post was pre-recorded. I'll follow up on any comments when I'm back). This is really a brief...

Author: ThirdOfFive Date: 08/22/2006

How to Determine if your Solution is in Disabled Mode

I was asked this question the other day and thought it's worth answering right away, and in public':...

Author: ThirdOfFive Date: 08/16/2006

Templates: Access 2007

Perhaps one of the most significant improvements to Access 2007 when it comes to ramping up to using...

Author: ThirdOfFive Date: 08/15/2006

Customizing the Access Ribbon

As you probably saw in Erik's post, making a completly custom Ribbon is basically an XML exercise...

Author: ThirdOfFive Date: 08/11/2006

In case you'd like to get some free quasi-training videos, Microsoft is making available some of the...

Author: ThirdOfFive Date: 08/08/2006

Append Only (aka Column History)

In Access 2007, memo fields have now the capability of collecting change history. When you change an...

Author: ThirdOfFive Date: 08/01/2006

Access 2007 Beta 2 Misconception #3 - Somebody else will report this bug

This is something that I have been guilty of in a number of ocasions. If you run into any bugs or...

Author: ThirdOfFive Date: 07/18/2006

Trying out Access 2007 without installing anything

This is sort of old new by now, but in case you didn't give it a try yet (or couldn't because...

Author: ThirdOfFive Date: 07/11/2006

New Access to SQL Server Migration tool

A new tool is available for Access to SQL Server migrations. The SQL Server Migration Assistant for...

Author: ThirdOfFive Date: 07/05/2006

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

Author: ThirdOfFive Date: 06/29/2006

New Field List Task Pane

Another addition to Access 2007 is a new version of the old Field List dialog/toolbar. Besides...

Author: ThirdOfFive Date: 06/13/2006

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

Author: ThirdOfFive Date: 06/08/2006

Totals Row

Another new feature for datasheets in the Totals Row. At the bottom of any datasheet view, one can...

Author: ThirdOfFive Date: 06/06/2006

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

Author: ThirdOfFive Date: 06/01/2006

Add New Field

A very nice feature in Access 2007 is the new "Add New Field" column in table datasheet view. You...

Author: ThirdOfFive Date: 05/30/2006

Office 2007 Beta 2 is out...

As reported here and here (for now :) ). This build is leaps and bounds faster and better than Beta...

Author: ThirdOfFive Date: 05/23/2006

FilterOnLoad/OrderByOnLoad vs. FilterOn/OrderByOn

(From the Minor Feature Series :) ) Something that you will notice in Access 2007 is that there are...

Author: ThirdOfFive Date: 05/16/2006

Save As Form/Report

As I mentioned previously, we have introduced the capability to fold the filter into the underlying...

Author: ThirdOfFive Date: 05/09/2006

Save As Query

There is a new functionality in Access 2007 that (as it happens a lot) is very low profile. Imagine...

Author: ThirdOfFive Date: 05/04/2006

Macros vs. VBA: Another look

I previously posted about Macro & VBAs. At the time most of the new stuff we were doing was not...

Author: ThirdOfFive Date: 05/02/2006

Changes to the Command Buttons and the Button Wizard

If you open a form in design mode and try to create a button using the button wizard you will notice...

Author: ThirdOfFive Date: 04/27/2006

Error Handling and Macros: MacroError

I previously discussed the brand new OnError macro action that introduces some useful error-handling...

Author: ThirdOfFive Date: 04/25/2006

Access 2007 demo video online

It looks like Clint gave a demo on Access 2007 and it's live right here, on MSDN TV. The colors in...

Author: ThirdOfFive Date: 04/21/2006

Error Handling and Macros: OnError

(This post is pre-recorded. I'll follow up on any comments when I'm back). Perhaps one of the weak...

Author: ThirdOfFive Date: 04/20/2006

Embedded Macros

As I mentioned on this post, macros are the way to go when running in disabled mode or when you want...

Author: ThirdOfFive Date: 04/18/2006

Screenshots: Access 2007 (and other Office apps) running on Vista

I bumped into this on the web and thought it would be interesting to share. This website has some...

Author: ThirdOfFive Date: 04/18/2006

TempVars: a new Access programmability facility for VBA and Macros

(This post was pre-recorded. I'll follow up on any comments when I'm back). I thought it would be...

Author: ThirdOfFive Date: 04/13/2006

Macros and Disabled Mode

As Erik described here, as part of the security-minded changes we're doing this time around, we...

Author: ThirdOfFive Date: 04/11/2006

Next>