December 2009

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

Hi Everyone,

We hope you are enjoying the holiday season and the close of a challenging year on an upswing.

Special thanks to Graham Seach, the organizer of the Office DevCon 2009 conference, and the wonderful attendees who I met during the event in Brisbane, Australia. It was an amazing experience meeting so many friendly people in our community Down Under.

We are very pleased to announce that Total Visual SourceBook 2007 is now shipping. Total Visual SourceBook includes tens of thousands of new and updated lines of code to take advantage of the new features in Access 2007, Outlook 2007, the other Office products, and customer requests. As always, you can add the code royalty-free into your applications.

With Total Visual SourceBook 2007, our product line including all our suites, completely supports Microsoft Access 2007.

In this newsletter, we're providing many tips related to queries. We hope you find our products and these resources helpful to your development efforts!

Wishing you and yours a wonderful holiday and great 2010!

Luke Chung
President

Contents

• Now Shipping Total Visual SourceBook 2007
• All FMS Suites Fully Support Microsoft Access 2007
• Query Tip: Finding Records in One Table but Not Another with “Not In” Queries
• Delete Query and SQL Syntax in Microsoft Access
• Update Query & SQL Syntax in Microsoft Access
• Simulating the Microsoft Access Runtime during Development
• Helping You Keep in Better Touch with Your Contacts
• Sentinel Visualizer for Law Enforcement

Now Shipping Total Visual SourceBook 2007!

Total Visual SourceBook 2007 is now shipping for Microsoft Access 2007.

Total Visual SourceBook is the most extensive professional source code library for Microsoft Access, Office, and Visual Basic 6.0. With 194 modules, 100,000+ lines of code, and almost 20,000 lines of examples, this collection of consistently written, well tested code is available for you royalty-free! Insert the code directly into your projects and call it. Since it's source code, you can examine each line, learn from it, and enhance our code for your specific mission. We've added lots of new code for Access 2007, Outlook 2007, ADPs, ADO, tables, web (e.g. Twitter), Windows API calls, and much more. Here are details of the new features.

Why write code we've already written and tested for you? Written by our staff of Microsoft MVP's, much of this code you won't find anywhere else.

All FMS Suites Fully Support Microsoft Access 2007

With the release of Total Visual SourceBook 2007, all our Access related suites include full support for Microsoft Access 2007.  These include:

• Total Access Ultimate Suite
  All 12 of our Access related products
• Total Access Developer Suite
  Five products focused on the needs of Access developers
• Total Visual Developer Suite
  Our two coding products for Access, Office, VBA, and VB6 developers
• Total VB Enterprise Suite
  Four products for VB6 developers

If you already purchased the 2007 version of the suite, you should have received an email to download Total Visual SourceBook 2007. For existing suite customers, click on the links above to upgrade to the latest version.

Query Tip: Finding Records in One Table but Not Another with “Not In” Queries

When querying data from multiple tables, we usually use Inner Joins to link records with values that exist in both tables. But what if we need to find records that exist in one Microsoft Access table but not the other? If you're not familiar with creating and using "Not In" queries, this paper is a must read!

Delete Query and SQL Syntax in Microsoft Access

Here's a new paper on DELETE query syntax in Microsoft Access. In addition to the basics of deleting data and the SQL for DELETE queries, and examples, we cover an interesting situation when DELETE queries fail with this message: "Could not delete from the specified tables". This error only appears interactively and does not trigger an error in VBA. Watch out!

Update Query and SQL Syntax in Microsoft Access

Here's a new paper on UPDATE query syntax in Microsoft Access. In addition to the basics of updating data and the SQL for UPDATE queries, and examples, we cover issues related to when update queries fail and some workarounds.

Simulating the Microsoft Access Runtime during Development

The Microsoft Access 2007 runtime version is FREE and allows you to distribute your Access applications to users who do not have a full license of Access. Because of the differences, it is important to ensure that your application works properly in the runtime environment prior to deployment. Microsoft Access makes it easy to simulate the runtime environment using the /runtime command line. By testing your application in this environment, you can find runtime-specific problems before deploying your application.

Helping You Keep in Better Touch with Your Contacts

During the holiday season, many of us send cards to our family, friends, colleagues, and customers to express our thanks. But we shouldn't just reach out once a year. How are you keeping in touch with your contacts on a regular basis?

Many of you already use our Total Access Emailer program to automate the sending of personalized emails with data and reports to each contact. It's a great way to leverage the value of your data and the power of email.

For those who need more advanced, custom features or just want someone to take care of the whole process, our Professional Solutions Group has created many applications leveraging our experience creating and deploying Total Access Emailer.

From giant AARP to small businesses and non-profits, FMS has created numerous custom email solutions that simplify and significantly improve the way data is shared.

Learn more about how we can become your partner for success.

Contact us for a Risk Free Assessment

Sentinel Visualizer for Law Enforcement

Discover how Sentinel Visualizer solves real-world problems for law enforcement organizations. With easy-to-use analysis, visualization and non-proprietary data storage, Sentinel Visualizer is in use today around the country helping law enforcement professionals solve crimes. If you're part of the law enforcement community, we have real world data sets available to demonstrate our capabilities. Learn more about our software solutions for the law enforcement community.

Contact us for more information.

Thank you for your continued interest in FMS, Inc.