Jan 04

Total Access Detective Ships for Microsoft Access 2010

Posted on January 4, 2012 by Admin

We are very pleased to announce that Total Access Detective for Microsoft Access 2010 is now shipping with support for the 32 and 64 bit versions of Access 2010.

Ever wonder what changed between your database versions or the difference between two similar objects or tables? Total Access Detective is the premier program to detect differences between Microsoft Access databases, objects, code, and data.

Available as a Microsoft Access add-in, Total Access Detective lets you easily find differences between objects in your currently opened database. Easily find changes in your table and field definitions, object properties, controls, report sections, embedded macros, regular macros, modules, and data. The results are available to you in reports and on screen which can be copied or exported.

You can also compare any two databases to easily find exactly how they changed. Your databases can be an ACCDB, MDB or ADP database format. The new version lets you create separate databases for each comparison so you can easily manage multiple databases and changes over time.

We've added many new features to make Total Access Detective more powerful than ever:

Supports Microsoft Access 2010, 32 and 64-bit versions
Compares All Database Types Supported by Access 2010
Compares the new Microsoft Access 2010 enhancements including new object properties, macro syntax, and VBA commands
Performs Line-by-Line Comparisons of Embedded Macros
Procedures that Did Not Change are Listed
New Data Comparison Option to Ignore Case Differences
When Comparing Modules, Optionally Ignore Blank Lines and Comments (also applies to text block comparisons)
Exclude Properties from Comparison
Create and Manage Multiple Database Comparison Results. You are no longer limited to one set of comparison results!
Command Line Launching of Total Access Detective Can Now Specify Storage Database Name
Improved User Interface with Office/Access 2010 Theme Support
New Reports and Improved Selection Screen
New User Manual and Context Sensitive Help

Manually comparing databases for design and data differences is prone to error. Discover why so many Microsoft Access professionals rely on Total Access Detective to improve their productivity by quickly identifying the changes in their work.

Dec 23

Total Access Components 2010 Ships with 32 and 64 bit ActiveX Controls

Posted on December 23, 2011 by LukeChung

Total Access Components 2010 Ships with 32 and 64 bit ActiveX Controls

Create dazzling forms with Total Access Components, the only collection of custom controls designed specifically for Microsoft Access.

With little or no code, add advanced menus, rotated text, bitmap animation, resizer and splitter bars, progress meters, gauges, dials, sliders, spin buttons, pop-up notes, Windows dialogs, clocks, fancy buttons, borders, rotated tabs, cursors, etc. A sample database includes examples of every control and how to customize them.

The 2010 version is rebuilt using C++ version 10 and supports both 32 and 64 bit platforms without having to make any changes to your forms or code.

Total Access Components 2010 supports Access 2000 through 2010. It includes a royalty-free distribution license and a deployment program to easily distribute it to your users. See all the new features and download the free trial version.

Nov 28

Microsoft Access 2010 Error Number and Description Resource

Posted on November 28, 2011 by LukeChung

As a resource for the Microsoft Access community, we’ve updated our comprehensive list of Microsoft Access Error Codes and Descriptions for Microsoft Access 2010.

There are PDF reports of the error codes and descriptions, and a database containing a with each error code and its different descriptions access MSAccess versions 2010, 2007, 2003, 2002, and 2000.

Here’s the detailed HTML page that lists every Microsoft Access 2010 error code with its description and for some of them, hyperlinks to resources that address the error and/or provide more information on the topic. Since this page is so large, please be patient while it loads.

This resources is part of our Microsoft Access Developer Help Center where you’ll find lots of other information to improve your skills. Hope this helps!

Nov 10

Total Access Detective Free Preview for Microsoft Access 2010 Difference Comparisons

Posted on November 10, 2011 by LukeChung

We are very pleased to offer a Free Preview of Total Access Detective for Microsoft Access 2010. (The Preview version has now expired.)

We’ve added many new features to make Total Access Detective more powerful than ever.

Tell us how it works for you!

Nov 09

Microsoft Access Append Query Examples and SQL Syntax

Posted on November 9, 2011 by LukeChung

We've enhanced our Microsoft Access Query Help Center with a new paper describing Microsoft Access Append (Insert) Queries, and how to use them to add multiple records or a single record to a table.

We also discuss why rather than using a Make Table query, it's preferable to use an existing table, empty it, then fill it with an Append query.

Sep 22

Total Access Startup for Microsoft Access 2010 is Now Shipping

Posted on September 22, 2011 by LukeChung

Total Access Startup lets you centrally manage and guarantee that all your users always launch the right version of Microsoft Access with the right version of your MS Access database (ACCDB, MDB, or ADP). Simply distribute a shortcut to your users to start your application. When you post an updated database, your users automatically get it installed on their machine the next time they launch your program. They don’t need to know the name of the database. You manage all of that in one place and can change it at any time. A runtime version lets you control the Access version launched for users not on your network.

Total Access Startup 2010 is now shipping. It supports both 32 and 64 bit versions of Microsoft Access 2010 letting you control which version your application requires. It also supports all legacy versions of Microsoft Access. Learn more about the new features and try out the free trial version.

Aug 29

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

Posted on August 29, 2011 by LukeChung

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 02

Total Visual CodeTools 2010 Ships for Microsoft Office 2010

Posted on August 2, 2011 by Admin

FMS 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.

Jul 29

Microsoft Access Developer Help Center Debut

Posted on July 29, 2011 by Admin

We are very pleased to announce the creation of our new (and free) Microsoft Access Developer Help Center. It contains our many popular papers with tips and techniques for becoming a better Microsoft Access developer, programmer, and administrator. It covers the whole life cycle from strategic planning of how MS Access fits, database and table design, form and report tips, programming do's and don'ts, deployment, best practices, performance tips, etc.

This follows our recent Microsoft Access Query Help Center that's been well received, and our Microsoft Access to SQL Server Upsizing Help Center.

We welcome any feedback on what we've put there and suggestions for additional content that would be helpful.

Jul 25

Replace the Paperclip Icon of Attachment Fields with a Column Name in Microsoft Access Tables in ACCDB Databases

Posted on July 25, 2011 by LukeChung

In Access 2010 and 2007 databases (ACCDBs), the Attachment field type lets you attach files (documents, files, etc.) to records in your database. When you open the table in Datasheet view, the attachment fields display a paperclip as the column header.