Thursday, April 28, 2005

MS Office 2003 SP1 Whitepaper

Office 2003 SP1 Whitepaper Documentation regarding installation of Office 2003 SP1 update to various corporate scenarios.
Free MS Office VBE Tools Pack

Mz-Tools MZ-Tools is a freeware 'all-in-one' add-in for the Access/Office 2000 and later Visual Basic For Applications editor (ie. module window) which adds several features missing in the IDE. It provides a main menu, a toolbar, handy context menus or customizable shortcuts to access those features.
Upcoming Microsoft Office Events

MSDN Webcast: Overview of Visual Studio Tools for Office, Version 2005 In this session, you will discover new features that enable developers to construct powerful business solutions using Visual Studio 2005 and Microsoft Office. Check out this on-demand Webcast.

Microsoft Workshop: Building Smart Clients DevX.com is hosting a one-day, demo-driven, technical ISV event on Smart Client solutions using XML, Web services, and the Microsoft Office System.
Office 12 and XML: Future Direction

Microsoft XML guru sees power for the people Jean Paoli, a co-creator of the XML data formatting standard, and senior director of XML architecture at Microsoft, speaks about the future direction for XML on the next version of MS Office, scheduled for release in 2006. "In general, the work flow business is going to use a lot (of XML), and there will be more simplicity for more users because the actual document is richer" Paoli said. Users can expect closer ties between server and Office desktop Microsoft products. Databases, such as the forthcoming Microsoft SQL Server 2005 and those from IBM and Oracle, will be able to save data in XML format ...

Wednesday, April 27, 2005

Updated Common Controls for VB6 and MS Office ODE Editions Released

Updated Microsoft Visual Basic 6.0 and MS Office ODE Common Controls The latest and probably last update for the Common Controls: mscomctl.ocx and comctl32.ocx is now available for download from MS:

Each .ocx contains the following controls:
  • Image Combo Control (mscomctl.ocx only)
  • Image List Control
  • ListView Control
  • ProgressBar Control
  • Slider Control
  • StatusBar Control
  • TabStrip Control
  • Toolbar Control
  • Treeview Control
The mscomtcl.locx is the later and less error-prone incarnation.
Advanced MS Office Topics: .NET, SQL Server, ASP.Net and ADO.Net

Microsoft Visual Studio 2005 Tools for the Microsoft Office System (VSTO2005) Redistributable Package Beta 2 Language Pack VSTO2005 beta Language package is the most recent update to the VSTO Language Pack and includes everything you need to run localized applications developed using the .NET Framework and Microsoft Office Word 2003 and Microsoft Office Excel 2003.

Data Points: Data Access Strategies Using ADO.NET and SQL Data Access Strategies Using ADO.NET and SQL

.NET Rocks! - Kimberly Tripp on SQL Server 2005 USB Key demonstration of SQL Server 2005 partitioning.

Extreme ASP.NET: A Little Bit of Control for Your Controls

Monday, April 25, 2005

New MS Access and MS Office Knowledge Base Articles

Courtesy of kbalertz.com:

896950 ACCESS: You receive a "The field is too small to accept the amount of data you attempted to add." error message when you run a query in Office Access.

897646 ACC2003: Update - Redistributable Primary Interop Assemblies is available for download.

896865 ACC2003: You may receive a "The OLE server may not be registered" error message when you try to create a blank data access page in Access 2002 or Office Access 2003.

887971 ACC2003: Description of the Access 2003 post-Service Pack 1 hotfix package: November 1, 2004.

885259 ACC2003: Description of the French version of the Access 2003 post-Service Pack 1 hotfix package: September 30, 2004.

290230 ACC2003: You receive a "The MST file does not correspond to the MSI file" error message when you use the Custom Installation Wizard.

895089 OFFXP: Very few clip art items are available in the results box of the Clip Art task pane in Office 2003 or in Office XP.

891298 OFFXP: When you try to open or to save a file in an Office XP program that is running in a Terminal Server session, the Office XP program may unexpectedly quit.

822170 OFFXP: Office Shortcut Bar Remains on Top When the Start Menu Has Focus.

839656 OFFXP: Generic icons appear in the Web Collections folder of Clip Organizer in Office XP programs.

873379 OFFXP: Description of the security update for Office XP WordPerfect 5.x Converter: September 14, 2004.

Wednesday, April 20, 2005

Extending Office 2003 with SQL Server

Extending Office 2003 for Enterprise Reporting and Analysis Extended Microsoft Office Excel 2003 functionality and use Web services to access discrete backend SQL Server databases.


SQL Server Express Utility SSEUtil is a tool that lets you easily interact with SQL Server:

• Connect to the main instance or user-instance of SQL Server.
• Attach, detach, and list the databases on the server.
• Upgrade database files to match the version of the server.
• Execute SQL statements via the console (similar to SQLCMD).
• Retrieve the version of SQL Server running.
• Enable and disable trace flags (for example, to trace SQL statements sent to the server by any client application)
• List the instances of SQL Server on the local machine or on remote machines.
• Checkpoint and shrink a database
• Measure the performance of executing specific queries.• Create and playback lists of SQL commands for the server to execute.
• Log all input and output.

Tuesday, April 19, 2005

Resources for Deploying and Installing MS Office 2003

Office 2003 Update: Redistributable Primary Interop Assemblies The Office 2003 Primary Interop Assemblies (PIA) redistributable is a Microsoft Windows Installer package that contains the Primary Interop Assemblies for Microsoft Office 2003 products.

New Spreadsheet Reveals Office 2003 Setup Defaults A new spreadsheet, Office 2003 Setup defaults.xls, documents the default installation settings for Office 2003 and the Office family applications FrontPage®, OneNote®, Project, and Visio®. For each feature, the spreadsheet indicates the default installation state and gives a description. You can use this spreadsheet to view the entire Setup feature tree and plan how to configure your Office applications.

Sunday, April 17, 2005

Recent Articles on Cutting-Edge Tools for and Features of The Microsoft Office System

Office 2003 Tool: FabriKam – The Microsoft Office System Solutions Learning Platform A compiled help file (CHM) for use with the FabriKam sample files.

Best Practices for Ensuring Application Reusability and Upgrade in Windows SharePoint Services Revisit key information in the Windows SharePoint Services SDK to understand best practices for writing code that will be reusable when you apply software updates, upgrades, or security updates to a deployment.

Smart Access: Eventful Formatting for Access Forms Dynamically changing your form's properties at runtime can often provide a better experience for your users. Access guru, Rick Dobson, shows you some secrets for dynamically changing your form's background as it gains and loses focus, keeping subforms in view, and providing colorful feedback for data.

Part 3: Replicating Excel 2003 Formulas to SQL Server In the third of a three-part series, learn how to use XML maps to automate a process for storing Excel 2003 formulas in a SQL Server database. Includes downloadable code.

Customizing the Data View Web Part in FrontPage 2003 Use Windows SharePoint Services and FrontPage 2003 to create custom views of data stored in your Web site or in custom data sources.

Microsoft Visual Studio 2005 Tools for the Microsoft Office System (VSTO2005) Redistributable Package Beta 2 (x86) VSTO2005 beta redistributable package is the most recent update to the VSTO redistributable runtime and includes everything you need to run applications developed using the .NET Framework and Microsoft Office Word 2003 and Microsoft Office Excel 2003.

Thursday, April 14, 2005

New MS Access and MS Office Resources Links

Part 3: Replicating Excel 2003 Formulas to SQL Server In the third of a three-part series, learn how to use XML maps to automate a process for storing MS Excel 2003 formulas in a SQL Server database. Includes downloadable code.

Managed Data Access Inside SQL Server with ADO.NET and SQLCLR Managed code can use ADO.NET when running inside SQL Server 2005 using the new SQLCLR feature. Basic scenarios of in-process data access, SQLCLR constructs, and their interactions, are covered.

Office 2003 Sample: Creating a Research Service using the Amazon Web Service API Download this sample to view the Amazon.com catalog directly from the Research task pane in Microsoft Office 2003 Editions. This sample accompanies the MSDN article "Creating an Office 2003 Research Service using the Amazon Web Service API".

Microsoft Office Small Business Accounting 2006 SDK 1.1 The Microsoft Office Small Business Accounting 2006 Software Development Kit (SDK) includes everything developers need to write, build, and deploy Microsoft Small Business Accounting integrated applications (5 April 2005).

Windows Auxiliary API Library This API library contains AuxKlibInitialize, AuxUlibInitialize, and related APIs (5 April 2005).

Business Intelligence Portal Sample Application for Microsoft Office 2003 This business intelligence portal sample application for Microsoft Office 2003 is an integrated, Web-based OLAP solution that enables employees in an organization to create and share OLAP/Relational/XML- based views, using Microsoft SharePoint Portal Server, SQL Server Reporting Services, and Office Web components (6 April 2005).

Protecting Microsoft Access Command Bars And Menus From AcesssAdvisor.com Keep Microsoft Access users from closing or moving your command bars and menus with this technique.

Monday, April 11, 2005

"I Need to Organize My MS Access Databases Fast! "

As an Access developer, I have hundreds of Access databases all over my hard drive, and Access 97, Access 2000, Access 2002 and Access 2003 installed. Organizing my Access files not only means locating the files, but having a tracking system that classifies them by the Access version required to open them.

To this end I developed the Find Access Database Wizard, which I have incorporated in my Access Control Center application (ACC). The Wizard automatically locates all Access files in a location and adds them to the ACC database classified by Access version.


Smart Access Articles

In a section of the MSDN web site, you'll find sample articles for each month of the years 2000-2005 from SMART ACCESS, a publication designed especially for Office developers and power users of MS Access.

To sign up for a free 3-month trial subscription, visit the Smart Access Web site.

Sunday, April 10, 2005

Tip and Code Sample: Switching Printers from within your MS Access Application

Fellow Access develepor, Mark Plumpton, of customdata.co.nz, has kindly provided sample code for easily switching printers on the fly while printing Access reports, with code as simple as this...

SaveDefaultPrinter
DefaultPrinter = "HP Laserjet (A3)"
DoCmd.OpenReport "rptTest", acViewNormal
RestoreDefaultPrinter

Download these demo Access97/2000 databases, which include a class module that performs the function of listing and switching default printers.

The code is also an excellent example of how you can use classes in your MS Access applications.

Friday, April 08, 2005

New Articles/Downloads on MS Office-related technologies

Desktop Deployment of Office Professional Edition 2003 This overview shows the business value Microsoft gained with the deployment of Microsoft Office Professional Edition 2003 (3/25/2005).

Introduction to the Office 2003 Primary Interop Assemblies Sample Launcher (OPSL) Learn how the OPSL provides code, samples, and a convenient launching program making it easier for developers to see how some of the most prominent methods they use can be coded.

Querying and Updating a Database Using Web Services in InfoPath and ASP.NET Learn how to create a Web service and consume that Web service in InfoPath 2003 SP1 and a Web application using ASP.NET.

Download: Better SQL Server performance with Profiler and Query Analyzer The overall performance of Microsoft's SQL Server can only be as good as the queries that are sent to it. In this download, learn how to use SQL Server's SQL Profiler and Query Analyzer to experiment with alternate constructions of SQL to get better performance.

Latest MS Access KB Articles

Courtesy of kbalertz.com:

How to import a Word table that contains carriage returns (290169) - When you import a Microsoft Word table that contains carriage returns in its cells, the table is not imported correctly because Microsoft Access interprets each carriage return/line feed as a new record delimiter. To avoid this problem, you can...

How to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients (889588) - Describes how to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients.

Cannot edit or update a record on an Access form (209571) - You may not be able to edit a record on a form even though the AllowEdits property of the form is set to Yes . When you try to update data on the form, you may receive the following error message: This Recordset is not updateable. If the form is...

MS05-005: Vulnerability in Microsoft Office XP could allow remote code execution (873352) - This update resolves a security vulnerability that could allow malicious code to run when you store or open Microsoft Office documents from a Web site.

HOWTO: Use TOP N Query from Microsoft Access 2.0 in VB (147724) - One of the new types of queries added to Microsoft Access version 2.0 for Windows is called a TOP N query. If you have Microsoft Access version 2.0 or higher, and Microsoft Visual Basic for Windows version 4.0 and higher, you can use this type of...

How to work with the Outlook E-mail Security Update in an Access database (263084) - Describes that you may receive "A program is trying to automatically send e-mail on your behalf" message when you run the SendObject macro action. Or, you may receive a "run-time error '2293'" when calling the SendObject VBA method in Access.

You receive a write conflict error when you add a record in multi-table view in Access 2002 (295225) - Explains that you cannot insert a record in a multi-table query and you receive a write conflict error if the primary key field of the primary table is an identity field or the query restricts the records to exclude some records from the primary table.

How to create a DSN-less connection to SQL Server for linked tables in Access 2003 and in Access 2002 (892490) - Describes methods for how to create a DSN-less connection to SQL Server for linked tables in Microsoft Access.

When you paste an Excel chart that contains an embedded arrowhead to a Word document, the appearance of the arrowhead changes in Office XP and in Office 2003 (889520) - Discusses a work around for an issue that occurs in Office XP and Office 2003 where an Excel chart that contains an embedded arrowhead does not appear exactly in its original form when it is pasted to a Word document.

No records returned in query between an Access 2000 table and a linked Access 97 table (244137) - No records are returned for a query that joins a Microsoft Access 2000 (Jet 4.0) table to a linked Microsoft Access 97 (Jet 3.5) table. This happens even though you are certain that there are matching records. This behavior can occur only when all...

ACC2000: How to Use a Query to Format Data for a Mail Merge (197520) - In a Microsoft Access table, if you've added formatting to the numbers in a Number field, and you send that data to Microsoft Word through a mail merge, the numbers will lose their formatting when they appear in Microsoft Word. In a mail merge,...

ACC2000: "CREATE TABLE Permission Denied" Error Message in Export to SQL (209656) - When you export a table from Microsoft Access to Microsoft SQL Server, you may receive the following error message [Microsoft][ODBC SQL Server Driver][SQL Server] CREATE TABLE permission denied, database , owner [#262] where...

ACC2000: SQL Server Security Administration Dialog Box Does Not Open (223220) - In Access 2000, if you have not installed the Microsoft Data Engine (MSDE), you can still create Microsoft Access projects and connect to Microsoft SQL Server databases on other computers through a network connection; however, the dialog box for...

ACC2000: Insert Data Permission Required to Modify Table Design (198915) - Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). When you try to open a table in Design view, you may receive the following warning message: You can't open...

How to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients (889588) - Describes how to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients.

Objects are removed when you convert partial replicas from Access 97 to Access 2000 (263171) - You convert a Microsoft Access 97 partial replica to Access 2000. Then you synchronize the Access 97 partial replica with a converted full replica or with Design Master. All the database objects are removed from the converted partial replica...

ACC2000: How to Set AllowZeroLength Property to Yes in All Tables (210278) - This article shows you how to create a user-defined function to set the AllowZeroLength property to Yes for all the Text and Memo fields in every table in a database. By setting the AllowZeroLength property, you can control whether a zero-length...

ACC2000: SQL Server System Administrator Cannot See System Tables (209179) - When a SQL Server System Administrator tries to import or link SQL Server tables to a Microsoft Access database, the administrator can see most of the SQL Server tables, but not the system tables. The System Objects check box in Microsoft Access...

How to work with the Outlook E-mail Security Update in an Access database (263084) - Describes that you may receive "A program is trying to automatically send e-mail on your behalf" message when you run the SendObject macro action. Or, you may receive a "run-time error '2293'" when calling the SendObject VBA method in Access.

OFFXPDEV: Setup Fails Silently When Password Is Changed for Account Running SQL Services (289516) - If you change the account password that SQL services are running under and then install the Workflow Services for SQL Server without changing the passwords that are stored in the computer's services, the Setup program of Microsoft Office XP...

Photo Editor Help topic refers to Office 2000 instead of Office XP (292124) - Explains that the Help topic refers to Office 2000 when you use Help for information about how to install or remove Photo Editor, but you expect it to refer to Office XP. To work around this issue, click Microsoft Office XP in step 4 of the Help...

The Office XP Shortcut Bar shortcut does not start the Office XP Bar (290744) - Explains that when you click the Office Shortcut Bar shortcut, the Office Shortcut Bar does not appear or the Office 2000 Shortcut Bar appears instead. You can add the Office XP Shortcut Bar through the Office XP CD-ROM in maintenance mode.

MS05-005: Vulnerability in Microsoft Office XP could allow remote code execution (873352) - This update resolves a security vulnerability that could allow malicious code to run when you store or open Microsoft Office documents from a Web site.

You receive an "Access denied" error message, and the program unexpectedly quits when you try to open or save a file in an Office program (891636) - Describes an issue where you receive an error message, and the Office program unexpectedly quits when you try to open a file that is located in a redirected folder or when you try to save a file to a redirected folder.

OFFXPDEV: Cannot Deploy Solution That Is Based on a Copy of the Issue Tracking Workflow Template (287069) - When you try to instantiate a template that you created from the Issue Tracking Workflow sample template, you see the following error in a window named DCOM Server modTBAD failure : [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object...

You receive an "Error 1606" error message when you try to install or remove a Microsoft program (886549) - Discusses an issue where you receive an "Error 1606" error message when you try to install or remove a program such as Streets and Trips, MapPoint, Picture It!, Digital Image Pro, or Money.

Step by Step Interactive tutorials and Getting Started tutorials for Office products do not start (301535) - When you try to use Step by Step Interactive tutorials that is included in Microsoft Office XP, or Getting Started in Microsoft Visio 2002 Help, or Getting Started Tutorial in Microsoft Office Visio 2003, you may experience one of the following...

When you paste an Excel chart that contains an embedded arrowhead to a Word document, the appearance of the arrowhead changes in Office XP and in Office 2003 (889520) - Discusses a work around for an issue that occurs in Office XP and Office 2003 where an Excel chart that contains an embedded arrowhead does not appear exactly in its original form when it is pasted to a Word document.