Thursday, July 28, 2005

Latest MS Access KB Articles

Courtesy of kbalertz.com:

Access 2000
  • 903275 How to troubleshoot problems that you may experience when you try to activate an Office product
Access 2002
  • 903773 No updates are displayed when you scan for updates by using Microsoft Update or Windows Software Update Services after you connect to a Microsoft Office administrative installation point to reinstall Office
  • 903771 Information about the ability to uninstall Office updates
  • 903097 The installation state of each Office XP program is shown as "Not Available" when you try to perform a custom installation of Office XP or of an individual Office XP program
  • 904411 Description of the Italian Proofing Tools for Office XP post-Service Pack 3 hotfix package: July 15, 2005
Access 2003
  • 903772 You receive an "Error 80070643" error message when you try to update Office 2003 by using Software Update Services
  • 904427 You receive a "Norton AntiVirus 2005 does not support the repair feature" error message when you start an Office 2003 program
Expense Reports Made Easy with MS Office Solutions and InfoPath

Expense Reports Made Easy with Microsoft Office Solutions Video overview of the MS Expense InfoPath client.
MSN Toolbar With tabs for Windows Explorer

If I am not the first to relate this, please excuse my ignorance...

As I became increasingly frustrated with multiple Windows Explorer windows on my Windows XP Desktop, and having to drill down anew to my usual folders in each Windows session, I thought there must be a better way to manage Windows Explorer folders. I thought that if you can have tabbed web browsing, why not tabbed file browsing.

So I started playing with the new tabbed windows browsing functionality in the new MSN Toolbar for Internet Explorer, and discovered that you can setup Windows Explorer folder tabs in IE and save them:


You proceed as follows:

  1. Click the New Tab button to create a new tab in IE
  2. In the IE Address Bar type/paste the root path of the folder, for example, g:\data, and hit Enter
  3. The new tab will go to the folder and display a Windows Explorer window
  4. Continue until you have added all your favorite folders as separate tabs
  5. Click the MSN Toolbar Home button and click the Set Current Pages as My Tabs button:

  6. In you next Windows session click Open My Tabs to load all your folder tabs... very neat :)

Tuesday, July 26, 2005

Free BETA of SmartForm ADP for Access2000/2002/2003 ADP Projects

Try the Free BETA of my latest MS Access Add-In: SmartForm ADP for Access2000/2002/2003 ADP Projects.
Using Excel 2003 to Manage Project Sites with Windows SharePoint Services 2003

Using Excel 2003 to Manage Project Sites with Windows SharePoint Services 2003 How to leverage Microsoft Office Excel 2003 and Visual Studio 2005 Tools for Office to create and manage Microsoft Windows SharePoint Services Web sites.

Thursday, July 21, 2005

MSDN Webcast: Visual Studio Tools for Office

MSDN Webcast: Visual Studio Tools for Office Get an overview of Visual Studio Tools for the Microsoft Office System (VSTO) and how it supports building smart client applications for Office. This webcast will begin with a discussion of Microsoft Office-based smart client applications.

Start Time: Wed, Aug 03, 2005 9:00 AM (GMT-08:00) Pacific Time (US & Canada)
End Time: Wed, Aug 03, 2005 10:00 AM (GMT-08:00) Pacific Time (US & Canada)

Wednesday, July 20, 2005

MS Access Keyboard Shortcuts

70+ Keyboard shortcuts to move faster in Microsoft Access A download from TechRepublic.com.
Create a Capital Expenditure Model with Visual Studio 2005 Tools for Office

Create a Capital Expenditure Model with Visual Studio 2005 Tools for Office Learn how to take a sophisticated Excel 2003 spreadsheet model and turn it into an intuitive, easy-to-use, integrated application using Visual Studio 2005 Tools for Office. Article from MSDN.

Wednesday, July 13, 2005

Visual Studio 2005 Tools for Office—Outlook Beta

Download: Visual Studio 2005 Tools for Office—Outlook (Beta) Outlook's add-in support for Visual Studio 2005 Tools for Office Beta 2 provides tools to develop, debug, and deploy solutions simply and quickly—including a DLL to tie managed add-ins to Outlook. This provides a simpler framework for creating managed add-ins with improved security.

Tuesday, July 12, 2005

MS Access Database Mechanic

Further to my post of May 24, I have developed a new freeware tool, Access Database Mechanic, that automates the process of attempting to recover a corrupt MS Access database, using three operations: compact & repair , decompile, and completely rebuilding an .mdb. The applet also features a fail-safe mechanism that creates a uniquely named back-up copy of the .mdb before any recovery operation is attempted. The Beta 1 download includes versions for Access97/2000/2002/2003.

Friday, July 08, 2005

MS Access Scalable with Open Source MySQL

An interesting case study from clearmark.com on how the RAD capabilities of MS Access, and the scalability of the open-source MySQL databasse system, can be leveraged to create a low-cost enterprise-level distributed application.
Visual Studio 2005 Tools for Office Beta 2 IntelliSense Code Snippets

Visual Studio 2005 Tools for Office Beta 2 IntelliSense Code Snippets This download contains 71 IntelliSense code snippets for use with Visual Studio 2005 Tools for Office Beta 2
Office 2003 Add-in: Outlook Calendar Views

Office 2003 Add-in: Outlook Calendar Views With the Calendar Views Add-in, you can easily create and manage filters to display subsets of appointments in Outlook Calendar. Filtered views are based on labels and categories that you apply to appointments (7/6/2005).
Office 12 to Make it Easier for Businesses to share Forms


At its three-day partner conference, which starts Friday in Minneapolis, USA, Microsoft is planning its first public demonstration of improved Infopath forms capabilities in Office 12. The Office 12 beta is scheduled for release later this year, and the final version is slated for release in the second half of next year. In the demonstration, an example of a loan application, a potential home buyer fills out a form via the Web. A loan processor is notified via e-mail and can work on the loan document from within the e-mail. InfoPath forms will be also be able to be edited and viewed from within a web browser. Source

Friday, July 01, 2005

The Deal on the New MS Reports Reporting Platform for Office2003

Extending Office 2003 for Enterprise Reporting and Analysis The new MS Reports reporting platform supports multiple Microsoft teams that require reporting by allowing end users to quickly consume and analyze data, using familiar tools and interfaces, without understanding the data sources and systems (6/20/2005).