Tuesday, August 30, 2005

Data Access: Let Your MS Access Users Sort it Out

Data Access: Let Your Users Sort it Out Develop an MS Access solution that allows users to sort the data in their forms (or subforms) that you can add to your application easily, and along the way, the characteristics of a well-designed module.

Saturday, August 27, 2005













Exclusive: A Better ZoomBox for Access

Exlcusive to readers of the Access Extra blog, is my new free tool for Microsoft Access versions 97 to 2003: A Better ZoomBox to edit the following control properties when designing Access Forms and Reports:

  • Record Source
  • Row Source
  • Control Source

Features:

  • Customization saved from session-to-session:

    - font (Arial/Courier New/MS Sans Serif/Tahoma)
    - font size (8-14) - font bold (y/n)
    - Enter Key behavior can be set to "Enter New Line" (y/n)
  • Find/Replace functionality

The Better ZoomBox is invoked by clicking the <...> build button next to each of the above properties in form and report design view.

Friday, August 26, 2005

Office Online Training Courses Quick Reference

Office 2003 Publication: Office Online Training Courses Quick Reference Cards Content This download provides you with complete text and illustrations of all Quick Reference Cards in Training courses published before May 2005.

Saturday, August 20, 2005

Tip: Shortcut to Check a Form's Name in MS Access

In the Query Design window, when invoked from within a form's design view in MS Access, you can't go to the Database Window to check the name of an object while designing a parameter query, and as I do, copy and paste the name into the query (using and then cancelling Rename). A workaround is to invoke the Startup dialog by clicking Tools, Startup... from the Menubar, where you can view all forms in database from the Display Form/Page combobox, select the form in the combox, copy the name, and then click Cancel.
Role Agent for Microsoft Office Live Communications Server 2005

Role Agent for Microsoft Office Live Communications Server 2005 Role Agent is a sample Microsoft Windows service application that demonstrates the use of the Real-time Communications API 1.3 and Microsoft Office Live Communications Server 2005 to support role-based instant messaging (8/16/2005).

Tuesday, August 16, 2005

Latest MS Access KB Articles

Courtesy of kbalertz.com:

Access 2000

  • 905248 Custom changes that you made in the HKEY_CLASSES_ROOT subtree are overwritten after you update or repair the Office installation

Access 2002

  • 904411 Description of the Italian Proofing Tools for Office XP post-Service Pack 3 hotfix package: July 15, 2005
  • 903776 Office updates are not successfully installed on some client computers when you deploy updates by using Windows Server Update Services
  • 905530 FIX: When you create a database or a table, an error occurs and Access unexpectedly closes in Office Access 2003 or in Access 2002

Access 2003

  • 903772 You receive an "Error 80070643" error message when you try to update Office 2003 by using Software Update Services
  • 03074 BUG: A record in a linked SQL Server 2000 database table is not correctly updated when you modify the record in an Access 2003 database table
Latest MS Office Downloads

Excel 2003 Sample: Populating Worksheets with Multiple Related Records from Windows Forms Use this sample to to display Microsoft Windows Forms from a Microsoft Office Excel 2003 workbook, display related records, and write that information into formatted worksheets.

Visual Studio 2005 Tools for Office Beta 2 Sample: Migrating a Word VBA Solution to Visual Basic Using Visual Studio 2005 Tools for Office VBA Migration Case Study based on Microsoft Word 2003, for experienced Office/Visual Basic for Applications developers who are taking their first steps with Visual Studio 2005 Tools for Office.
Tip: Use ADO wildcards in the Access Query Design Grid

In MS Access 2000 or later, if you're using ADO, there is a way to use ADO wildcards in the Access query design grid. Instead of using the Like operator, use ALike, which also works in SQL statements used in VBA code.

Friday, August 12, 2005

Manage MS Access Table Links and Project Connections More Easily

My new MS Access tool, Access Table Links and Connections Manager V1.0 BETA, is now available for free download. The Links Manager will find all the MS Access files in the location you select and an Access report will display all table links and base string connections, and any connect errors grouped by:

  • Jet Version
  • File Type: mdb/mde/mda or adp/ade
  • Linked Database Paths and linked tables: for mdb/mde/mda's
  • Base Connection String: for adp/ade's
  • Separate reports will be produced for .mdx files and .adx. files

Thursday, August 11, 2005

Microsoft Releases XML 3.0 Update (SP7)

MSXML (Microsoft XML Parser) 3.0 Software Development Kit (SDK) The Microsoft® XML Parser (MSXML) 3 SDK includes header and .lib files, and documentation for the MSXML 3 Release.

Microsoft XML Parser (MSXML) 3.0 Service Pack 7 (SP7) The Microsoft® XML Parser (MSXML) 3.0 SP7 release offers a number of bug fixes over the previous MSXML 3.0 SP releases.

Tuesday, August 09, 2005

The Deal on Deploying Windows XP and Office 2003

Business Dessktop Deployment Standard Download planning, building, and technical guidance, templates, and scripts to facilitate deployment of Microsoft® Windows® XP Professional and Office Professional Edition 2003.

Business Desktop Deployment Enterprise Download planning, building, and technical guidance, templates, and scripts to facilitate deployment of Microsoft® Windows® XP Professional and Office Professional Edition 2003 through Zero Touch deployment.

Monday, August 08, 2005

MS Office 2003 Sample: Smart Documents Development Overview

Office 2003 Sample: Smart Documents Development Overview Learn how to create customized, context-sensitive task panes that interact with XML-based files in Microsoft Office Word 2003 and Microsoft Office Excel 2003.

Friday, August 05, 2005

The Latest for Office Developers from MSDN

Register for the Microsoft Professional Developers Conference 2005 Join developers at the Microsoft Professional Developers Conference 2005, where the next waves of Microsoft Windows and Microsoft Office System developer capabilities will be unveiled.

Use Excel 2003 to Create and Manage Windows SharePoint Services Web Sites How various aspects of Visual Studio 2005 Tools for Office, Excel, and Windows SharePoint Services work together in a hypothetical business scenario.

Outlook from the Managed World Get started with building add-ins for Outlook 2003 using the Visual Studio Tools for Office.

Tuesday, August 02, 2005

New Revision Tool for Word

Office 2003 Add-in: Word Redaction By using the Word 2003 Redaction Add-in, you can mark sections of Microsoft Office Word 2003 documents for redaction. You can then create a new, redacted version of the document in which this marked text is unavailable. ReadMe file