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.

October 2009 - Posts

Why VBA still makes sense
John Durant from the Office Developer marketing team is blogging about why VBA still makes sense . I expect the Access community is interested in what he has to say. Here is a little taste of the article: Not infrequently I am asked, “So, should I use Read More...
Convert hexadecimal color codes so you can use them in code
Today's guest blogger is Michael Merlin, Lead Software Developer at Electronic Communities . I recently wasted an hour trying to set a field's Back Color property to the hex code generated by the color picker. I figured it out after some searching, but Read More...
Running an Access Parameter Query from Excel
Excel MVP Michael Alexander wanted to share this tip about running an Access parameter query from Excel. He describes the problem thusly: An Access parameter query is a kind of interactive query that prompts you for criteria before the query is run. Parameter Read More...
.Net developer blogs about Access 2010
Today’s guest writer is Richard Fennell from Black Marble. Richard is engineering director for Black Marble, hard core .NET developer, and MVP for Team Systems. Black Marble does a lot of custom SharePoint development and sell few accelerator kits. Black Read More...
Expand only the subdatasheets you want
Today's guest blogger is Pavlo Pedan of ARGO Business Corp. He has 15 years of experience with Access and has a great site of tips  at http://sites.google.com/site/msaccesscode/ . If you have a form that contains subdatasheets, you can use the following Read More...
Access Web Databases and The Access Show
There are a couple big announcements happening today for the Access community. In partnership with Channel 9 we are launching a new show called The Access Show . It will feature Ryan McMinn, myself and others from the team. We will talk in-depth about Read More...
Mary Jo Foley writes about SharePoint
There is a good article by Microsoft watcher Mary Jo Foley about SharePoint from a Microsoft’s business perspective . Some key points worth highlighting: SharePoint is the fastest growing server product at Microsoft contributing over $1 billion in revenue. Read More...
Using the ShowToolbar Method to Hide the Ribbon
Today’s guest blogger is Edwin Blancovitch. Edwin is president of Advanced Developers.net , creators of Easy Payroll , a software package to manage your human resources, payroll, scheduling, time and attendance needs. I have been using the ribbon for Read More...
Nulls vs. zero-length strings: a Power Tip from the past
Today's guest blogger is Access MVP Garry Robinson, who offers the Smart Access collection of articles at http://www.vb123.com/kb . A few months ago I purchased the rights to publish the Smart Access magazine online and it is from that collection that Read More...
New Access fan page on Facebook
In our never-ending quest to spread the word about Microsoft Access, we now have an official fan page on Facebook! Our news feed includes links to articles on MSDN, TechNet, and Office Online, as well as posts on this blog. You can choose to see our posts Read More...
Identifying the Record Selected on a Continuous Form
Today’s guest blogger is Edwin Blancovitch. Edwin is president of Advanced Developers.net , creators of Easy Payroll , a software package to manage your human resources, payroll, scheduling, time and attendance needs. Regularly when we create databases Read More...
Access 2007 link table to SharePoint list performance
Today’s guest writer is Aaron Hafele from the Access Product Support team. In previous editions of this blog, Clint has pointed out a couple of things that, as a support engineer, I believe bear repeating. One in particular has to do with performance Read More...
Using Access for disaster response
This request came in from Gisli one of our Technical Advisors at MSFT. I’ve been asked by a collection of UN organizations that handle disaster response around the world if we would be able to provide training material (including recorded webcasts, on-line Read More...
3 new articles available on MSDN
MSDN writer Sal Ricciardi alerted us to the availability of 3 new articles on MSDN, two written by Luke Chung of FMS Inc. , and one co-written by Luke Chung and Dan Haught. Title Author(s) Performance Tips To Speed Up Your Access 2007 Database Luke Chung Read More...
Access 2010 improved layouts
Access 2007 introduced a new concept called Layouts . The most useful scenario for the feature was tabular reports. It makes it very easy to resize and rearrange columns compared to the pre-Access 2007 days with absolute position. Layouts in Access 2010 Read More...
Access 2010 trusted documents (or databases)
the Office 2010 Engineering blog has a good post from Maithili about trusted documents . We implemented this security feature in Access as well. What it means is that you can now trust an individual database without having to put it into a trusted folder. Read More...
Page view tracker