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...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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':...
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...
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...
Date: 08/11/2006
Access Developers-related Presentations
In case you'd like to get some free quasi-training videos, Microsoft is making available some of the...
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...
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...
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...
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...
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...
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...
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...
Date: 06/08/2006
Totals Row
Another new feature for datasheets in the Totals Row. At the bottom of any datasheet view, one can...
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...
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...
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...
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...
Date: 05/16/2006
Save As Form/Report
As I mentioned previously, we have introduced the capability to fold the filter into the underlying...
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...
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...
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...
Date: 04/27/2006
Error Handling and Macros: MacroError
I previously discussed the brand new OnError macro action that introduces some useful error-handling...
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...
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...
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...
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...
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...
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...
Date: 04/11/2006