May 2008

For Microsoft Access, SQL Server, .NET, and VB Professionals

TOTAL VISUAL CODETOOLS 2007 NOW SHIPPING!

Total Visual CodeTools is now shipping with full support for Office/Access/Excel 2007.

Total Visual CodeTools supports all VB/VBA hosts, including Visual Basic 6.0 (VB6) and Office 2007, 2003, 2002/XP, and 2000. Integrated directly into the Integrated Development Environment (IDE), Total Visual CodeTools gives you a rich set of tools to help you create, cleanup, and deliver better solutions. New features and enhancements include:

• Unused variable, constant, and class analysis
• ADO/DAO Recordset Builder to quickly create code to add, edit or browse tables
• New Procedure Builder to easily create procedures with your commenting and error handing styles
• Macro recorder to easily replay repetitive keystrokes
• More features to add your own variable naming conventions and formatting
• Performance improvements, and much more!

Increase your productivity and take advantage of the enterprise features to make your entire development team more effective: New Features

For more information on all our upcoming Access 2007 related products, visit Schedule for Access 2007

SPECIAL OFFER FOR MSDN PREMIUM SUBSCRIPTIONS

FMS is pleased to offer a two year MSDN Premium Subscription for an amazing price. This includes Visual Studio .NET 2008 and the entire line of Microsoft operating systems, server software, Office, and other business related software, plus support. If you're a professional developer, you need to be a subscriber.

Best of all, you can get a two year subscription for practically the same price as a one year subscription (US and Canada addresses only). Details

TOTAL ACCESS STATISTICS 2007 UPDATE

As part of our commitment to quality, we are pleased to announce that we have released a new update for Total Access Statistics 2007. The latest update fixes all known issues from the original release of Total Access Statistics 2007. Find out more about this update: Details.

This update is available free of charge to registered owners of Total Access Statistics 2007, version 12.0. Notification and download instructions for receiving the patch were emailed to registered owners. If you did not receive instructions, please contact us so we can update your information.

MEET FMS AT MICROSOFT TECH ED

Panel Discussion on Microsoft Access and Migration to SQL Server

Microsoft Tech Ed 2008
June 3-6, 2008, Orlando, FL
Tuesday June 3rd, 1:15 - 2:30 PM (time subject to change)

FMS President Luke Chung is participating in a panel discussion about Microsoft Access databases and migrating them to SQL Server. When, why, and how to do so will be covered. Luke will also be available at the Microsoft booth after the session to answer individual questions.

For more information on the conference featuring a keynote by Bill Gates, visit the Microsoft Tech Ed 2008 web site.

SEMINAR ON MICROSOFT ACCESS TO SQL SERVER UPSIZING

If you're interested in learning more about where Access fits in your organization and migrating Access applications to SQL Server, attend our free seminar hosted by Microsoft at their Reston, Virginia office.

June 27, 2008, Microsoft Technology Center, Reston, VA
8:30 AM-12:00 PM

Come learn tips, tricks and time saving techniques for upsizing Access Databases to SQL Server, including:

• Database Challenges and Costs
• Evolution vs. Revolution
• Advantages/Disadvantages of Access
• Myths of Access Scalability and Migration Limitations
• Recommendation for Using Access
• Evolving to SQL Server
• Access and SQL Data architectures
• Making the Decision: When to Upsize
• Planning an Upsizing Project
• Technical Steps for Upsizing

Seminar info
 

SQL SERVER TIP: OPTIMIZE SORTING FOR SOUNDEX SEARCH RESULTS

The SQL Server Soundex function is used to find similar strings based on a search pattern. The function calculates a numerical value for a string. However, all matching strings will have the same value, so sorting on this value has no effect.

Find Out More

RECENT ACTIVITY FROM OUR PROFESSIONAL SOLUTIONS GROUP

Since 1986, FMS has been a leader in developing custom solutions for organizations throughout the world. Our track record and longevity gives us a unique perspective in the industry.

Here are some custom database solutions we recently provided to our clients:

• Created a web based application for a national academic institution to allows students to ensure that course materials and topics fulfill their overall requirements.
• Updated our Event Management application for a prominent Event Planning organization to give administrators better data control and custom field level security to manage their operations and accounting.
• Created an Internet Search solution for a new group hunting criminals who prey on children.
• Updated our application for a Pharmaceutical Event Planning organization to improve usability and efficiency by streamlining the data entry process.

Contact us to learn more about how our Professional Solutions Group can help you with a Risk Free Assessment.

ACCESS TIP: PREVENT USERS FROM ACCIDENTALLY CLOSING MICROSOFT ACCESS FROM ITS CLOSE BOX

By disabling the Access close button, you eliminate user confusion about which Close button to use to close a maximized form or report preview. The commonly used "hidden form" approach doesn't quite work. Eliminate accidental exits from your application by directly disabling the close button. Source code provided.

Find Out More

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

Sincerely,

Your Friends at FMS