Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Access Team Blog

Get product announcements, tips and tricks, and news directly from the team @ Microsoft.

August 2007 - Posts

Using VBA code to open a file stored in the new Access 2007 Attachment field
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...
Integrating Access Contacts with SharePoint and Outlook
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...
Adding, removing, and saving files from the new Attachment field in Access 2007
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...
PDF & XPS Now supported in Access Runtime!
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...
Access 2007 Reports Demo
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...
Creating item templates for Ribbon customizations to use in Visual Studio
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...
Upcomming Access Advisor Conference
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...
Navigation pane tip of the day
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...
Set SharePoint List Template for Access Table
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...
New Access 2007 Articles on Office Online
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...
Access Database Engine Redistributable
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...
Formatting numbers into hexadecimal
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...
New People Posting to the Access Blog
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...
Access 2007 Template (.accdt) Files
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...
MkTree Function - Make sure that directories exist
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...
Page view tracker