After a long hiatus, I'm back to blogging. And I also decided to move my blog elsewhere . Please do stop by... (Happy 4th of July, everyone!)

I have decided to pursue other interests and will no longer be able to maintain this blog. It was a very interesting experience, to say the least. :) Thank you for your time and all the comments! Take care, 3oF P.S.: I'll try to keep the posts around...

Up until this point, Access has supported command buttons with text or a picture, but never both at the same time. This has been a long standing request from users: the capability of showing both the caption and the picture. In Access 2007, you will notice...

As I previously mentioned, we are now exposing Import/Export Specifications (Imex Specs) in the OM in a thorough manner. We also took the time to make importing and exporting less repetitive in the UI. In the past, to make use of Imex Specs, you had...

Even though most of the information on how to customize the Ribbon in Access 2007 is already out , there are two recurring question that I've been seeing being asked often: How can I customize the Office Button Menu (aka File Menu)? We allow you...

In previous versions of Access (such as Access 2003), you can save the steps from an import or export operation into what we call Import/Export Specifications (Imex Specs). After saving it, you can always load it back so you don't have to customize the...

This is one of those features that almost nobody knows about because it isn't very discoverable. In Access 2007 (and earlier), you can change the default property values for any new controls in a form or report. Here are the necessary steps: Open...

Now that Access 2007 Beta 2 Technical Refresh (B2TR) is out, you will notice that we changed the Switchboard Manager functionality. Now that we have Disabled Mode and Embedded Macros , it was about time we revisited the switchboards that the Switchboard...

Now that we spent all this time talking about templates, how about we put to use something we learned about it in a totally unexpected way? Remember that we talked about how embedded macros are really represented as SaveAsText/LoadFromText alongside objects...

Now that we discussed extensively all about templates, we can talk about how this all this can be put at your service. You see, we will give you the capability (though not in the Access product itself - details will be forthcoming soon, hopefully)...

Now that we talked about what Access 2007 templates are made of and how Access makes use of them to create brand new databases, it begs the question as to what you can programmability-wise. The answer to that question lies in the fact that we changed...

For troubleshooting Office 2007 Beta 2 Technical Refresh (B2TR) installs, you might want to check out this Knowledge Base (KB) article . The most common problem that I heard so far is the that to install the B2TR update, you need at least 2 gigabytes...

When you go create your new database from a template using Access 2007, you will notice a checkbox right by the OK button and path where you will create the file. By checking the “Create and Link your Database to a Windows SharePoint Services Site”, instead...

I haven't seen any news about this yet, but it's already available for download. Check out this post on some of the changes in B2TR. 2007 Microsoft Office system Beta 2 Technical Refresh Important : Prior to applying this Beta 2 Technical Refresh...

No, that is not a new franchise opening near you. So far we talked a lot about what templates are, how we use them and all, but where are they? Well, they are actually in different locations in your hard drive. Do you think we would make this easier...

As we’ve seen in the previous posts, Access 2007 templates are not really database files per se, but simply a set of data and meta-data that will allow Access to create a brand new database file every time. At a high level, the process to instantiate...

Now that we saw how macros, queries, forms, reports and tables are persisted in templates, we can ask: what about embedded macros? Since embedded macros live in the event properties of form, reports and controls, they are persisted along with the...

Last week I talked about how the template core data is laid out. Now, I’ll focus on the actual Access objects. For every Access object part (each file in template\database\objects), there is a corresponding” XML file in the \template\database\objects...

Before we dive into the way the Access Objects are persisted in the Access 2007 template files, I thought it would be best if we talked briefly about the Application.SaveAsText and Application.LoadFromText methods and what they generate and read in, respectively...

It would be a shame to miss noting this blog's first birthday. Or at least it's first post 's first birthday. Do you feel this blog has helped you? Why do you read it? What could be improved? Any thoughts? Please drop a comment and let...

In my previous post, we cracked open an Access 2007 template file. For this post, I’d like to delve into the / template/database folder, where pretty much all the template content resides. In the root of this folder you will notice four files...

(This post was pre-recorded. I'll follow up on any comments when I'm back). Since the Access 2007 template files are Open XML files, you can easily crack them open to take a peek. These are really ZIP files, so you can simply copy the ACCDT file...

(This post was pre-recorded. I'll follow up on any comments when I'm back). This is really a brief overview of the terminology around Open XML files before we actually look at how it applies to Access 2007 template files. First of all, Open...

I was asked this question the other day and thought it's worth answering right away, and in public': "How can I programmatically determine that my solution is in disabled mode in Access 2007?" Well, this is very simple: by checking the value of the...

Perhaps one of the most significant improvements to Access 2007 when it comes to ramping up to using Access are templates. Unlike previous version of Access (like Access 2003), where upon starting you would be greated by a blank window, in Access 2007...