Saturday, February 26, 2005

Free MS Access Add-in Of The Month

I am making available free each month one of my subscriber Access Add-Ins, commencing with the Ezy Filter for March 2005. Users can easily filter any data-based form or report in any Access database on the fly. An add code options allows developers to add Ezy Filter to their applications.

Thursday, February 24, 2005

Learn More about MS Office

Using the Excel 2003 XML Tools Add-in Version 1.1

Overview of Server Capabilities in Visual Studio Tools for Office, Version 2005 Create a solution that uses Word 2003 and Excel 2003 on the server.

Word 2003 XML Software Development Kit (SDK) Download the SDK for an overview of the XL schema reference, a linked description of the schema structure, and tools and samples for developing your own Word solutions.

Transforming Word Documents into the XSL-FO Format XSL-FO and WordprocessingML, when used together, create an extremely useful tool for transforming Word documents into other standard formats such as HTML or PDF.

Automating Word Tables for Data Insertion and Extraction Learn some of the best ways to automate the creation and formatting of tables in Word.

Tuesday, February 22, 2005

New MS Office Sample Applications

Business Intelligence Portal Sample Application for Microsoft Office 2003 An integrated, web-based OLAP solution that enables employees in an organization to create and share OLAP/Relational/XML based views, using SharePoint Portal Server, SQL Server Reporting Services, and Office Web components.

Access 2003/2002/2000 Sample: Basing One Combo Box on Another sample database This sample database, for the Basing One Combo Box on Another column on Office Online , includes an example form that demonstrates how to limit what appears in one combo box based on the choice you make in another combo box.

Sunday, February 20, 2005

Create a 30 Day Demo of an MS Access Database

I have just made available on my Access Tips page, free sample code that has the object of producing a fully protected 30 Day Demo of an Access database with the following features:

  • Back-dating the system date does not overcome the 30 day trial limit
  • Re-installation of the source file does not overcome the 30 day trial limit

with the caveat that no technique is hacker-proof. The technique is aimed at protection against most users.

Friday, February 18, 2005

Latest MS Access KB Articles

Courtesy of kbalertz.com:

873352 ACC2002: MS05-005: Vulnerability in Microsoft Office XP could allow remote code execution
893167 ACC2003: Description of the Access 2003 post-Service Pack 1 hotfix package: January 31, 2005
888634 ACC2003: You receive the "The database is in an unexpected state" error message when you try to open a database in Access 2000 or a later version
885828 ACC2003: Description of the Update for Office 2003: February 8, 2005
892301 ACC2003: The installation log file may incorrectly list the "Install return code: 0" error message when you install Office 2003 on a client computer
More XML

Using the Excel 2003 XML Tools Add-in Version 1.1 This new add-in makes working with XML maps, cells, and ranges much easier for developers.

Transforming Word Documents into the XSL-FO Format XSL-FO and WordprocessingML, when used together, create an extremely useful tool for transforming Word documents into other standard formats such as HTML or PDF.

Overview of Server Capabilities in Visual Studio Tools for Office, Version 2005 Learn about the new server capabilities of Visual Studio Tools for Office, Version 2005 as you create a solution that uses Word 2003 and Excel 2003 on the server.

Tuesday, February 15, 2005

MS Office Automation and XML


Excel 2003 Add-in: XML Tools Add-in This add-in accompanies the MSDN article "Using the Excel 2003 XML Tools Add-in" available from the Related Resources box section of the page.


Overview of Server Capabilities in Visual Studio Tools for Office, Version 2005 Beta 1 This download contains a Visual Studio Tools for Office, Version 2005 Beta 1 server solution that uses Microsoft Office Word 2003 and Microsoft Office Excel 2003 on the server.


Word 2003 Sample: Automating Word Tables for Data Insertion and Extraction This download accompanies the MSDN article "Automating Word Tables for Data Insertion and Extraction" available from the Related Resouces section of the page.


Word 2003 Sample: Transforming Word Documents into the XSL-FO Format This sample accompanies the MSDN article "Transforming Word Documents into the XSL-FO Format" available from the Related Resources section of the page.

Sunday, February 13, 2005

MS Excel Date Picker

Just discovered the coolest Excel Date Picker I have seen. It works seamlessly and it's free:

Smooth GUI for MS Access

You can get my Smooth Access GUI as a database template. Turn your Access 97+ databases into sleek applications using only native Access controls:

Latest Office Resources from Microsoft

Creating XML Mappings in Excel 2003 Walk through common XML tasks in Microsoft Office Excel 2003 to learn more about the new XML functionality in Office 2003 Editions.

Smart Access: Access Interfaces: Handling Price Ranges Discover two methods for handling the common case of multiple prices for a given product, depending on the quantity ordered.

Developer's Take on Smart Tags A straightforward introduction to smart tags. What are they? What do all the different terms mean? What do they do?

Word 2003: XML Software Development Kit(SDK) The Microsoft Office Word 2003 Software Development Kit (SDK) provides information and assistance for making the best use of the expanded XML features and support available in Microsoft Office Word 2003.