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.

May 2009 - Posts

Now accepting nominations for Access 2010 Technical Beta program
I’m pleased to announce the Access team is taking nominations to participate in the Office 2010 Technical Beta program. We expect availability of our first beta release, known as Technical Preview, in the month of July. The team is excited to get feedback Read More...
Access Proves “worth its salt” for IDOT
Today’s guest blogger is Joel Graff. Joel is a field engineer with the Illinois Department of Transportation (IDOT) . He’s sharing how he utilized Access to prove the efficiency of their drivers and equipment in managing winter road conditions. This last Read More...
Check out Gladstone's Report Writer for Microsoft Access
Mike Hnatt at Gladstone Solutions has a nifty Report Writer utility, available at http://gladstonesolutions.com/default.aspx . The utility lets you create reports and mailing labels quickly and easily, just by stepping through a few wizard-like screens. Read More...
VBA values for Office theme colors
Recently, there was a thread on UtterAccess that I thought might be helpful to more people. The poster radish asks: I'd like to change the color of a control then be able to change it back to its original color. If I wanted to use the theme's highlight Read More...
Synchronize with SharePoint under the hood
Recently I was asked the following question: I am looking to get an understanding of the internal operations during an Access 2007 synchronize execution. I have just been exposed to a SharePoint MOSS and Access 2007 environment where at times the normal Read More...
I love good old county fairs (customer case study)
As a young teenager I use to show goats at the Utah County and Utah State fairs. My parents would park our family trailer at the fair grounds and let my brother and me spend the week taking caring for the animals and hanging around the fairgrounds—it Read More...
How to: Create a Shortcut Menu for a Form, Form Control, or Report
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. When you're designing a form or report, Read More...
Three great looking Access applications
I grew up on a farm and have a soft spot in my heart for people that work with animals. I recently came across great looking apps for managing horses and cattle. People that raise animals know that good record keeping is fundamental to a successful operation. Read More...
SimplyVBA Global Error Handler special offer
Wayne Phillips from EverythingAccess recently sent us mail announcing a special for our blog readers: The product, SimplyVBA Global Error Handler , offers a revolutionary way of catching VBA errors on a global scale throughout your project without having Read More...
Fill a list with date values that update automatically
Say you need a combo box that is always populated with the last day of the current month, as well as the last days next five months. For example, in May, you want it to look like this: Then, in June, you want the choices to automatically roll over so Read More...
Creating Combo Boxes in Access 2007 that Allow Users to Select N/A
Ken Getz has authored another Visual How-to adapted from the Access Cookbook . This one’s about creating combo boxes that allow the user to specify a null, or “not applicable” value . Here’s the overview: Sometimes Access developers must create applications Read More...
Showing hidden controls during development
Today’s guest blogger is Michael Groh, co-author of the popular Access 2007 Bible . I often use hidden controls on Access forms and reports to hold intermediate values, temporary "flag" values, and the like. Because these controls are invisible Read More...
Shout out to user groups
Over the weekend, I had the pleasure of speaking to a great group of people from the Portland Access User Group (PAUG) at their annual conference. The conference brings together people from different backgrounds using Access in various capacities. It’s Read More...
TechEd 2009 and Microsoft Access
There are a few good sessions that Access developers might find interesting at TechEd 2009 this year (May 11-15). I always enjoy hearing Mary, Stephen, Adam, and Luke—great speakers with good content. DAT312: Solve Problems without Spending Money: Microsoft Read More...
Running other applications from Access 2007
I just noticed a new article from Ken Getz about running applications from Access on MSDN. This was adapted from his Access Cookbook. Here is the intro: Sometimes, from within your Microsoft Office Access 2007 application, you need to run another application Read More...
A simple debugging tip
Today’s guest blogger is Michael Groh, co-author of the popular Access 2007 Bible . Most of us, when faced with a failure in a large procedure, resort to the usual techniques for discovering the cause of the bug. The scenario here is that you've got some Read More...
Page view tracker