frice's WebLog

SP1 Fix Affecting 64 bit Solutions in Access

We are on-track to deliver SP1 in mid-summer 2011 (here is the official announcement). We definitely...

Author: Frank C. Rice Date: 05/23/2011

Add-in that lists the IDs (idMSOs) of context menu controls is now available

As part of Office 2010 extensibility, it is now possible to extend Context Menus exists, e.g. adding...

Author: Frank C. Rice Date: 09/01/2010

What's New for Office 2010 Developers white paper is live

Learn about some of the new features and technologies for developers in Office 2010. View the paper...

Author: Frank C. Rice Date: 08/27/2010

Introducing a new type of help for developers

The Microsoft Developer Center introduces a new type of help documentation for developers. They are...

Author: Frank C. Rice Date: 04/02/2010

Check out the new article from Excel MVP Ron de Bruin

The article titled Using VBA in Excel to Send Workbooks and Ranges through E-Mail with Outlook (Part...

Author: Frank C. Rice Date: 03/11/2010

New Office Talk column on using Office Open XML is now available

I've written a new Office Talk column on creating form letters in Word 2007 and Word 2010 by using...

Author: Frank C. Rice Date: 01/07/2010

Lots of new resources for the Office 2010 Backstage View UI and 64-bit Office

Be sure and take a look at the following articles and downloads for both the Office 2010 Backstage...

Author: Frank C. Rice Date: 11/20/2009

The Office Developer Resources Ribbon UI Add-in

The Microsoft Office Developer Center (ODC) (https://msdn.microsoft.com/office) contains a tremendous...

Author: Frank C. Rice Date: 07/16/2009

Excel's Worksheets and Sheets Collection - What's the Difference?

Among the top four objects most searched for on the Microsoft Developer Network by Excel programmers...

Author: Frank C. Rice Date: 12/05/2007

Check out these new articles on MSDN

The article Calling Excel 2007 Custom Wizards from the Office Fluent Ribbon by Using VBA...

Author: Frank C. Rice Date: 11/08/2007

Cool translation feature in Microsoft Office

One of the coolest features in Office that I think many people (well, at least me) overlook is the...

Author: Frank C. Rice Date: 04/10/2007

Using Code Snippets in Visual Studio 2005 is Incredible

Visual Studio 2005 code snippets are a neat way to package pieces of code that you want to keep...

Author: Frank C. Rice Date: 04/03/2007

New Visual How-to content on the Microsoft Office Developer Center

Just a quick note to say that there is new developer content on the Office Developer Center...

Author: Frank C. Rice Date: 03/23/2007

Customizing the Office 2007 Ribbon UI - Part 6

In this topic on customizing the Ribbon UI, we'll look at different scenarios for customizing the...

Author: Frank C. Rice Date: 06/28/2006

Customizing the Office 2007 Ribbon UI - Part 5

In the previous blog, I created a COM add-in in managed C# code that customized the Ribbon UI...

Author: Frank C. Rice Date: 06/21/2006

Customizing the Office 2007 Ribbon UI - Part 4

In this installment in the series on customizing the Ribbon UI, we'll look at adding...

Author: Frank C. Rice Date: 06/14/2006

Customizing the Office 2007 Ribbon UI - Part 3

In this blog, I will walk through an example of adding a custom tab, custom group, and a button with...

Author: Frank C. Rice Date: 06/07/2006

Customizing the Office 2007 Ribbon UI - Part 2

In the previous blog, I discussed reasons for the new Office Ribbon UI, ways to customize the...

Author: Frank C. Rice Date: 05/31/2006

Customizing the Office 2007 Ribbon UI - Part 1

This is the first in a series of topics focusing on the new Office 2007 user interface (UI) and...

Author: Frank C. Rice Date: 05/24/2006

Let Access do the work of writing SQL statements for you

One of the views associated with creating queries in the Query designer in Access is the SQL window....

Author: Frank C. Rice Date: 01/27/2006

XBox - Life, What Life?

Just as Michael Corleone said in Godfather III, "Just when I thought I was out, they pull me back...

Author: Frank C. Rice Date: 01/25/2006

It's deja-vu all over again - recursion

One of the subjects that made me nervous when taking computer science classes in college was...

Author: Frank C. Rice Date: 01/25/2006

What happened to my button?

I recently had a customer ask how he could freeze objects, in this case a set of buttons, so that...

Author: Frank C. Rice Date: 11/14/2005

Get "Immediate" results when creating or debugging code

In my last blog, I talked about debugging with the Watch window where you can do things such as look...

Author: Frank C. Rice Date: 10/31/2005

VBA Beginner's Corner - Someone to Watch over you.

The Visual Basic for Applications (VBA) integrated development environment (IDE) seen in the...

Author: Frank C. Rice Date: 10/27/2005

Using Northwind Traders can save yourself a lot of time

Since 1994, regardless of my actual job, I've always found a way to stay involved with Access. I'm...

Author: Frank C. Rice Date: 10/17/2005

Writing Technical Articles - Part 3

To recap, you've created a plan and an outline for your article. You've also added code samples or...

Author: Frank C. Rice Date: 09/28/2005

Writing Technical Articles Part 2

Continuing my previous blog on writing technical articles, now that you have a plan, it's time to...

Author: Frank C. Rice Date: 09/28/2005

Writing Technical Articles Part 1 - Step up to the plate and share the wealth

I'm a programmer writer for the MSDN Office Developer Center. My job for the last five years is...

Author: Frank C. Rice Date: 09/20/2005

Using ADO with Excel Data Sources

ADO is used for performing client/server data access between a data consumer and a data provider....

Author: Frank C. Rice Date: 07/09/2004

Tips on Access report numbering

Starting Report page numbers from a number other than one In Design View place an unbound text box...

Author: Frank C. Rice Date: 06/25/2004

User-Defined Functions in Excel

Excel allows you to create custom functions, called "User Defined Functions" (UDF's) that can be...

Author: Frank C. Rice Date: 06/11/2004

Creating reusable code

This blog discusses just a couple of ways that you can make your code reusable.If you frequently...

Author: Frank C. Rice Date: 06/11/2004

Adding Additional Conditional Formatting in Access with VBA

Microsoft Access 2000 (and later) lets you conditionally format the data in combo box and text box...

Author: Frank C. Rice Date: 06/08/2004

Database normalization simplified?

--Making Sense of Database Normalization, Hopefully-- Following is my take on database...

Author: Frank C. Rice Date: 03/10/2004

Adding a button and Click event at run-time

Many developers recognize the need to disable certain controls in their application to either keep...

Author: Frank C. Rice Date: 02/24/2004

Should I use a bang or dot?

One of the questions frequently asked by new Access users (and veterans as well) in the newsgroups...

Author: Frank C. Rice Date: 02/18/2004

Improving Access Database Performance

One of the areas where I see a lot of questions in the newsgroups concerns the performance of Access...

Author: Frank C. Rice Date: 02/12/2004