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.

Wednesday, March 30, 2005

XML, SQL Server, and Excel

Recent articles on these MS Office related technologies.

Excel 2003 Sample: Replicating Formulas to SQL Server Learn how to automate a process for storing Excel 2003 formulas in a SQL Server database. This allows access from the database to the calculated spreadsheet values available only in the worksheet.

Automating the XML Data Mapping Process in Excel 2003 In the first of a three-part series, learn how to use XML maps to customize Excel as a data input and display system.

XSH: Interactively Manipulate and Analyze XML Data from DevX.com's XML Zone. Most developers use some kind of XSLT engine to pick out and process data from structured XML files. Learn how XSH, an open source command-line XML shell, lets you interactively query and manipulate this data without the coding overhead.

Tuesday, March 29, 2005

MS Access Code Samples
A collection of MS Access code samples, with articles, from Microsoft for Access 2003 and previous versions.

Access 2003

Create a PowerPoint Slide Presentation from Scratch Using Access Data Create a slide presentation, as well use an existing PowerPoint presentation inside an Access form.

Use Automation with Access and Outlook Demonstrates using automation to control one program from another program.

Animate Access 2003 Use the Animation ActiveX control, the Timer control, and the Office assistant to animate Access 2003.

Perform Mail-Merges Using XML Data How to use an external XML data file and the Mail Merge feature of Word 2003 to perform a mail merge programmatically from Access 2003.

New XML Features in Access 2003 This download contains several sample files that demonstrate how to import, export, and transform XML data programmatically into Access.

Access 2002

Write Setup Packages for Your Access Databases How to create a custom .msi setup program for your Access database and supporting files.

Program PivotTable Reports in Access 2002 How to programmatically build and manipulate PivotTable reports in Access 2002.

Program OLAP Databases from Access Using DSO How to use the DSO library to create and manipulate OLAP databases and cubes on an Analysis server.

Manage SQL Server Security with Access How VBA projects provide routines to manage SQL Server security settings.

Transform Access XML Files into HTML with XSLT Demonstrates the transformation of Access 2002 XML data into HTML.

Access 2002 Samples These samples demonstrate some of the new features in Access 2002, specifically in Data Access Pages.

Program Printer Settings in Access 2002 How to take a Word document formatted in Outline View and display it as a PowerPoint presentation slide show.

Access XML Import and Export This sample shows how data, schemas, and presentations can be imported to and exported from Access 2002 through the use of XML.

Access 2000

Develop Client/Server Solutions with Access 2000 Projects How to create and work with Access project (.adp) files. The samples accompany a series of articles from the online book, "Developing Client/Server Solutions with Access 2000 Projects," in the MSDN Library. (February 2000)

Access Workflow Designer Call-Tracking Sample Team Solution How to take advantage of the Call Tracking sample team solution. The sample accompanies the article, "Microsoft Access Workflow Designer Call-Tracking Sample Team Solution," in the MSDN Library. (January 2000)

Fundamental Microsoft Jet SQL for Access 2000 Demonstrates the basic mechanics of using Jet SQL to work with data in an Access 2000 database.

Intermediate Microsoft Jet SQL for Access 2000 Sample and article build on the concepts covered in the Fundamental SQL article and gives a much more detailed picture as to what can be accomplished with Microsoft Jet SQL in Access.

Advanced Microsoft Jet SQL for Access 2000 Focuses on the SQL syntax that is most often found in a multi-user environment.

Northwind Traders Direct Sample Application A simple e-commerce application that uses data access pages, frames, and cookies. It was created using Microsoft FrontPage 2000 and Microsoft Access 2000. (January 1999)

Get to Know the Lastest MS Office Technologies

Desktop Deployment—Office 2003 Overview of business value Microsoft gained with the deployment of Microsoft Office Professional Edition 2003.

Using .NET to Boost Microsoft Office Developer Productivity From DevX.com. With Visual Studio Tools for Office, MS Office developers get access to the full power of Visual Studio .NET for building Office applications.

Friday, March 25, 2005

VBA Error Logging

AccessAdvisor.com has just published a timely article on The Value of VBA Error Logging. The article makes the point that any error handling scheme is incomplete unless it includes an error log, and provides some sample code.

My MS Access Add-In, 123 Error-Handler Wizard, can instantly add error-handling and error-logging to your Access databases:

  1. The Wizard reviews your database and identifies all procedures without error-handling, and reports the On Error... statement for all other procedures.
  2. You select which procedures to add error-handling to, or you can opt for global error-handling using a global error-handling procedure and an error-log table.
  3. The Wizard adds error-handling to the selected procedures in one automated operation.


Converting VBA to VB.Net in MS Office

Excellent overview articles on these new technologies:

Convert VBA Code to Visual Basic .NET When Migrating to Visual Studio 2005 Tools for Office Read this article for reasons to migrate your VBA code to Visual Basic .NET and Visual Studio 2005 Tools for Office, a review of the major code conversion issues, and a list of additional resources.

Microsoft Office Information Bridge Framework 1.0 The Microsoft® Office Information Bridge Framework 1.0 enables developers to quickly create and deploy flexible, custom solutions that adapt to an organization’s existing IT infrastructure and require little or no adjustment of back-end systems.

Thursday, March 24, 2005

Roadmap to Microsoft Technical Resources and Support

Useful Microsoft links:

Product Solution Center Product support information, including common issues, frequently asked questions, helpful links, tips and how-tos, and latest downloads.

Public Newsgroups Including advice from Microsoft Most Valuable Professionals (MVPs).

Managed Newsgroups MSDN managed newsgroups are available in English to MSDN Universal, Enterprise, Professional and Operating Systems subscribers to receive free technical support on select Microsoft technologies as well as to share ideas with other subscribers.

Support WebCasts Tune in and watch live technical presentations given by Microsoft technology experts, and participate in live Q&A sessions after each presentation.

Community WebCasts Get live and on-demand access to a wide range of technical and business guidance from industry experts.

Community Blogs Browse these Microsoft employee blogs to get insights and opinions about using Microsoft technology and software.

Technical Chats Microsoft provides you a forum to engage in discussions about Microsoft products or technologies in many languages.

Technical Community Sites Find online technical communities for the Microsoft products and technologies you use.

Regional Directors Regional Directors aren't Microsoft employees--they're independent developers, architects, trainers, and other professionals who provide a vital link between Microsoft and the developer community.

ISV Buddy Program Through this 1-on-1 relationship, your Microsoft buddy will be able to guide you to resources and to help you succeed in building solutions on Microsoft platforms.

Friday, March 18, 2005

Latest MS Access KB Articles

Courtesy of kbalertz.com:

895618 OFFXP: An Office XP update does not appear to be installed after you install the update.

895469 ACC2002: Description of the Access 2002 post-Service Pack 3 hotfix package: March 3, 2005

888636 ACC2003 Documenter does not display the DELETE query in Microsoft Access

888696 ACC2003: How to print a check box without borders on a pre-printed form in Access

Friday, March 11, 2005

NATIVE SideBar MS Access Switchboard and GUI Demo
for Microsoft© Access 97 and 2000/2002/2003

My latest Access Demo Database featuring Outlook-style application navigation is now available. A special feature of the Native SideBar Switchboard is that it uses only native Access controls, so it is easy to implement. Just import three objects into your database: a query, a form, and a code module.

Thursday, March 10, 2005

VBA vs VB.NET

This week Microsoft announced termination of mainstream support for VB6 at the end of this month, with extended support ending in March 2008. A petition by MVPs has been lodged seeking reversal of this decision, and has also raised the issue of support for VBA.

The current product support life cycle for VBA is:

. Mainstream support ends 31-Dec-08
. Extended support ends 31-Dec-13

so there is some life left in VBA yet.

Also, Bill Gates is on record that VBA will be supported in Office 12 due out in mid-2006, but not after version 12. This should mean that the support life cycle for VBA will move well beyond these dates once Office 12 is released.

This provides some comfort for Office developers like me and, more importantly, users that are still using VBA and avoiding the unwelcome complexities of using the .NET framework.

I consider Microsoft will need to eventually backtrack and continue to support VBA for many years to come for these reasons:

  1. The retail versions of Office in use for at least the next decade will directly support only VBA.
  2. Office as well as a development environment is equally an end-user product, and I don't hear anyone talking about VB.NET macros...
  3. The current .NET framework push ignores small business users, who don't want or need the complexities that come with VB.NET.

Monday, March 07, 2005

Documenter does not display the DELETE query in Microsoft Access

Microsoft recently issued a Knowledge Base Article on a documentation bug in Access versions 2000 and later: 888636 Documenter does not display the DELETE query in Microsoft Access.

The native Access documenter does not document DELETE queries in a database. Certain workarounds are suggested by MS, or you can use my Ezy Documenter Access Add-In to seamlessly document all objects in your Access database, including DELETE queries:



There are two versions:

  • Ezy Documenter standard is free to buyers of any product from aadconsulting.com or for a one-off subscription fee of US$9.95, which also gives you access to 18 other Access tools.
  • Ezy Documenter Premium allows user customization of each Ezy Documenter database object report and costs only US$29.95

Sunday, March 06, 2005

I wish I could do this in MS Access...

There are things that Access users and developers often do in Access that could be a lot simpler or that they can't do at all. Over the years, I have developed some tools for Access versions 97 to 2003 to make up for some missing functionality. The following tools are available from my web site at aadconsulting.com:

  1. Ezy Debug A frustration in debugging in Access 2000 and later is the clunky rigmarole required to turn error-trapping on and off. My free tool Ezy Debug is launched from the right-click popup menu in the code window of the Access VB Editor. The applet provides quick access to the Access error-trapping settings in the code window, and once invoked it is available both in the Access Database and VBE window. The current error-trapping setting is displayed and can be changed on the fly...
  2. Ezy Access Launcher If you need to support multiple versions of Access, you know that opening an .mdb file in the correct version of Access in Windows Explorer is not straight-forward. My free tool Ezy Access Launcher automatically opens Access files in the appropriate version, and you can easily create Access shortcuts containing the full range of Access command-line switches.
  3. Find Databases Wizard Want to to locate and document the location of all Access files in a particular location? My free applet, the Find Databases Wizard finds all the MS Access files in the location you select and classifies each file by Access version, lists all the files found in the location, and saves the data in a text-delimited file.
  4. Ezy Exporter Wouldn't it be great if you could export Access objects in bulk in the same way Access natively allows you to bulk import objects into a database? My Access tool, Ezy Exporter allows you to do just that.
  5. Ezy SQL Editor and Builder is a sophisticated tools for handling SQL in Access, but it also has some basic features that makes working with queries a whole lot easier by providing a Font... option when editing SQL strings, and adding find/replace functionality.

Latest for MS Office Developers

Customizing List Item Forms in Windows SharePoint Services Enhance and extend interaction with lists in Microsoft Windows SharePoint Services when customizing forms used to work with list items.

Accessing FrontPage Commands Using VBA Discover how to access almost every FrontPage command from your VBA code—even commands that aren't available through the FrontPage object model.

Creating Excel Solutions for Use in Multiple Countries/Regions Using Visual Studio Tools for Office Learn which issues you should consider when using Visual Studio Tools for Office to create Excel 2003 solutions for deployment to end users in more than one country or region.

Enabling SSL Protection on MCMS Sites Learn how to set up Secure Sockets Layer (SSL) for your Microsoft Content Management Server (MCMS) 2002 site.

Thursday, March 03, 2005

Latest MS Access KB Articles

Courtesy of kbalertz.com:

889520 ACC2002 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

892490 ACC2002 How to create a DSN-less connection to SQL Server for linked tables in Access 2003 and in Access 2002

892608 ACC2003 You may receive the "Syntax error in INSERT INTO statement" error message when you use ADO.NET code to access Office Access 2003

887035 ACC2003 Your XML data may appear to incorrectly import when you try to import that data to Microsoft Office Access 2003

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

889490 ACC2003 Contents of the Memo field may appear as control characters when you use the GROUP BY clause on the Memo field in a query in Microsoft Access

873334 ACC2003 Description of the Italian version of Access 2003 post-Service Pack 1 hotfix package: December 17, 2004

Wednesday, March 02, 2005

Latest Resources for MS Office

How Excel 2003 Infers XSDs When Importing XML Review the rules and instances where Excel 2003 infers schema from XML data during import and export.

Customizing Office 2003 Research Services: 15 Answers to Common Questions Common issues facing developers when customizing the Office 2003 Research Services including tips about formatting data, scaling images, and encoding data.

Customizing Microsoft Office Information Bridge Framework for Microsoft CRM Learn to customize the Microsoft Office Information Bridge Framework for Microsoft Business Solutions CRM to meet the unique needs of your business organization.

Visual Studio .NET Developer: Introducing a New Data Grid The .NET 2.0 DataGridView supersedes the .NET 1.x DataGrid control. The DataGridView supports extensive customization and fine-grained formatting, flexible sizing and selection, better performance, and a richer event model.

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.

Monday, January 31, 2005

Get Your Head Around ADO

Visit MSDN's ADO Programmer's Guide which provides an overview of how to use ADO objects to work with data from various data sources.

Sunday, January 30, 2005

Latest MS Access KB Articles

Courtesy of kbalertz.com:

101084 ACC97: Storing SQL Database Login IDs and Passwords Locally
109829 ACC97: Sample Function to Provide Password for Attached Tables
120911 ACC97: Ability to Add Users Without Permission to View Design
128808 ACC97: Optimizing for Client/Server Performance
135378 ACC97: Connection String Is Accessible in Secured Databases
135379 ACC97: New SQL Records Appear Deleted Until Recordset Reopened
209656 ACC2000: "CREATE TABLE Permission Denied" Error Message in Export to SQL
223220 ACC2000: SQL Server Security Administration Dialog Box Does Not Open
889588 ACC2000: How to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients
198915 ACC2000: Insert Data Permission Required to Modify Table Design
209179 ACC2000: SQL Server System Administrator Cannot See System Tables
210278 ACC2000: How to Set AllowZeroLength Property to Yes in All Tables
836178 ACC2003: "Invalid product key" error message when you start an Office 2003 program after you install Office Professional Edition 2003
New Tool Makes Using MS Access a WHOLE lot Easier!

Access is intimidating for new users and the learning curve is steep. I have created a new free tool, Ezy Access 2000, that makes using Access a WHOLE lot easier: an Access database for retail MS Access that lets you easily create Access databases with little or no knowledge of Access:

Friday, January 28, 2005

Use Dynamic Control in MS Excel

Excel 2003 and Visual Studio Tools for Office, Version 2005 Solution: Using Dynamic Controls and Views Use the .NET Framework in Visual Studio 2005 Beta 1 to utilize managed controls that present and navigate data in ways that Excel does not support out-of-the-box.

A Fool-proof Way to Add a Library Reference in MS Access

From my MS Access Tips page at aadconsulting.com:

Those of you who develop Access add-ins or library databases, know that adding a reference to the addin or library database to the user .mdb can be tricky, as the library file may not be where it is expected to be. I use the following function, which is called each time the library file is loaded and uses the Name property of the CodeDb function to return the full path of the library file:

Private Function aad_AddLibraryReference() As Boolean
On Error GoTo AddLibraryReferenceError

Dim aad_refBuilderLibrary As Reference

Set aad_BuilderLibrary = References.AddFromFile(CodeDb.Name)
aad_AddLibraryReference = True
Exit Function

AddLibraryReferenceError:

If Err = 32813 Then 'Reference already exists
Resume Next
Else
MsgBox "Add LibraryDB Reference Error" & Err & ". " & Err.Description
aad_AddLibraryReference = False
Exit Function
End If

End Function


Major flaws in Microsoft Office file encryption

January 28, 2005 A major problem with the way Microsoft's encryption tool handles Word and Excel files has been discovered. This flaw could allow a cracker with basic cryptography skills to decrypt files. Details

Monday, January 24, 2005

EXCEL: Integrate Data into Your Spreadsheets

Integrate Data into Your Excel Spreadsheets with Office Web Services This MSDN Article discusses:
  • How you can integrate data from several Web services using Excel & VBA
  • The features of the Office Web Services Toolkit
  • How you can manipulate your data in Excel and use it to create reports
  • A sample application to get you started
Haloscan commenting and trackback have been added to this blog.

Sunday, January 23, 2005

The Easy Way to Parse Your MS Access SQL String for Insertion into Your Code

My MS Access Add-In and Wizard, Ezy SQL Editor & Builder, easily creates formatted SQL strings for your code. Ezy SQL automatically parses any SQL string, for example, from:

SELECT City, CompanyName, ContactName, "Customers" AS [Relationship] FROM Customers
UNION SELECT City, CompanyName, ContactName, "Suppliers"FROM SuppliersORDER BY City, CompanyName;

to:

strSQL = _
"SELECT City, CompanyName, ContactName, 'Customers' AS [Relationship] " & _
"FROM Customers " & _
"UNION " & _
"SELECT City, CompanyName, ContactName, 'Suppliers' " & _
"FROM Suppliers " & _
"ORDER BY City, CompanyName; "






Latest MS Access Knowledge Base Articles

Courtesy of kbalertz.com:

You may receive the "Method 'CurrentDB' Of object '_Application' failed" error message in Access 2000 or a later version (887033)

Slower performance in Access-based or Jet database-based programs after you upgrade from Windows NT 4.0 to Windows 2000 or to Windows XP (891176)

How to 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.

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 ...

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, ...

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 ...

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 ...

You receive a "Not a Valid Password" error message when you open an Access 97 database in Access 2000 (246033) - When you open a Microsoft Access 97 database in Microsoft Access 2000, and if the database password has 14 or more characters, you may receive the following error message: Not a valid password. To work around this behavior, follow these steps: ...

A newly created Access 97 database is not secure when you convert a security-enhanced Access 2000 database to Access 97 format (198986) - When you convert a security-enhanced Microsoft Access 2000 database to Microsoft Access 97 format, the newly created Access 97 database is not secure. Permissions are reset to their defaults in the newly created Access 97 database. This problem ...
Latest MS Office Stuff from Microsoft:

Smart Tags: Realize the Potential of Office 2003 by Creating Smart Tags in Managed Code Learn how to build and deploy managed smart tags, and how they work with Microsoft Office Smart Tag List XML schema, advanced managed smart tags for Office 2003, and Office XP.

Office 2003 Smart Document Software Development Kit (SDK) This download provides the software development kit (SDK) for creating smart documents with the Microsoft Office System (1/14/2005)

Installing and Using the Office 2003 Primary Interop Assemblies Find out how to get, install, and use the primary interop assemblies (PIAs) available for Office 2003.

Excel: Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services Make the most of the data returned from your Web services with the Office 2003 Web Services Toolkit API and take advantage of the latest capabilities to customize list views, graphs, and charts.

Friday, January 14, 2005

More MS Office Articles

Handy Tips for Working with Excel 2003 Make your applications more robust and provide more options for your users when you employ and modify these tips from the Excel newsgroups.

Working with PowerPoint Presentations from Access Using Automation Learn to use automation to work with Access and PowerPoint. This gives you the ability to work from inside Access to create a slide presentation as well as use an existing PowerPoint presentation inside an Access form.

Is Your MS Access Installation Fully Patched?

A summary of all essential service packs including download links for Access 2 through to Access 2002.

Wednesday, January 12, 2005

New MS Articles and Sample Applications

Office 2003 Sample: Working with PowerPoint 2003 Presentations from Access 2003 Using Automation Download this sample to work with PowerPoint 2003 presentations directly from Access 2003. This sample accompanies the MSDN article "Working with PowerPoint 2003 Presentations from Access 2003 Using Automation," available from Related Resources.

Smart Access: Access Interfaces: Building Explorer-style Forms This article and sample application looks at the surprisingly simple process of implementing an Explorer-style form architecture using the TreeView component that's part of the Windows XP Common Control Library.

Creating an Office 2003 Research Service Using the Amazon Web Service API Search for books at Amazon.com using the Amazon.com research service, then include the results returned in your sheet or document without leaving your Office 2003 application.

Creating a FrontPage Drop-Down Menu with JavaScript If you've ever tried to create a drop-down menu, you probably know it’s not always easy. This article provides the detail you need to start developing your own—as well as JavaScript for three kinds of drop-down menus.

Handy Tips for Working with Excel 2003 Make your applications more robust and provide more options for your users when you use and modify these tips from the Excel newsgroups for your own use.

Tuesday, January 11, 2005

New MS Access Tips Page

I recently posted a new Ms Access Tips page to aadconsulting.com with over 85 tips for Access users and developers. Check it out.

Wednesday, January 05, 2005

Getting Up to Speed: An Access Book Recommendation

Jak in a post asked for a recommendation on a beginner/intermediate Access book. My first Access book was Access 2 Developers Guide by Roger Jennings, and his latest is my recommendation Special Edition Using Microsoft Office Access 2003.

Wednesday, December 29, 2004

Latest MS Access Knowledge Base Articles

Courtesy of KBAlertz.com:

How to 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.

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 ...

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, ...

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 ...

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 ...

You receive a "Not a Valid Password" error message when you open an Access 97 database in Access 2000 (246033) - When you open a Microsoft Access 97 database in Microsoft Access 2000, and if the database password has 14 or more characters, you may receive the following error message: Not a valid password. To work around this behavior, follow these steps: ...

A newly created Access 97 database is not secure when you convert a security-enhanced Access 2000 database to Access 97 format (198986) - When you convert a security-enhanced Microsoft Access 2000 database to Microsoft Access 97 format, the newly created Access 97 database is not secure. Permissions are reset to their defaults in the newly created Access 97 database. This problem ...

Friday, December 17, 2004

Sorting Out Order Of Events in MS Access Objects

Order of Events for Access Database Objects An excellent interactive article from MS that takes you through the labyrinth...

Thursday, December 16, 2004

Easier MS Access Debugging

A big frustration in debugging in Access 2000 and later is the clunky rigmarole required to check/set error-trapping. Now you can dramatically simplify the process with my new free Access COM AddIn. Ezy Debug is launched from the right-click popup menu in the code window of the Access VB Editor. The applet provides quick access to the Access error-trapping settings in the code window, and once invoked it is available both in the Access Database and VBE window. The current error-trapping setting is displayed and can be changed on the fly... Free download


Improving MS Access Performance

Improve Access Performance by Turning Off Track Name AutoCorrect A performance tip for boosting performance from AccessAdvisor.com: By default, Access 2000 and higher maintain a list of changes to database objects and will automatically change references to those objects on forms and reports. For instance, changing the name of a field in an Access table will ripple throughout the application, and all references to the field in forms and reports are automatically updated. Unfortunately, Access imposes a tremendous overhead on the AutoCorrect feature... Read the Full Tip

Wednesday, December 15, 2004

New on MSDN:

Smart Access: Invisible Forms Revisited: Park Your Global Values Here! How adding an invisible form to your application can make a number of difficult tasks much easier.

What's New and Different for the Access Developer Moving to SQL Reporting Services Review Microsoft SQL Server Reporting Services, specifically the key advantages, similarities, and differences between Microsoft Access reports and SQL Reporting Services reports.

Friday, December 10, 2004

New MS Office Migration White Papers

Office 2000 to Office 2003 Migration Issues Possible problem areas administrators might encounter when moving from Office 2000 to Office 2003.

Microsoft Office XP to Microsoft Office 2003 Migration Issues Possible problem areas administrators might encounter when moving from Office XP to Office 2003.

Wednesday, December 08, 2004

MS Access Tip: Use Field Descriptions

Often overlooked is the easy way to document tables fields and automatically provide data entry guidance to users. In Table Design view, express the Description for each field as you would describe it to users making data entries. Access automatically displays the description in the Access status bar in a table's datasheet view and in forms.

Monday, December 06, 2004

Hot off the Press:

Moving Your Access 2002 Database to SQL Server 2000 Use this features comparison in preparation for moving your MS Access 2002 database back-end to SQL Server 2000.

Visual Studio Tools for Office, Version 2005 Beta 1 Code Samples

Visual Studio Tools for Office, Version 2005 Beta 1 IntelliSense Code Snippets This MS download contains 200 IntelliSense Word and Excel code snippets for use with Visual Studio Tools for Office, Version 2005 Beta 1.

Wednesday, December 01, 2004

Analyze XML data with MS Excel 2002/2003

A handy tip from TechRepublic.com. Excel 2002/2003 lets you open and analyze an XML file as a native Excel file. You can use all of Excel's analysis tools, including pivot tables and pivot charts, with XML data. Use File Open, and select XML Files from the Files Of Type drop-down list. Navigate to the XML file you want to open, and click Open. Excel displays XML tags as column headings and lists the data in the rows below the appropriate column headings. For example, in an XML Orders file, every Orders element may have Ship Region as a child element. In the worksheet, Excel represents the child element as the column header /Orders/Ship Region/. Excel opens XML files as read-only files, so users can't make changes to the original file while analyzing it in Excel.

New Ms Office Articles from MSDN

Handy Tips When Using MS Word 2003 Tips and VBA code to make your MS Office applications more robust and even provide even more options to users.

Best of Blogs: Visual Studio Tools for Office, Version 2003 Links to blogs that offer first-hand experience and tips for designing, implementing, and deploying smart client solutions built with Visual Studio Tools for MS Office 2003.

Monday, November 29, 2004

Handling Image Storage in MS Access Databases

Interesting articles with many references from ammara.com, the makers of DBPix, an Image Control for building database applications with picture handling capabilities, such as photo databases and other image management systems:

Images - Access image storage Avoiding overhead and loss when storing images in Microsoft Access.
Pictures in Access Forms & Reports Common Access OLE Object Photo & Image Problems including Access 2003.
Access Image Database Techniques Access image-handling approaches compared.


Multiple Column Reports Sample MS Access Database

Access 2003/2002/2000 Sample: Multiple Column Reports Sample Database The Multiple Column reports sample database for Microsoft Access contains sample reports that demonstrate creating telephone book style multiple column reports.

Thursday, November 25, 2004

Download the Latest MS Office Language References

Discover 15 New MS Office 2003 VBA Language References Customise and integrate Office programs with the new Office 2003 language references for Access, Excel, FrontPage, Office 2003, Outlook, PowerPoint, Project, Publisher, Visio and Word. Also, refences for Office XP And Office 2000.

Related Resources:

Tuesday, November 23, 2004

Ditch that Tired and Boring native MS Access Switchboard!

My latest Access Demo Database featuring cutting edge application navigation:




Maximizes available application space by using these dynamic features:

  • Uses Switchboard Items table created by the MS Access Switchboard Manager
  • Outlook-style navigation
  • Custom combined graphical buttons/hyperlinks
  • Users can hide the Switchboard to maximize form size
  • Users can adjust the width of the Switchboard on the fly...

You can use the demo as a Contacts Manager or buy the source code to use the GUI in your own Access applications.

Download the free SideBar Switchboard Demo
(sidebarswbdemo.zip - 4mb includes MSI Installer)

Friday, November 19, 2004

New Free Office 2003 Add-In

Office 2003 Add-in: Microsoft Outlook SMS Add-in (MOSA) Send SMS text messages through most Global System for Mobile Communications (GSM) mobile phones connected to your PC using Microsoft Office Outlook 2003.

Wednesday, November 17, 2004

Database Design: The Danger of NULL values

Does allowing NULL values in fields introduce a whole new degree of uncertainty into your database? Article

Friday, November 12, 2004

Get up to Speed on New MS Office Technologies #2

Creating an Estimate Solution Using Visual Studio Tools for Office, Version 2005 Learn about a basic order entry system that uses Excel 2003 for data entry, calculation, and charting capabilities, and Word 2003 for the generation of a report.

Enhancing Office 2003 Research Services with Graphics and Fancy Fonts how to jazz up a Microsoft Office 2003 research service by displaying results using graphics and special fonts.

Thursday, November 11, 2004

Get up to Speed on New MS Office Technologies:

New DataSet Features in ADO.NET 2.0 Get performance enhancements and improved functionality in the .NET Framework 2.0 DataSet class, and in the closely related DataTable and DataView classes.

Enhancing Office 2003 Research Services with Graphics and Fancy Fonts How to jazz up a Microsoft Office 2003 research service by displaying results using graphics and special fonts.

Creating an Estimate Solution Using Visual Studio Tools for Office, Version 2005 Learn about a basic order entry system that uses Excel 2003 for data entry, calculation, and charting capabilities, and Word 2003 for the generation of a report.

Wednesday, November 10, 2004

Latest Articles and Sample Applications for MS Office Developers

Excel 2003 Sample: Microsoft Excel 2003 Inside Out Sample files from the book Microsoft Excel 2003 Inside Out.

Excel 2003 Sample: Microsoft Office 2003 Inside Out Sample files from the book Microsoft Office 2003 Inside Out.

Access 2003 Sample: Inside Out Sample Files Sample files from the book Access 2003 Inside Out.

MSDE 2000 Deployment Toolkit (Sample Application) Automates the process of creating an integrated package with both the application and the MSDE database.

From MS TechNet:

Tuesday, November 09, 2004

Microsoft Word Help Center

TechRepublic's MS Word Help Center for one-stop tips and tricks for mastering Word's myriad features.

Microsoft Office 12 is coming... Sources close to Microsoft indicate that the next version of Office is coming to beta in August of 2005 with general release by July of 2006. According to the sources, the next Office will have both desktop and server components, including the "Excel Calculation Server" and the "InfoPath Forms Server" along with updated version of Content Management Server and SharePoint Portal Server.

Friday, November 05, 2004

New MS Office Small Business Release to include New Payroll Functionality

Microsoft is set to launch on November 8 its small-business solutions strategy, one element of which will be a new version of Microsoft Office designed expressly for the small-business manager/owner. The new Office release is expected to include new payroll functionality, an updated version of Microsoft's business-contact-manager technology, and new Web services, according to sources close to the company. Microsoft already sells a small-business version of Office, Office Small Business Edition 2003. That product bundles together Word, Excel, Outlook, PowerPoint, Publisher and the current release of business-contact manager. From microsoft-watch

Microsoft Office Outlook 2003 Inside Out: Using VBA in Outlook Introduction to the VBA environment. Provides examples of simple ways to use VBA within Outlook 2003 to automate common tasks.

Wednesday, November 03, 2004

100 Microsoft Office Tricks:

100 MS Office Tricks: Part 1

100 MS Office Tricks: Part 2

Tuesday, November 02, 2004

Tip: Add (All) to a LookUp Combobox

To add (All) as the first item in the droplist of an unbound combobox, replace the RowSource property with the following SQL string:

SELECT City FROM tblRegions
UNION SELECT "(All)" FROM tblRegions;