Monday, September 27, 2004

New MS Office Downloads:

Office 2003 Editions: Excel VBA Language Reference
Office 2003 Editions: Office Web Components VBA Language Reference
Office 2003 Editions: Outlook VBA Language Reference
Office 2000 Outlook Today information and sample files (2)
HTML Help Workshop sample files Sample cascading style sheet (CSS) files to use with HTML Help Workshop. Download HTML Help Workshop from the MSDN Online Web Workshop.
Office 2000 Outlook 98/2000 E-mail Security Update White Paper
Office 2000 Outlook Bar reference information
Office 2000 Outlook 2000 SR-1 Security and Encryption White Paper
Office 2000 Resource Kit Readme file — updated August 31, 1999 Additional information about Office 2000 and Office Resource Kit tools and documentation. The latest version includes notes about reinstalling Office with your original customized settings.
Access 2000 Runtime for Terminal Server
Office 2000 Outlook Information A sample Microsoft Outlook profile.
Office 2000 transform for Setup error messages Copy this transform (MST file) to your computer in the same folder as the Office 2000 Setup.exe and Setup.ini files.
Office 2000 Multilingual Deployment Guide
Microsoft Office Project Initiation Tool An add-in for the Microsoft Office Accelerator for Six Sigma that enables you to easily capture and rank new project ideas, approve them, and initiate the project within Microsoft Project Server 2003 SP1. The tool tracks the progress of each idea through its approval process.
Microsoft Office Information Bridge Framework 1.0 - Updates

Friday, September 24, 2004


Office XP Security Update: KB832332 The latest security update for Microsoft Office XP.


New MS Access KB Articles

Use this URL:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;xxxxx
where xxxxx is the Article No.

209045 ACC2000 Sample expressions to extract portion of text string in Access 2000
208191 ACC2000 Can't See Controls Placed in Tab Area of Tab Control
209053 ACC2000 Cannot Delete the Admin User
209062 ACC2000 Shortcut Method for Creating an SQL Union Query
208203 ACC2000 ActiveX Controls Do Not Appear in the Expression Builder
209075 ACC2000 Unexpected Pointer Behavior in Text Box with Input Mask
207591 ACC2000 Table Filter Is Lost After Importing Table
208222 ACC2000 "The Replication ID You Entered Is invalid" Error in Query
199028 ACC2000 Cannot Use acOLEDelete to Clear Object Frame
205085 ACC2000 Can't Import Modules from Protected VBA Project
205183 ACC2000 How to Create a Grouped Running Sum in a Query
197220 ACC2000 Cannot Completely Remove Form Filter
199113 ACC2000 Error with Subform Based on Hierarchical ADO Recordset
203383 ACC2000 Error When You Paste a Field into Navigation Section
203627 ACC2000 Synchronization Fails When System Date Is Greater Than 2038
199138 ACC2000 Copying Linked Table Does Not Create Local Table
199140 ACC2000 #Error in Linked Spreadsheet After Closing File in Excel
199197 ACC2000 Error Message When You Choose Not to Install Northwind
872834 ACC2003 Issues that are fixed in Access 2003 by Office 2003 Service Pack 1
875286 ACC2003 The "Analyze Databases" button may not be available in the "Scan for Databases" form after you select a scanned database
875287 ACC2003 Description of the "RecordCount" property, the "NoConvertDialog" property, and the "Compiled State" property and their possible values when viewed in the Access Conversion Report Tool
875288 ACC2003 The Access Conversion Scanning Tool does not collect Access properties information for Access databases
875289 ACC2003 Description of how to run the Access Conversion Scanning Tool at the command-line interface
875290 ACC2003 You may receive the "Invalid command line" error message when you run the Access Conversion Scanning Tool at the command prompt
832510 ACC2003 How to add a digital signature to an Access 2003 run-time application
870753 ACC2003 Description of the Jet 4.0 Database Engine post-837001 hotfix package July 21, 2004
883867 ACC2003 BUG A control on a form or on a report that refers to a control on a subform or on a subreport is blank in Access 2003
870961 ACC2003 Description of how to run multiple versions of Microsoft Access with Access 2003
884185 ACC2003 BUG You may receive an error message when you try to insert a new record in a table that contains an Autonumber field in Access 2003
870962 ACC2003 References that you may have to set when you work with databases in Access 2003
838900 ACC2003 Description of the Access 2003 post-Service Pack 1 hotfix package August 20, 2004
823224 ACC2003 Access queries with a wildcard character do not export data to an XML document
883866 ACC2003 The display of a data Access page is blocked in Web Page Preview mode on a computer that is running Windows XP Service Pack 2
840258 ACC2003 BUG You may receive a "Data provider failed while executing a provider command" error message when you try to Access a three-tier data Access page that is bound to a security-enhanced Access database or to an SQL Server database
841413 ACC2003 The Database window may not appear when you open an existing Access database or an existing Access project
871060 ACC2003 The first page of the Package Wizard or the Custom Startup Wizard appears blank in Office Access 2003 Developer Extensions
842004 ACC2003 How to create a distributable Access run-time application by using Microsoft Office Access 2003 Developer Extensions
191883 ACCESS Data Changes Are Saved to the Incorrect Record

Thursday, September 16, 2004

Get trained!

Fundamental Microsoft Jet SQL for Access 2000
Program Pivot Tables for Access Forms
Using Automation in Access 2003 to Work with Outlook 2003
Access training roadmap
MS Access Functions Reference
Access 2003 VBA Language Reference
MS Office 2003 Research Services How To's:

Getting Started with the Research Service Development Extras Toolkit for Office 2003 Edition Overview of the items included in the toolkit—Research Services Class Library, Research Services Class Library Samples, Research Services Class Library Wizard, and the Research Services Tracing and Validation Tool.
Introduction to the Office 2003 Research Services Class Library How to use the Research Services Class Library to abstract often-used features of the Office 2003 Research task pane into a simple object model wrapper that produces the XML defined by the Research Service’s XML schemas.
Customizing Time-Out Values for Office 2003 Research Services How to adjust the time-out value of the Research feature to accommodate the time requirements of different research services so that users are more likely to find the information they want.

Access 2.0 Converter

Access 2.0 Converter for Access 2003 The Access 2.0 Converter is used by MS Access 2003 to convert files from the Access 2.0 file format

Tuesday, September 14, 2004

New Articles and Downloads from MSDN

From the SmartAccess Newsletter:
Access Interfaces: Creating Paired Listbox Controls, Part 1 How to create linked Listbox controls and base them on a single table, two tables, or even data created at runtime.
Access Interfaces: Creating Paired Listbox Controls, Part 2 Create paired listbox controls by adding two additional functions: deferring data updates and restoring initial contents.
Signing Access 2003 Projects How to digitally sign your code.
Lost in Translation How to create an application to be deployed in different languages for different locales or different groups of users.
Managing State Transitions How to use lookup tables to handle hierarchies as well as complex state transitions.

Hardcore Visual Basic: Database Developer Corner: Managing Disconnected Data in ADO and ADO.NET Demonstrates fabricated RecordSets in VB6 and DataTables in VB.NET.

Office XP Security Update KB832332 offers the highest levels of stability and security available for Microsoft Office XP.

Friday, September 10, 2004

Articles on New MS Office Technologies:

Using the XML Features of the Excel 2003 Object Model Explore the XML-related objects, methods, and properties in Excel 2003.
Using an ADO.NET DataSet as a Reporting Services Data Source How to build a data processing extension for Reporting Services using an ADO.NET DataSet as a data source.
Data Points: Handling Data Concurrency Using ADO.NET How to handle data concurrency violations in ADO.NET.

Thursday, September 09, 2004

Latest MS Knowledge Base Articles for Access 2003:
823224 Access queries with a wildcard character do not export data to an XML document
840258 BUG: You may receive a "Data provider failed while executing a provider command" error message when you try to access a three-tier data access page that is bound to a security-enhanced Access database or to an SQL Server database
841413 The Database window may not appear when you open an existing Access database or an existing Access project
842004 How to create a distributable Access run-time application by using Microsoft Office Access 2003 Developer Extensions
842532 Description of Office 2003 Service Pack 1
871060 The first page of the Package Wizard or the Custom Startup Wizard appears blank in Office Access 2003 Developer Extensions
883866 The display of a data access page is blocked in Web Page Preview mode on a computer that is running Windows XP Service Pack 2

Copernic Desktop Search Freeware I have just discovered a cool new indexing/search freeware application that you can use to search within the files on your PC. Copernic Desktop Search uses a small search box in your Windows Taskbar to search your PC or the web. It also indexes and search all your Outlook folders and contact lists. You can use Boolean connectors as well as nested searches in parentheses. A preview pane displays the full text of each document in the results list and highlights all search terms. Results can be sorted by folder name, date modified, or file type directly from the results panel. You also have several options to control the indexing process. Content can be saved as it is indexed, at a specific time, or at regular intervals. You can also selectively index folders. Download Copernic Desktop

Latest MS Access 2003 Sample Applications from Microsoft Go to the Microsoft Developer Center Sample Code Page to download a stack of sample MS Access databases. Many demonstrate the new technologies in Access 2003.

Get the latest service pack for the Microsoft Jet 4.0 Database Engine Go to this MS KB Article for info and downloads.

Wednesday, September 08, 2004

New MS Office Tools

Introduction to the Smart Tag Explorer and Smart Tag Recognize Tester New utilities to help smart tag developers quickly build efficient, stable, and robust smart tags for a variety of applications.

Office 2003 Toolkit: Research Service Development Extras Provides tools, white papers, and code samples of building research services for MS Office 2003.

Office 2003 Document: Overview of Developer Technologies An overview of developer technologies and tools for building custom solutions for MS Office 2003 Editions.


Friday, September 03, 2004

MS Office 2003 Articles and Code Samples

Using the XML Features of the Access 2003 Object Model Explore the XML-related objects, methods, and properties in Access 2003, as well as changes to the XML Object Model and code samples.

Using the XML Features of the Excel 2003 Object Model Explore the XML-related objects, methods, and properties in Excel 2003

Digitally Signing Data in InfoPath 2003 Use new features and object model members to customize and extend digital signatures capabilities in your InfoPath 2003 form templates.

Thursday, September 02, 2004

MS Office resources:

Office Talk: Search Inbox Data Using Smart Tags in Word 2003
Use smart tags in Word 2003 to create search queries against the Exchange message store, search the message store programmatically to acquire results, and then import the search result data into a Word document.

Schemas in ADO.NET 2.0 Use the enhanced support in ADO.NET 2.0 to access metadata in your data sources.

New MS Access links:

http://www.accessdatabasetips.com/

http://www.databasedesign-resource.com/