Mar 24

Paper: Microsoft Access Delete Query and SQL Syntax

Posted on March 24, 2010 by LukeChung

In our continuing coverage of query tips and techniques, we've create a paper focused on the DELETE query in Microsoft Access. It covers the basics of DELETE query SQL Syntax. It's a very powerful feature and a fundamental part of relational databases since you can remove multiple records at one time, and can specify which records to delete by linking to data in another table.

The paper also covers these more advanced topics:

Query fails: "Could not delete from the specified tables"
Use DISTINCTROW with Delete Queries for Non-Key Field Joins

Understanding and using Delete Queries improves the performance of your applications and makes them easier to maintain versus doing the same changes manually or in code.

Mar 24

Use Microsoft Access with Exchange/Outlook to manage email list removal

Posted on March 24, 2010 by LukeChung

Many organizations use Microsoft Access to manage a list of email contacts. In conjunction with Total Access Emailer from FMS, it’s easy to send everyone a personalized email (such as a newsletter, order notification, or even a recipient’s individual invoice or sales receipt) in a convenient and automated way. Handling undeliverable emails and unsubscribe requests, however, can be tricky.

Read our new web page on Using Microsoft Access with Exchange/Outlook to Manage Email Lists and Automate Unsubscribe/Removal Requests.

Mar 22

Total Access Statistics User Manual for Microsoft Access

Posted on March 22, 2010 by Admin

Total Access Statistics is the most advanced and popular data analysis program for Microsoft Access. Total Access Statistics makes it easy to calculate percentiles, regressions, confidence intervals, correlations, t-tests, probabilities, ANOVA, Chi-Square, etc. You can even normalize tables, rank records, and select random records, plus much more without any programming.

To maximize your use of Total Access Statistics for analyzing the data in your Microsoft Access databases, a professionally written and printed user manual is included. The user manual is 176 pages and fully indexed to make it easy to learn about Total Access Statistics, how to use it, definitions of its calculations, its programmatic interface, and tips for optimal use.

The Total Access Statistics user manual is now available for your review. Check it out to see how Total Access Statistics extends the power of Microsoft Access queries so you can analyze your data better than ever. To see it action with your own data, download the trial version.

Mar 03

Updated FMS Consulting Site for Microsoft Services

Posted on March 3, 2010 by Admin

The 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 February 19, 2010 by LukeChung

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 January 27, 2010 by Admin

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 January 25, 2010 by LukeChung

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 January 22, 2010 by Admin

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 January 22, 2010 by Admin

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.