Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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