Sign In
Third Of Five - just another voice in the Collective
Currently talking about Access 2007 and other random topics...
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Access 2003
Access 2007 (aka "Access 12")
Accessibility
Meta
Office 2007 (aka "Office 12")
rand()
Archive
Archives
July 2008
(1)
October 2006
(7)
September 2006
(10)
August 2006
(10)
July 2006
(3)
June 2006
(5)
May 2006
(6)
April 2006
(11)
March 2006
(8)
February 2006
(10)
November 2005
(1)
October 2005
(2)
September 2005
(11)
August 2005
(2)
MSDN Blogs
>
Third Of Five - just another voice in the Collective
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Third Of Five - just another voice in the Collective
Well, I'm back (and moving)
Posted
over 4 years ago
by
ThirdOfFive
0
Comments
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!)
Third Of Five - just another voice in the Collective
All good things...
Posted
over 6 years ago
by
ThirdOfFive
2
Comments
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...
Third Of Five - just another voice in the Collective
Access 2007's Improved Command Buttons
Posted
over 6 years ago
by
ThirdOfFive
0
Comments
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...
Third Of Five - just another voice in the Collective
The New Import/Export Specifications UI
Posted
over 6 years ago
by
ThirdOfFive
0
Comments
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...
Third Of Five - just another voice in the Collective
Customizing the Office Button Menu (aka File Menu) and No-Ribbon Custom Solutions
Posted
over 6 years ago
by
ThirdOfFive
2
Comments
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...
Third Of Five - just another voice in the Collective
The New Import/Export Specification OM
Posted
over 6 years ago
by
ThirdOfFive
6
Comments
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...
Third Of Five - just another voice in the Collective
Changing Default Control and Form/Report Settings
Posted
over 6 years ago
by
ThirdOfFive
4
Comments
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...
Third Of Five - just another voice in the Collective
The New Access 2007 Switchboards
Posted
over 6 years ago
by
ThirdOfFive
0
Comments
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...
Third Of Five - just another voice in the Collective
Quick Trick: Copying Embedded Macros from one Property to another
Posted
over 6 years ago
by
ThirdOfFive
5
Comments
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...
Third Of Five - just another voice in the Collective
Templates: How to create your own
Posted
over 6 years ago
by
ThirdOfFive
5
Comments
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)...
Third Of Five - just another voice in the Collective
Templates: Programmability
Posted
over 6 years ago
by
ThirdOfFive
0
Comments
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...
Third Of Five - just another voice in the Collective
In case you are having issues installing Office 2007 Beta 2 Techinical Refresh (B2TR)
Posted
over 6 years ago
by
ThirdOfFive
0
Comments
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...
Third Of Five - just another voice in the Collective
Templates: SharePoint comes into Play
Posted
over 6 years ago
by
ThirdOfFive
4
Comments
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...
Third Of Five - just another voice in the Collective
Office 2007 Beta 2 Technical Refresh (B2TR) is out
Posted
over 6 years ago
by
ThirdOfFive
2
Comments
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...
Third Of Five - just another voice in the Collective
Templates: The Template Store
Posted
over 6 years ago
by
ThirdOfFive
1
Comments
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...
Third Of Five - just another voice in the Collective
Templates: The Instantiation Process
Posted
over 6 years ago
by
ThirdOfFive
0
Comments
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...
Third Of Five - just another voice in the Collective
Templates: Where did the embedded macros go?
Posted
over 6 years ago
by
ThirdOfFive
0
Comments
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...
Third Of Five - just another voice in the Collective
Templates: Access Objects parts
Posted
over 6 years ago
by
ThirdOfFive
2
Comments
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...
Third Of Five - just another voice in the Collective
Templates: Quick Overview of SaveAsText and LoadFromText (aka let’s get boring again)
Posted
over 6 years ago
by
ThirdOfFive
3
Comments
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...
Third Of Five - just another voice in the Collective
Happy Birthday
Posted
over 6 years ago
by
ThirdOfFive
3
Comments
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...
Third Of Five - just another voice in the Collective
Templates: The Meat of the ACCDT Template Files
Posted
over 6 years ago
by
ThirdOfFive
0
Comments
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...
Third Of Five - just another voice in the Collective
Templates: Cracking open ACCDT files
Posted
over 6 years ago
by
ThirdOfFive
2
Comments
(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...
Third Of Five - just another voice in the Collective
Templates: Quick overview of Open XML files (aka boring as hell post)
Posted
over 6 years ago
by
ThirdOfFive
1
Comments
(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...
Third Of Five - just another voice in the Collective
How to Determine if your Solution is in Disabled Mode
Posted
over 6 years ago
by
ThirdOfFive
3
Comments
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...
Third Of Five - just another voice in the Collective
Templates: Access 2007
Posted
over 6 years ago
by
ThirdOfFive
10
Comments
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...
Page 1 of 4 (87 items)
1
2
3
4