All good things…

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 just in case. The blog itself will probably go read-only…

2

Access 2007’s Improved Command Buttons

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 a new property off of the command button called…

0

The New Import/Export Specifications UI

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 to go through part of the import/export wizard until you could…

0

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, 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 to show/hide any controls off of the Office Button menu, effectively customizing it…

2

The New Import/Export Specification OM

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 settings over and over again. One point of contention, however, has…

6

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 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/Create form or report in design mode; Select the “Design” contextual tab (or…

4

The New Access 2007 Switchboards

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 Manager cranks out and come up with something that is more up-to-date. The first you…

0

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 learned about it in a totally unexpected way? Remember that we talked about how embedded macros are really represented as SaveAsText/LoadFromText alongside objects? Unlike VBA code associated with event properties (e.g. OnLoad, etc) and like other ‘simple’…

5

Templates: How to create your own

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) to generate templates out of any database (not ADPs, though). By…

5

Templates: Programmability

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 Application.NewCurrentDatabase by adding a new couple of optional…

0