and created a donations application that ran in the browser. I thought it would be helpful to provide some background to the vision and direction. Years ago I came across a post on UtterAccess that articulately described what we hope to accomplish with Access 2010. Reading between the lines a littleStormin wants to keep all the goodness of the .. more »

Today, we are thrilled to announce the release of the public beta of Access 2010, Access 2010 Runtime, and SharePoint 2010. You can download Office and SharePoint at Access 2010--The 10,000 ft. View Last month Ryan and I gave the first public demo on Channel 9 . If you havent see itdefinitely interesting for Access users. See the for more .. more »

As we all know, a List Box control has a Fore Color property. It sets the fore color for column values and headers simultaneously. Also, we know that table and query fields have a , where color formatting can be set. For example, you can format a number field as As stated in Access 97, 2003 and 2007 help, "If you set a field's So when creating a .. more »

Web databases introduced a few ribbon design challenges, particularly how to present client and web create options? We wanted to make sure that people creating client objects are just as successful as web objects. When you create a new database from scratch, you have two options: either to open a blank database or a blank Web database. Creating a .. more »

A very good article by Armen Stein, Access MVP .. more »

Example with detailed steps: Consuming .NET components within Access/VBA .. more »

Todays guest writer is Wouter Steenbergen, a PM on the Access team responsible for Access form and report designers. If you want to build an easy to use application it always starts with a good navigation model that allows users to quickly perform the most common tasks and easily find the less common tasks. Years ago, Access introduced the concept .. more »

Daniel is the Training Director at , which specializes in providing custom training solutions in Microsoft Office products. I always thought it was cool to be able to sort a list by clicking the column heading once, for ascending order then once more for descending order. A while ago I decided to tackle this feature in an Access form. The buttons .. more »

Todays guest blogger is Darren Myher. Darren is the VP Operations of Every company has something that makes their business unique a competitive advantage that needs to be supported and enhanced by the software they choose to run their business. Using Microsoft Access as the front end UI to a SQL Server back-end allows Blue Link to build and .. more »

This is the second episode of The Access Show with Steve Greenberg & Ryan McMinn. They just came back from the sold-out SharePoint conference in Las Vegas where they launched Access Services and wanted to give you an update as well as introduce some customers that have been using the technical preview and building web databases. Robert Hogg -  B.. more »

John Durant from Office marketing is on The Knowledge Chamber with Robert Hess. He is talking about new features in Office that help developers . He starts his Access plug about 3 minutes into the talk. Good stuff. Dick Moffat who has attended several of our developer kitchens recently wrote a blog post about Access 2010 and hybrid apps . He really .. more »

We received a question the other day from someone who was using the Shell function in VBA to run a command in a command prompt. The command in question was , but this could apply to any number of commands. The original code was as follows: This code had worked for a while, but on Windows Server 2008 (and presumably Windows Vista and Windows 7), .. more »

This trick should help to install VB6 on Windows 7: Installing VB6 without Java .. more »

This is a very frequently discussed issue. But before I get into the methods, you need to understand one of the principles of relational databases. That principle is that data should exist in one place only. Having the same data in multiple tables is a violation of normalization. Related records are indicated by a Foreign Key within the record that .. more »

In VBA, a common way to refer to the pages of a tab control is to use the Value property. However, Luke Chung, President of FMS Inc., recommends using the PageIndex property instead. Click here to find out why! Send your Power Tips to Mike and Chris at accpower@microsoft.com... more »

Albert D. Kallal (Access MVP) has published a great video demo of an application that he build for tracking meetings rooms. He even has built a fancy calendar control that renders in the web using data macros and bound controls. it is a good example of the types of things you can do in the browser with Access + Access Services. Here is my .. more »

Johanna and I were invited to do an interview for the MSNZ podcast at the SharePoint Conference. It just got posted, hope you enjoy it :).. more »

When you run relink procedure at application startup, and backend file is located on the network – the process can be much slower then relinking local file, even with very fast network. The trick is to open backend file before relink process and close it after. Sample code: Dim dbData  As DAO.Database Set dbData = DBE.. more »

Check out this great video - Access 2010 and Outlook style calendar running in a browser by Albert D. Kallal, Access MVP. Application was developed in Access and running in web browser using SharePoint Access services. Well done, Albert! .. more »

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 VBA? Is it going to be around in Office 2010? Is it supported? Should I migrate away from VBA no.. more »