March 2009

For Microsoft Access, SQL Server,
Visual Studio .NET, and VB6 Professionals

Hi Everyone,

Early signs of spring are appearing and I'm looking forward to speaking at the Denver Access User Group and hopefully doing a little skiing. Hope you will be there if you're in the area.

As organizations cut their budgets, large ticket IT projects are disappearing. Curiously, we are seeing a significant increase in activity around smaller desktop and web solutions. Tight deadlines, rapid application development methodology, and iterative design-development cycles seem to be the best approach. Read about our experiences and provide feedback about your own experiences in my blog.

This month's newsletter covers a variety of topics, including from Microsoft's publication of a video interview of me on Microsoft Access and migration issues, a paper discussing the cool features we like in Access 2007, the release of updates to three of our products, and information on some of our custom software solutions for event management. To get our latest news as soon as they're announced, sign up for our RSS feed from our blog.

Best wishes,

Luke Chung
President

Contents

• Meet Luke Chung at the Denver Access User Group
• Access Paper: Top Features of Microsoft Access 2007 That Aren't Available in Prior Versions
• Free FMS Product Updates
• Access Tip: Microsoft Access Subforms Should Reference the Control Rather than Field for Master Link Fields
• Microsoft TV Features Luke Chung Discussing Microsoft Access Database and Migration Challenges
• New Hotfix to Resolve Error Pasting Excel Data into Access Tables
• Custom Management Solutions for Running Events and Classes

Meet Luke Chung at the Denver Access User Group

Thursday, March 19th, 6-9 PM

FMS President Luke Chung is the featured speaker at the March 19th Denver Access User Group meeting held at the Microsoft Office in downtown Denver from 6 to 9 PM. He'll be covering Microsoft Access 2007, the FMS products for Access, and entertain any questions that may arise.

Microsoft Corporation
7595 Technology Way
Suite 400 (4th Floor) 
Denver, CO 80237

The event is free. For more information, visit the Denver Area Access Users Group website www.daaug.org

Access Paper: Top Features of Microsoft Access 2007 That Aren't Available in Prior Versions

There are many experienced Microsoft Access developers who continue to resist the migration to Access 2007. While there are some changes that are cumbersome, there are many new features that justify the migration. Access 2007 lets you create applications with features that in many cases would be impossible to provide in prior versions. Read this detailed paper about the many features we like in Microsoft Access 2007.

Free FMS Product Updates

As part of our commitment to quality software, FMS regularly releases product update patches to add new enhancements and resolve known issues. Most recently, we have released updates for:

	Update for Total Access Analyzer 2007 Microsoft Access database documentation and analysis
	Update for Total Access Emailer 2007 Microsoft Access add-in for sending personalized emails
	Update for Total Visual CodeTools 2007 Microsoft Access VBA and VB6 coding tools

Update notifications were sent to all registered owners—contact us if you did not receive your update instructions.

You can check for updates in most FMS products by using the built-in Update Wizard. From the Windows Start menu, select All Programs, FMS, Program Name, Update Wizard. Follow the wizard prompts to check for updates.

Access Tip: Microsoft Access Subforms Should Reference the Control Rather than Field for Master Link Fields

We recently published a tip on how to Easily Synchronize Two Related Subforms on a Form without writing code. In that tip, we recommended that the Link Master Field of a subform should reference the control name rather that its field name.

We received some inquiries about this and wrote another tip which includes a sample database to explain this recommendation in more detail. Basically, if the value that's used as the Link Master Field can be edited, it's critical to use the control name for the Link Master Field of a subform. Otherwise, one can easily see and edit inconsistent data.

Microsoft TV Features Luke Chung Discussing Microsoft Access Database and Migration Challenges

Microsoft’s Dr. Zhiming Xue interviews Luke Chung on Access based solutions and the challenges of migrating them to SQL Server.

Watch the video (22 minutes) and read more about Migrating Microsoft Access Databases to SQL Server.

Microsoft News: New Hotfix to Resolve Error Pasting Excel Data into Access Tables

Last December, we told you about an issue with the latest Excel security patch that prevents pasting data into Access tables, and in January we were able to give some great workarounds for the error. We're happy to let you know that on February 24th, Microsoft released a hotfix to resolve this issue. Click here to find out more about the problem, and for a link to request the hotfix from Microsoft.

Make sure to keep watching the FMS Blog to keep up to date on the latest news in application development.

Custom Management Solutions for Running Events and Classes

Over the past decade, the FMS Professional Solutions Group has created some of the world's leading solutions for event management and course competency tracking. Our solutions:

• Manage the operational details of the world's leading speaker bureau
• Conduct over 60,000 continuing medical education seminars a year
• Support the US Department of Defense's efforts to properly train and credential its workforce

Learn more about our custom event management software solutions or contact us to discover how we can help your mission.

Thank you for your continued interest in FMS, Inc. We look forward to hearing from you!

Sincerely,

Your Friends at FMS

Sign Up or
Change Your Address Now!