Microsoft Office – Sven Aelterman

Access Projects (.adp) and Invalid Values in Extended Properties Cause Error

How do you deal with errors opening a SQL Server table in Datasheet view in an Access Data Project when you have bad Extended Properties values?

Microsoft Office

Changing the Font Color in PowerPoint using Animation

For the longest time, I thought it couldn't be done: add an "emphasis" animation to text in a PowerPoint slide by changing the color of the text. Turns out it is possible after all, and here is how to do it (in PowerPoint 2007 - haven't tried older or 2010): Open the Custom Animation pane. … Continue reading Changing the Font Color in PowerPoint using Animation

Microsoft Office

Office 14 Ship Date in 2010

From ComputerWorld: Microsoft: Office 14 won't ship until 2010 Is it the economy? I wonder how Software Assurance customers feel about this... After all, they are the ones who have already paid for it!

Microsoft Office

An Improved Excel Color Banding Solution

Today, someone asked me if it was possible to make Excel highlight the column and the row of the cell that is selected. Excel already highlights the column and row header, but when working on a high-resolution screen, that does not help much in ensuring that you are actually entering data in the right cell. … Continue reading An Improved Excel Color Banding Solution

This is a personal blog. The opinions expressed on these pages and in these entries are entirely my own and do not necessarily represent those of my employer, my customers or associates.
I have never accepted any form of payment in return for mentioning a product name or linking to a site on my blog.
I make no representations as to the accuracy, currency, completeness and suitability for any purpose of the information found on this site. All information is provided as-is.
The information on this blog and on these pages is copyrighted material. Everyone is encouraged to reference and cite the material for personal and academic purposes. The material may not be used in a for-profit fashion.
The Comments section of each entry is open for discussion and dialogue. I welcome feedback to my blog entries from anyone. However, I reserve the right to remove any comment or reply that is off-topic, contains profanity or is intended to generate traffic to a for-profit web site.