Outlook

New Outlook Hotmail Connector released

We’ve got good news for those of you who read your Windows Live Hotmail accounts in Outlook. We have released an update to the Microsoft Outlook Hotmail Connector. This update brings a number of fixes and is required to continue using Hotmail accounts in Outlook. The version number for the updated Hotmail Connector is 14.0.5139.5001. To determine which version is installed on your computer, see the end of this article.…

Access

Power Tip: Improve the security of database connections

When linking to external tables using Open Database Connectivity (ODBC), Access offers to set up a Data Source Name (DSN). The DSN is quite convenient, giving us a graphic method to quickly build and specify an ODBC connection string without having to remember all of the syntax and parameters. Unfortunately, when the time comes for deployment, using a DSN can introduce some security issues. In this post, Access MVP Ben…

Access

Power Tip: Improve the security of database connections

When linking to external tables using Open Database Connectivity (ODBC), Access offers to set up a Data Source Name (DSN). The DSN is quite convenient, giving us a graphic method to quickly build and specify an ODBC connection string without having to remember all of the syntax and parameters. Unfortunately, when the time comes for deployment, using a DSN can introduce some security issues. In this post, Access MVP Ben…

Access

Power Tip: Supercharge conditional formatting by using a bit of code

Over the past few versions of Access, the product team has steadily added more conditional formatting functionality for forms and reports. For example, in Access 2010, you can add up to 50 conditional formatting rules for each object without having to write any Visual Basic for Applications (VBA) code. However, if you’re working in an earlier version, or if you just prefer to use VBA to perform formatting tasks on…

Publisher

What are crop marks and why would you want to print them?

Crop marks, also known as trim marks, are lines printed in the corners of your publication’s sheet or sheets of paper to show the printer where to trim the paper. They are used by commercial printers for creating bleeds where an image or color on the page needs to extend all the way to the edge of the paper. Printers generally can’t actually print to the very edge of the…

Access

Use code to “undo” things in Access

One of the more common tasks on a computer is to undo something you just did by mistake. At least, it’s one of my more common tasks. CTRL+Z is my friend. But not everyone uses keyboard shortcuts – that’s why there’s an Undo button in the Microsoft Office user interface. Trouble is, sometimes folks just don’t see it. Moreover, in Access it’s possible that they can’t use the toolbar because…

Publisher

Where is web site authoring in Publisher 2010?

Today’s post on the reduction in web publication capability in Publisher 2010 comes to us from Jeff Bell. Jeff was the Group Program Manager for Publisher and Text Services during the development and release of Publisher 2010. For a number of versions, Publisher has filled a gap as an easy-to-use web site authoring tool sitting between the template-based web-hosted offerings and the designer-oriented desktop HTML editors. With Publisher 2010, we…

Outlook

Issues with the recent update for Outlook 2007

On Tuesday, December 14, we released an update (KB2412171) for Microsoft Outlook 2007. We have discovered several issues with the update and want to inform you about problems you might encounter and what corrective steps we recommend. As of December 16, this Outlook 2007 update has been removed from Microsoft Update. This Outlook 2007 update was distributed via Microsoft Update. Many of you receive updates automatically and if you installed…