Friday, October 28, 2005

Ezy Filter PLUS and Ezy Reporter PLUS Data Analysis Pack
for Microsoft© Access

The easy way to analyze data in MS Access with my latest Access Add-Ins:
Ezy Filter PLUs and Ezy Reporter PLUS.

Download from

Two tools for the price of one:

Ezy Filter PLUS
Easily filter any data form in any Access database. An add code options allows developers to add Ezy Filter to their applications.

Ezy Reporter PLUS
Easily create output for any Access database.
An add code options allows developers to add Ezy Reporter to their applications.

Tuesday, October 25, 2005

Overview of Office 2003 Developer Technologies

Download the official Microsoft® Office 2003 Editions: Overview of Developer Technologies
White Paper
New Office Articles and Webcasts at Office Developer Portal

Courtesy of

Creating Smart Documents with Visual Studio 2005 Visual Studio 2005 Take away the pain of creating smart documents that run inside of Microsoft Office Professional Edition 2003. How the smart document apparatus has been improved inside Visual Studio 2005.

Five Things You Must Know About Visual Studio Tools for Office 2005 VSTO 2005 introduces some big concepts, with big implications, like the separation of code from view. It also gives Office application developers some new features and tools to work with, including improved Smart Tags, easy-to-make Actions Panes, and the new Object Test Bench. Learn more by using these code examples to build the ultimate killer app.

Easy Time & Billing with SharePoint, Outlook, Excel and VSTO These popular office system applications reduce the pain of recording and reporting your time, with very little code required.

Automating the Deployment of an Office InfoPath Form Template Microsoft Office InfoPath 2003 enables you to publish form templates to a specific location, such as a Web server or a network file share. In this article, learn how to update part of a previously-published form template and move it to a new location.

Convert VBA Code to Visual Basic .NET Read this article for a review of the major code conversion issues and the benefits of migrating your VBA code to Visual Basic .NET and Visual Studio 2005 Tools for Office.

Create Excel Solutions for Users in More than One Country or Region Learn which issues you should consider when using Visual Studio Tools for Office to create Excel 2003 solutions for end users in more than one country or region.

Get the Most from the Office 2003 Primary Interop Assemblies Learn how to get and install the Office 2003 primary interop assemblies (PIAs), and how to reference and troubleshoot them.

Create an InfoPath Custom Control Using C# and .NET Check out the InfoPath Team Blog-and learn how to create a custom control that can bind to fields in an InfoPath form using managed code and COM interop.


VSTO--Open Forum with Office Team Members Join host Mike Hernandez and members of the Visual Studio Tools for Office team for this open forum. Hear answers to questions that have been on developers' minds.

MSDN: Best Practices for Designing InfoPath Forms This popular talk demonstrates the basics and the best practices for designing InfoPath forms.

MSDN: Creating Custom Controls for InfoPath Get up to speed quickly as we discuss the steps needed to write an ActiveX control, which works in InfoPath as a custom control.
Microsoft Builds Business Intelligence Into Office 12

Microsoft Builds Business Intelligence Into Office 12 Availability of Microsoft Office Business Scorecard Manager 2005 and major business intelligence investments in Office 12 will make BI more accessible to employees and valuable to organizations.

Monday, October 24, 2005

Excel At Your Server

Office 12: Excel At Your Server As part of Office 12, Microsoft will add the ability to store and manage spreadsheets from a central server, allowing companies to create business rules around how different workers can access the data.

Wednesday, October 19, 2005

NEW Windows Vista-Style Switchboard Demo
for Microsoft© Access 97/2000/2002/2003

I have just launched my latest Access Switchboard Demo Database featuring Windows Vista-style application navigation. Get the Windows Vista and Office 12 look now!
  • Seamlessly uses the native Switchboard Items table created by the Access Switchboard Manager
  • Office 12 style navigation with icons
  • Uses only native Ms Access controls

Tuesday, October 18, 2005

Linked Excel Worksheet Update for Access 2002

Update for Access 2002 (KB904018) Microsoft has released an update for Microsoft Access 2002. This update removes the functionality in Access 2002 that lets users add new data to or edit existing data in a linked Microsoft Excel worksheet.

Monday, October 17, 2005

New Office 2003 Web Add-In

Office 2003 Add-in: Web Parts and Components Office Web Parts and Components is a collection of Web Parts, Web Part Page solutions, templates, and data retrieval services that work closely with Microsoft Office 2003 and Microsoft Windows SharePoint Services 2.0.
From Excel to Visual Studio 2005 Tools for Office via .NET

Redesigning an Excel VBA Solution to .NET Using Visual Studio 2005 Tools for Office Learn about redesigning an Excel VBA solution to take full advantage of Visual Studio 2005 Tools for Office and the .NET Framework. This article looks at the re-architecture of the Trey Research Internet Information Services (IIS) Log Analyzer solution.

Tuesday, October 11, 2005

New Articles on Visual Studio Tools for Office
  • Office COM Add-Ins Find developer information about Microsoft Office applications, servers, and technologies. Use Visual Basic to develop COM Add-Ins for Outlook.
  • IntelliSense XML Files for Visual Studio Tools for Office Developers Adds summary descriptions of types, members, and parameters to IntelliSense ToolTips in code and in the Object Browser for Microsoft Office Word, Microsoft Office Excel, Microsoft Office Outlook, and Microsoft Office Shared PIAs in Microsoft Visual Studio .NET 2003 and Visual Studio 2005.
Latest Articles from Office Developer Portal

Monday, October 03, 2005

Malware: Unpatched hole in JET

Symantec has warned that a trojan, named Backdoor.Hesive, arriving as a Microsoft Access file and run on a vulnerable system, gives a remote attacker full access to a compromised computer, but notes that it is not widespread. More

Sunday, October 02, 2005

Recent Access KB Articles

Courtesy of

Access 2000
  • 905726 You are unexpectedly prompted to restart the computer after you install an Office service pack or an Office update

Access 2002

  • 902349 How to change the source for a client computer from an updated administrative installation point to an Office 2003 or Office XP original baseline source

Access 2003
  • 887616 Description of Office 2003 Service Pack 2
  • 906600 The fixes that are included in Office 2003 Service Pack 2 that require a registry key
  • 906323 When you try to install Office 2003 Service Pack 2, you receive a "The upgrade patch cannot be installed by the windows installer service" error message, or the Setup program may not be completed, and you do not receive notification
  • 906460 Issues that are fixed in Access 2003 by Office 2003 Service Pack 2
  • 905476 You cannot update the data in a view that you created in Office Access 2003