August 2007 - Posts
Someone asked me about using the Attachment data type in Access 2007 for a specific task. They wanted to use it as a simple data type where it would only be used to hold 1 file per record, and they wanted to be able to open the file in an external application
Read More...
There was a question on our post about getting Access to recognize tables as specific WSS table templates around what else you need to do to get the new Add From Outlook feature to work on a custom contacts table. This feature uses the same mechanism
Read More...
One of the coolest new features in Access 2007 is the new Attachments data type. There are some very helpful dialogs for working with this data type, but there are also some useful additions to DAO to make automating the process of adding and saving attachments
Read More...
Great news, you can now redistribute and use the PDF and XPS addin with your Runtime solution. Our download page has been updated to reflect this fact. Best of all, you don't need a new copy of the runtime to take advantage of this. The Runtime's code
Read More...
I can't resist doing a quick post to let you all know about the new report demo that just got published to OfficeOnline. This is a quick little video, just a few minutes long, which gives a great overview of some of our new reporting features in 2007.
Read More...
Despite my passion for all things related to code, I've always had a soft spot for UI that is exciting both in its "coolness" factor and visual appeal. Along those lines, one of my favorite new features in Access 2007 is Ribbon Extensibility . Writing
Read More...
The semi-annual Access Advisor conference is running September 30 - October 4 in Miami. This is always a well run event, and a great place to meet with fellow members of the Access community. Having recently gone to the spring conference, and with us
Read More...
I learned a new trick today from Michael the PM for the navigation pane. We have heard a few of you have missed the ALT D shortcut to open an object in design. As you know, ALT in ribbon apps now allows you to access ribbon shortcuts. Next time you want
Read More...
There was an interesting question in one of the other posts that I thought I'd answer here to reach the broader audience: Doug said : If I export Northwind 2007 to WSS 3.0, the tables, like Customer, that contain 'Contact' type information get exported
Read More...
Thanks to Jeff Conrad on the Access test team for this: Office Online now has published four articles with material pulled from the Microsoft Office Access 2007 Inside Out book. This enormous book, published by Microsoft Press, is co-authored by Access
Read More...
I was looking for this in search results today and realized that it isn't showing up in the rankings (or maybe it does, but the name isn't very intuitive). The new Access 2007 database engine (which reads and writes .accdb files) is available in redistributable
Read More...
Even though class modules in VBA are not as powerful as their brethren in C++, C#, or VB.NET, I'm still a fan. Some time ago, I wrote an application which contained a class called ISearch and then subclasses which implemented this class using the Implements
Read More...
You've likely noticed that Zac is now posting to the blog and that posts are more frequent (thanks Zac!). Now that Access has been in the market for some time, it is time to broaden the scope of the blog from "new stuff in Access 12" to be more of a general
Read More...
The new template work we did in 2007 is awesome, but I know it is not obvious how you can customize the template experience. There was at least one question in the newsgroups about this already, so I thought I would offer this up here as well. Template
Read More...
Recently, I wrote an application to manage files between directories and needed a function to make sure that the directory structure was the same between the source and destination files. VBA provides a function called MkDir which is used to create a
Read More...
