Category Archives: Microsoft Access Products

Mar 03

Updated FMS Consulting Site for Microsoft Services

Posted on by

Microsoft Programming ServicesThe FMS Professional Solutions Group continues to create innovative software solutions that are making an impact on organizations and lives. Check out our updated consulting site to learn more about our solutions in action. See how we are making a difference from disaster relief in Haiti and Chile to the recent snowstorms in Washington DC. Here are some other highlighted solutions:

Let us bring this expertise to help you use data to make better decisions.

Feb 19

Total Visual SourceBook 2007 Module and Procedure List Is Available

Posted on by

Microsoft Access ModulesTotal Visual SourceBookMicrosoft Access Modules

The complete list of modules and procedures in our Total Visual SourceBook professional source code library is now available for your review. From the list of Microsoft Access/Office/VBA/VB6 modules, you can click on any item to get its details.

194 royalty-free modules and classes are available covering all aspects of application development. Learn more about what's available, so you can simply use our code rather than writing your own. It's all open source, so you can learn from it or enhance it to your specific needs.

Jan 27

Considering Cloud Computing with Microsoft Azure?

Posted on by


The Microsoft Azure platform is now available for production use!

We’ve been using Azure over the past year for web/asp.net hosting and SQL Server solutions. We have been very impressed with its features and capabilties. We believe it will revolutionize how we create and deploy applications, and look forward to providing commercial and custom solutions and services with Azure.

We’re already working on several projects including the merging of the Windows desktop/Microsoft Access/Office with the web. We look forward to sharing more with you in the near future.

What do you think about Azure and cloud computing?

Jan 25

New Update for Total Visual SourceBook 2007

Posted on by

Microsoft Access ModulesTotal Visual SourceBookMicrosoft Access Modules

Total Visual SourceBook is the most popular professional source code library for the Microsoft Access/VBA/VB6 community. This huge library of powerful, well tested, and documented VBA/VB6 source code is available for your projects royalty free! Eliminate the drudgery of writing code that already exists. Simply insert our code into your project and run it.

As part of our commitment to quality, we are pleased to announce that we have released a new update for Total Visual SourceBook 2007. This update resolves all known issues since their original release.

The updates are available free of charge to registered owners who were notified via email. If you did not receive instructions, please contact us so we can update your information. 

Jan 22

Microsoft Access Percentile Calculations with Total Access Statistics

Posted on by


Total Access Statistics is the world’s most popular data analysis program for Microsoft Access. It runs as an Access add-in to let you extend the numerical analysis capabilities of Microsoft Access queries.

A common need among MS Access users and developers is the need to calculate percentiles. We’ve created a new page providing more details on how to Calculate Percentiles in Microsoft Access with Total Access Statistics. Percentiles can be generated on the data from your table or query, and are provided in three ways:

  • A new table with each percentile value as a separate field
  • A new table with each percentile value as a separate record
  • Updating a field in your table with the percentile value corresponding to the data in your record

Download the Total Access Statistics trial version to see for yourself on your own data.

Jan 22

New Updates for Total Access Detective for Microsoft Access

Posted on by

Microsoft AccessMicrosoft Access Database and Object Comparison ProductTotal Access Detective for Microsoft AccessFind Differences Between Microsoft Access Objects and Databases

Total Access Detective is our popular Microsoft Access database, object, and data comparison product. Compare any two databases or two Access objects in one database to pinpoint exactly how they are different. As part of our commitment to quality, we are pleased to announce that we have released new updates for:

These updates include performance enhancements, Windows 7 support, improved ADP support, and resolve all known issues since their original release. For more details, visit the Total Access Detective Updates page.

The updates are available free of charge to registered owners who were notified via email. If you did not receive instructions, please contact us so we can update your information.

Jan 15

Total Visual SourceBook 2007 Ships for Microsoft Access, Office, and Visual Basic 6

Posted on by

Microsoft Access ModulesTotal Visual SourceBookMicrosoft Access Modules

Total Visual SourceBook, the most popular professional source code library for Microsoft Access, Office and Visual Basic 6 is shipping with an expanded code base and improved code manager. With 194 modules/classes and over 100,000 lines of code, Total Visual SourceBook lets you add our well written, documented, and tested code into your VBA/VB6 projects royalty-free. Includes full support for Access 2007, lots of new code for Outlook 2007, Office 2007, the web, etc. Learn more about Total Visual SourceBook and why so many developers use and learn from our years of experience creating professional quality solutions.

Dec 12

Microsoft Access/SQL Server Query Tip: Finding Records in One Table but Not Another with “Not In” Queries

Posted on by

Here’s another resource in our ongoing coverage of query techniques:

Learn how to create queries to find all the records in one table that don’t have corresponding records in another table. If you’re not familiar with the difference between Inner Join, Outer Join, Left Join and Right Join, check out our paper on Microsoft Access Outer Join Query: Finding All Records in One Table but Not Another and Creating “Not In” Queries on these important query feature. It’ll save you tons of time trying to code this yourself and will surely give you new ideas on how to better retrieve and analyze your data. The techniques apply to both Microsoft Access and SQL Server queries.

Dec 04

Microsoft Access Delete Query SQL Syntax

Posted on by

Delete Query in Microsoft Access Could not delete from the specified tables.JPG

Here’s an additional paper related to our ongoing coverage of queries. This time we’re covering DELETE query syntax in Microsoft Access. In addition to the basics of deleting data and the SQL for DELETE queries, we also cover an interesting situation when DELETE queries fail during multi-table links on non-keyed fields.

If your query fails to delete any records with this message: “Could not delete from the specified tables”, learn why and how to fix it with the DISTINCTROW syntax or setting the Unique Records property to Yes.

For more information on queries in general, read our paper on Microsoft Access Query Tips and Techniques.

Oct 23

Access Tip: Simulating the Microsoft Access Runtime Version during Development

Posted on by

The Microsoft Access runtime version allows you to distribute your Access applications to users who do not have a full license of Access. The runtime is similar to the full version of Access, but several of the features that exist in the full version are not available in the runtime. To test your users’ experience, you can simulate the runtime with a command line.

To learn more, read our tip: Simulating the Access Runtime during Microsoft Access Development.