Tuesday, May 30, 2006

New Outlook 2007 Object Model Samples

Outlook 2007 Sample: What's New Add-Ins The Outlook 2007 What's New Add-Ins are a learning tool that will help you understand some of the important new features in the Outlook 2007 object model.
New Sample Applications for VB and SQL Server Express Editions

Each sample application provides a rich client user interface to view rich reports based on different business queries:

Friday, May 26, 2006

Intelligent Converters: Convert Access Database Tools

If you are moving your data across different platforms or applications, Intelligent Converters offers a comprehensive suite of data conversion software, and pricing is very reasonable and you can download free demos.

Converters include:
  • Access-to-MSSQL
  • Access-to-MySQL
  • Access-to-Oracle
  • Excel-to-MSSQL
  • Excel-to-MySQL
  • Excel-to-Oracle
  • MSSQL Migration Toolkit
  • MSSQL-to-Access
  • MSSQL-to-Excel
  • MySQL-to-Access
  • MySQL-to-Excel
  • MySQL-to-MSSQL
  • Oracle-to-Access
  • Oracle-to-Excel
Gallery of Office 2007 BETA 2 Screenshots

Check out these Office 2007 Beta screenshots - courstesy of TechRepublic.com.

Wednesday, May 24, 2006

Microsoft Office 2007 Learning Portal Offers Free Training

This MS Portal offers a wide range of courses on Office 2007 for those who have installed the BETA.

Courses are grouped as follows:
  • Home and Office Workers
  • Developers
  • IT Professionals

and include on-line courses, labs, and book downloads.

For those who haven't installed the BETA, but want an overview of the new features, I recommend this free dowloadable MS Press book from the Portal:

First Look 2007 Microsoft Office System (Downloadable PDF; 6,080 KB) What's inside the newest Microsoft Office system? How will the new look of Office change the way you work and make you more self-sufficient and effective? How can your business use its new workflow capabilities immediately in this new world of work? First Look 2007 Microsoft Office System gives you exclusive, advance insights and straight talk from the Office product group and other Office experts.

Tuesday, May 23, 2006

All About Office 2007 BETA 2

Today Microsoft released for public download Beta 2 of Office 2007 and the pre-release version of Visual Studio Tools For Office "v3.

ComputerWorld.com has also posted a detailed article on the features of the new beta: Review and Visual Tour: Microsoft's 2007 Office Beta 2

Warning: Don't install these Betas on production machines as they may damage your existing Office installations.

Monday, May 22, 2006





Office 2007 Virtual Tours For Developers

2007 Office System: How Do I ScreenCasts Download this series of developer-oriented videos to view virtual tours of new features in the 2007 Microsoft Office system.

Friday, May 19, 2006

Latest MS Access Knowledge Base Articles

Courtesy of KbAlertz.com:

Access 97

16583 ACC97: Problems Adding Records to Replicated Database Using ASP
160953 ACC97: ODBCKEY.INF in Data Access Pack Contains German String
172640 OFF97: Workbook Changed by MS Access May Not Be Recalculated
177105 ACC97: "There Is No Object in This Control" Error Inserting Web Browser Control
163841 ACC97: Removing Earlier Version Components Deletes Files on Server
163841 ACC97: Removing Earlier Version Components Deletes Files on Server
177105 ACC97: "There Is No Object in This Control" Error Inserting Web Browser Control
165830 ACC97: Problems Adding Records to Replicated Database Using ASP
172640 OFF97: Workbook Changed by MS Access May Not Be Recalculated
160953 ACC97: ODBCKEY.INF in Data Access Pack Contains German String

Access 2000

210242 How to implement Query by Form (QBF) with dynamic QueryDef in Access 2000
209645 How to use the Query by Form (QBF) technique in Access 2000
210242 How to implement Query by Form (QBF) with dynamic QueryDef in Access 2000
209645 How to use the Query by Form (QBF) technique in Access 2000

Access 2002

918004 Error message when you use Office Genuine Advantage to validate Office 2003 or Office XP: "Validation Incomplete" or "Error code: 0x8018101"
918003 Error message when you use Office Genuine Advantage to validate Office 2003 or Office XP: "Validation Incomplete" or "Error code: 0x8018103"
918001 Error message when you try to validate Office 2003 or Office XP by using Office Genuine Advantage: "Validation Incomplete: No Office Products Detected" or "Error code: 0x8018109"
917999 Error message when you try to validate Office 2003 or Office XP by using Office Genuine Advantage: "Unable to Validate" or "Error code: 0x8018111"
918000 Error message when you use Office Genuine Advantage to validate Office 2003 or Office XP: "Validation Incomplete" or "Error code: 0x8018110"
887034 Information about ActiveX controls that are supported in Access 2002
295358 Description of new features and enhancements in Access 2002
870963 References that you may have to set when you work with databases in Access 2002
888994 Description of the Access 2002 post-Service Pack 3 hotfix package: November 16, 2004
885235 Description of the Access 2002 post-Service Pack 3 hotfix package: September 10, 2004
887036 You receive a "Can't find the database you specified or you didn't specify a database at all" Error message in a stand-alone version of Access 2002
293334 ACC2002: Event Topics, Property Topics, and Other Help Topics Related to Batch Transactions in Access 2002 Are Incorrect
870963 References that you may have to set when you work with databases in Access 2002
887034 Information about ActiveX controls that are supported in Access 2002
295358 Description of new features and enhancements in Access 2002
887036 You receive a "Can't find the database you specified or you didn't specify a database at all" Error message in a stand-alone version of Access 2002
293334 ACC2002: Event Topics, Property Topics, and Other Help Topics Related to Batch Transactions in Access 2002 Are Incorrect
888994 Description of the Access 2002 post-Service Pack 3 hotfix package: November 16, 2004
885235 Description of the Access 2002 post-Service Pack 3 hotfix package: September 10, 2004

Access 2003


916657 Description of the Office 2003 post-Service Pack 2 hotfix package: April 21, 2006
916658 You are prompted for credentials every two weeks when you try to view a Web resource in Office 2003
917689 Relative hyperlinks are changed and no longer work correctly in a file that is saved in Office 2003
917878 Description of the Office 2003 post-Service Pack 2 hotfix package: April 12, 2006
918062 Description of the Access 2003 post-Service Pack 2 hotfix package: April 18, 2006
917688 Description of the Office 2003 post-Service Pack 2 hotfix package: April 5, 2006
916657 Description of the Office 2003 post-Service Pack 2 hotfix package: April 21, 2006
916658 You are prompted for credentials every two weeks when you try to view a Web resource in Office 2003
918295 Error message when you use an .odc file to connect to a specific table in a mail merge data source in Office 2003: "Record 'number' contained too few data fields"
917832 Description of the Access 2003 post-Service Pack 2 hotfix package: April 18, 2006
918269 Description of the Office 2003 post-Service Pack 2 hotfix package: April 26, 2006
918269 Description of the Office 2003 post-Service Pack 2 hotfix package: April 26, 2006
917832 Description of the Access 2003 post-Service Pack 2 hotfix package: April 18, 2006
918147 Description of the Office 2003 post-Service Pack 2 hotfix package: April 17, 2006

Thursday, May 18, 2006

Code VBA: Cool Coding Tool for the MS Office VBE

I just came across this product. The Code VBA add-in offers an amazing set of coding tools for the VBE. A set of 20 specialized code builders supports the fast creation of most used code, and an integrated code fragments library lets you find coding solutions easily.

Download a fully functional 30 day Free trial.

Feature: Code Library

  • Find and use built-in and custom procedures
  • Code fragments library
  • Find all built-in VBA procedures and code fragments related to keywords in seconds

Feature: Code Generators

  • Create procedures
  • Fast declaration of variables and constants
  • Work with enumerated types
  • Flexible error-handling

Feature: Object Oriented Programming

  • Work with classes, collections and properties

Feature: VBA Programming

  • Additional support for Access and Excel
  • A collection of 200 plus typical VBA code fragments for use with the Fragments Builder
  • Line of Code Builder shows all Access and Excel built-in functions
  • Fragment Builder for Access database actions, including DAO and ADO, and Excel
  • Insert Variable automatically picks up controls when in a Form module.

Wednesday, May 17, 2006

NEW TreeView Switchboard for MS Access

My latest Access Switchboard, the TreeView Switchboard, is a complete Explorer-like Replacement Switchboard for Microsoft© Access 97/2000/2002/2003. The TreeView pane can be resized or hidden on-the-fly at run-time, and Node icons are fully customisable.

Sunday, May 14, 2006

New Access MenuBar Switchboard Builder:
Maximize Application Screen Space






I have just launched The Access MenuBar Switchboard Builder Add-In for Microsoft© Access 2000 or later. In only 3 mouse-clicks, the MenuBar Switchboard Builder produces a complete replacement switchboard using the native Access Switchboard Items table.

A MenuBar Switchboard is an Access System MenuBar built on the native Switchboard Items table. The Builder creates the Switchboard MenuBar and adds a code module to handle all the Switchboard functions, with zero changes required to your database.

Thursday, May 11, 2006

Using the Outlook 2007 Object Model

Developing Solutions Using the Consolidated Outlook 2007 Object Model Learn about new platform features in Microsoft Office Outlook 2007.

Tuesday, May 09, 2006

New Visual Studio Tools for Office 2005 Resources

Visual Studio Tools for Office 2005 Toolkit: Requirements Authoring Starter Kit Learn how the Requirements Authoring Starter Kit (RASK) can help software development teams collect, interpret, distribute, and synchronize project requirements in a structured Word document using Microsoft Visual Studio 2005 Tools for the Microsoft Office System and the Microsoft Visual Studio 2005 Team Foundation Server.

Visual Studio 2005 Tools for Office Sample: Estimate Solution This download contains an Estimate sample solution built with Microsoft Visual Studio 2005 Tools for the Microsoft Office System.

Monday, May 08, 2006





Up-Coming Office 2007 WebCasts

Customizing the Office 2007 Ribbon June 19, 2006 - 11:00 AM Pacific

Office 12 File Formats June 21, 2006 -11:00 AM Pacific

Thursday, May 04, 2006

New Consolas Font Pack from Microsoft

Microsoft has made available for free download a new Windows font optimized for Microsoft ClearType.

The Microsoft Consolas Font Family is a set of highly legible fonts designed for ClearType. It is intended for use in programming environments and other circumstances where a monospaced font is specified. This installation package will set the default font for Visual Studio to Consolas.

I have used the font in my Office VBE's, and it certainly improves readability on my LCD monitor: