August 2007 - Posts

Using VBA code to open a file stored in the new Access 2007 Attachment field
30 August 07 10:30 AM
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...
Postedby James K. Rivera | 4 Comments    
Filed under: , ,
Integrating Access Contacts with SharePoint and Outlook
28 August 07 05:10 PM
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...
Postedby Zac Woodall | 10 Comments    
Filed under: , ,
Adding, removing, and saving files from the new Attachment field in Access 2007
24 August 07 01:41 PM
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...
Postedby James K. Rivera | 6 Comments    
Filed under: ,
PDF & XPS Now supported in Access Runtime!
23 August 07 11:15 PM
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...
Postedby Zac Woodall | 15 Comments    
Filed under: , , ,
Access 2007 Reports Demo
23 August 07 05:20 PM
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...
Postedby Zac Woodall | 10 Comments    
Filed under: , ,
Creating item templates for Ribbon customizations to use in Visual Studio
23 August 07 01:47 AM
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...
Postedby robcooper | 5 Comments    
Filed under: , , ,
Upcomming Access Advisor Conference
21 August 07 11:50 PM
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...
Postedby Zac Woodall | 4 Comments    
Filed under:
Navigation pane tip of the day
20 August 07 03:29 PM
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...
Postedby clintc | 6 Comments    
Filed under: ,
Set SharePoint List Template for Access Table
16 August 07 07:32 PM
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...
Postedby Zac Woodall | 27 Comments    
Filed under: , , ,
New Access 2007 Articles on Office Online
13 August 07 06:33 PM
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...
Postedby Zac Woodall | 5 Comments    
Filed under: , , , , , , , ,
Access Database Engine Redistributable
10 August 07 02:01 AM
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...
Postedby Zac Woodall | 13 Comments    
Filed under: , ,
Formatting numbers into hexadecimal
09 August 07 01:17 AM
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...
Postedby robcooper | 1 Comments    
Filed under: ,
New People Posting to the Access Blog
07 August 07 12:35 PM
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...
Postedby Erik Rucker | 15 Comments    
Filed under: ,
Access 2007 Template (.accdt) Files
06 August 07 06:25 PM
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...
Postedby Zac Woodall | 5 Comments    
Filed under: , ,
MkTree Function - Make sure that directories exist
01 August 07 01:05 AM
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...
Postedby robcooper | 5 Comments    
Filed under: ,
Page view tracker