Aug 29

Quickly Insert Screenshots in Microsoft Excel, Outlook, PowerPoint and Word 2010

Microsoft Office 2010 has a new feature that makes it easier than ever to insert screenshots into your documents. The Screenshot feature is available in MS Excel, Outlook, PowerPoint, and Word 2010. On the Insert tab of the Ribbon, just click “Screenshot” and choose any of the windows that you have open:

For more details, read our Microsoft Office tip: Quickly Insert Screenshots in Microsoft Excel, Outlook, Powerpoint and Word 2010

Aug 26

Show Data Trends with Tiny Sparkline Charts in Microsoft Excel 2010

A new feature in Microsoft Excel 2010 lets you insert tiny charts, or Sparklines, into worksheet cells. Sparklinkes are a powerful way to show a quick snapshot of data trends.

To insert a Sparkline:

  • Select the cell where you want to insert the mini chart.
  • On the Insert tab of the Ribbon, choose the desired Sparkline type in the Sparklines group:

For more details, read our Microsoft Excel tip article: Show Data Trends with Tiny Sparkline Charts in Microsoft Excel 2010

Aug 02

Total Visual CodeTools 2010 Ships for Microsoft Office 2010

Total Visual CodeTools for Microsoft Office 2010 for VBA and VB6FMS is pleased to announce the release of Total Visual CodeTools 2010, the most popular commercial Visual Basic for Application (VBA) and Visual Basic 6 (VB6) coding product for the Microsoft Office/Access community.

Total Visual CodeTools is an add-in that is integrated with the module editor of all VBA platforms such as Microsoft Office, Access, Excel, Outlook, Word, etc. It offers a wide range of utilities to help developers become more productive when creating new code, taking over existing projects, and delivering more robust solutions.

"Total Visual CodeTools is by far my favorite third-party product," says Alison Balter, author of Mastering Access Desktop Development, instructor and developer. "Total Visual CodeTools helps you get your job done more quickly and allows you to focus on the fun and exciting aspects of application development. My favorite feature is the Code Cleanup. If you've ever inherited a code-intensive database, you'll appreciate this feature."

Total Visual CodeTools 2010 includes many enhancements over its predecessor for Office 2007. In addition to supporting VBA in Office 2010, there are new options and better performance for Code Cleanup and Delivery, enhancements to many Code Builders including the Message Box Builder, Recordset Builder, Select Case Builder, and SQL Text Builder. New features simplify the replacement of existing error handling code, and the user interface is enhanced to support Windows 7. There’s also improved support for international languages and operating systems.

"We are very pleased to ship Total Visual CodeTools 2010," said Luke Chung, President of FMS. "This version represents our seventh major release of this product and our continued support of the VBA and VB6 developer communities."

Edwin Blancovitch of Advanced Developers in Puerto Rico adds, "I really recommend it. This tool definitely increased my productivity, allows for code optimization and quality, and best of all reduced my costs."

"I really love Total Visual CodeTools," said Peter Weinwurm of Axium Canada. "I am completely blown away by how much the products in the Total Access Developer Suite can do, and how much time they will save me."

Product Information

Total Visual CodeTools supports all Visual Basic 6.0 and VBA development environments including all versions of Microsoft Office from Office 2000 through 2010. Additional information is available on these web pages:

Licensing and Pricing

Total Visual CodeTools is available via ESD and also comes with a professionally printed 164 page user manual and CD.

Total Visual CodeTools is licensed on a per developer basis. A single license is $299. Existing customers can upgrade for $199. It is also included as a standalone product and is part of the Total Access Developer Suite, Total Access Ultimate Suite, and Total Visual Developer Suite.

Total Visual CodeTools can be purchased directly from FMS, corporate resellers, and international distributors. All FMS products include a 30-day money back guarantee.

Press Release

Jun 01

Published on Enterprise Features: Microsoft Access Is Underrated–Your Hatred of Access Is Largely Unjustified

Microsoft Access Enterprise Features Microsoft Access

The Enterprise Features web site highlight’s FMS President Luke Chung’s discussion about why¬†Microsoft Access is underrated and hated in large enterprise organizations. “Haters Gonna Hate”

He discusses the dynamics of IT departments in large organizations and their natural conflict with the needs and budgets of information worker. He also shows how organizations that understand the strengths and weaknesses of Microsoft Access can leverage its power for competitive advantage, and how to structure service levels to do so.

Mar 30

Using Terminal Services and RemoteApp to Extend Your Microsoft Access and other Windows Applications Over the Internet

Terminal Services RemoteApp and Microsoft AccessRead our new paper on using Terminal Services and RemoteApp to Extend Microsoft Access and Other Windows Applications Over the Internet.

One of the features of Microsoft Windows Server that is increasingly popular over the last few years is the Terminal Server and more recently RemoteApp. With few exceptions, most Windows applications work within a Terminal Server environment. By doing so, your investment in existing applications, and the power of Windows desktop features and interoperability, can be exposed over the Internet.

This is particularly powerful for database applications such as Microsoft Access since it eliminates the need to send large amounts of data over the Internet for Access to process and users do not need to install Access on their machine. With RemoteApp, you can set up a terminal server experience where your users can only run your application without running other applications or browsing your network. Easily web enable all your desktop applications.