Recent News from FMS
 New
Updates for Total
Access Detective (January 22, 2009)
Total
Access Detective makes it easy to find differences
between any two Microsoft Access databases or objects.
As part of our commitment to quality, we are pleased to release
updates of Total Access
Detective for our versions for Microsoft Access 2007, 2003, 2003,
and 2000.
The updates include performance enhancements, Windows 7 support,
improved ADP support, and resolve all known issues since their original
release. The updates are available free of charge to registered owners who
were emailed download instructions for the update. Please contact us if
you are a registered owner and did not receive a notification.
 Calculating Percentiles in Microsoft Access with Total Access
Statistics (January 2010)
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 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
Total Access Emailer
Programmatic Interface (January 2010)
 Total Access Emailer is the world's leading
email program for Microsoft
Access. It runs as an Access add-in to let you easily create email
blasts using your list of email addresses and integrating your data and
reports into your messages and attachments. The Professional Version
includes a programmatic interface that lets you automate the sending of
email blasts through your VBA module code. A simple procedure is
provided to let you launch an email blast.
Here's a new page describing how to
Send Microsoft
Access Email Blasts Programmatically using VBA.
 Total
Visual SourceBook 2007 Ships for Microsoft Access/Office 2007
Total Visual SourceBook
is the most extensive professional source code library for Microsoft
Access®, Office, and Visual Basic 6.0. The latest version
includes full support for Access/Office 2007 including the new
Access 2007 ACCDB database, Outlook 2007, and many
new features
to expand the considerable source code library. There are now 194
classes/modules, 100,000+ lines of code, and almost 20,000 lines of
example code.
As before, you have full
control: use our code, learn from it, and enhance it.
Best of all, the code is provided royalty free so you can use it in
your projects immediately! Written by our staff
of Microsoft MVP's, much of this code can't be found anywhere else!
 Luke
Chung Speaking at Office DevCon 2009
October 31 - November 1, 2009
Brisbane, Australia
FMS President
Luke Chung will be giving several presentations on
Microsoft Access application development and our
products at this conference. Hosted at the University of Queensland, St. Lucia
campus, we hope you see him down under!
Two More FMS Articles are published on MSDN
(October 2009)
 FMS is honored that Microsoft published
two more of our popular articles on their MSDN global site:
We recently enhanced the query paper to include additional information
on the
Update Query syntax.
New Look and Feel for Our Web Site
(September 2009)
Our web site is undergoing major renovations and sports a new look
and feel. While portions are still undergoing changes, much of the work
is completed and published. We hope you like the enhancements with more
improvements to come!
Total
Access Detective Versions X.7 Ship for Microsoft Access 2003, 2002, and
2000 (August 2009)
Total
Access Detective makes it easy to find differences
between any two Microsoft Access databases or objects.
With the recently release of the Access 2007 version, we're pleased
to provide new versions for Microsoft Access 2003, 2002, and 2000
(versions 11.7, 10.7 and 9.7 respectively). Version X.7 adds many
new features including data comparison between two queries, enhanced
data comparison options such are comparing two tables when field names
are not identical (compare only identical field names or on field
order), using the first field as the key field if no key field exists,
skipping small numerical data differences, ignoring case differences
between modules, improved support for ADP comparisons, etc. Existing
customers can upgrade for a nominal fee.
Existing Total Access Detective customers under annual support
contracts receive the upgrade for free.
FMS Article on Error Handling in VBA/VB6 is published on MSDN
(August 2009)
FMS is honored that Microsoft has published one of our popular
articles on their MSDN global site. Originally published as one of our technical papers on our web site (Error
Handling and Debugging Tips and Techniques for Microsoft Access, VBA,
and Visual Basic 6 (VB6), Microsoft has now added our paper to their
MSDN site. Check it out
here.
Free Update for Total Access Statistics 2007 and Total
Access Admin 2007 (August 2009)
As part of our commitment to quality software, FMS
periodically releases updates patches to add new enhancements and
resolve known issues. We've released updates for these products:
Total Access Statistics is the most powerful data analysis program
for Microsoft Access. Extend the power of Access queries with advanced
analysis such as percentiles, frequency distributions, moving averages,
t-Tests, confidence intervals, ANOVA, data normalization, and much
more. Version
12.00.0009 is now available for Access 2007 and includes improved
support for ADPs and certain calculations.
 Total Access
Admin 2007 lets you monitor multi-user entries and exits to your
Access databases in real-time. Watch and log the activity and catch
suspect connections or drops that can cause database corruption. It can
even compact your database after everyone has exited. This patch
addresses some of the issues associated with supporting password
protected databases and databases under workgroup security. (Version
12.00.0140)
These updates are available free of charge to registered
owners of Total Access Statistics 2007, version 12.0 and Total Access
Admin 2007. 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.
Total Access Detective Ships for Microsoft Access 2007 (July 2009)
Total
Access Detective makes it easy to find differences
between any two Microsoft Access databases or objects.
Know exactly what changed with your properties, fields,
indexes, controls, sections, macro lines, VBA module
code, and data! List objects in one database and not the
other. Find new, deleted, and modified records. Combine
records from two tables into a new one.
New features include support for Access 2007 and the
new ACCDB database format including multi-value fields,
enhanced data comparison options, improved support for
ADP comparisons, and much more!
 Total Visual Agent Ships with Full Support for Access 2007 (July 2009)
Microsoft Access databases need to be periodically
compacted for optimal performance. You should also
perform regular backups.
Total Visual
Agent performs these system administrative chores,
and automates a wide range of Access tasks such as
running macros on a schedule. Everything is audited with
email notification of problems. Now with full support
for Access 2007 and the new ACCDB database format.
Microsoft SQL Server Development Services
When we develop custom database applications on the desktop
or web, we often store the data in Microsoft SQL Server.
Contact our Professional Solutions Group for help with your
database development efforts. Whether it's migrating an
Access database from Jet to SQL Server or creating a highly
scalable web solution using ASP.NET, our team of database
experts are here to help. Learn more about our
Microsoft
SQL Server consulting services.
 Update of Total Access Admin 2007 (June 26, 2009)
Total
Access Admin offers a real-time
monitoring of users entering and exiting any Microsoft Access database
across your network. An update of Total Access Admin 2007 was just
released. All customers were notified of the
update via email with download
instructions.
Microsoft ASP.NET Website Development Services
FMS is well known for our world class Microsoft Access and desktop
development skills. Did you also know our Professional Solutions Group
is very experienced creating database driven web solutions
using Microsoft ASP.NET and SQL Server?
We recently updated our information on our
Microsoft ASP.NET website development services.
Luke Chung Speaking at the Washington DC Access User Group
FMS President Luke Chung is the guest speaker at the June 17th
meeting from 7 to 9 PM. Luke will
be speaking on "Cool Features in Access 2007" and any other topics the
audience raises. The event is free and located at the Washington DC Veterans Affairs Medical Center
in Washington DC. For more information, visit the
Washington DC Access SIG web site
Online Video from the Microsoft TechEd Conference
Watch videos of Luke Chung's participation on the Microsoft Tech Ed
Conference panels.
Luke Chung Speaking at Microsoft TechEd Conference
Microsoft has invited FMS President Luke Chung to participate on three
panel discussions at their annual conference from May 11-15th in Los
Angeles. Luke will be covering:
- Running a Software Consulting Business
- Developing SQL Server Applications
- Development Strategies During These Challenging Times
For more information, visit
our Upcoming Events page. Hope to see you there!
Total Access Components 2007 Ships
 Total
Access Components 2007 lets you enhance your applications with amazing visual effects, interactive
features, and other features that are sure to amaze your
users. Add powerful
functionality to your Access application in minutes with the only
collection of ActiveX custom controls designed specifically for
Microsoft Access.
New features
include support for Access 2007, a new Cursor control,
and enhancements to many controls.
Free demo available.
Luke Chung Speaking at the Denver Access User Group
Luke Chung is the featured speaker at the March 19th Denver Access
User Group meeting held at the Microsoft Office in downtown Denver from
6 to 9 PM. He'll be covering Microsoft Access 2007, the FMS products for
Access, and entertain any questions that may arise. The event is free
and we encourage you to become member of the group if you aren't
already.
For more information, visit
http://www.daaug.org/
(Blog)
 MSDN Channel 9 TV - Luke Chung on Microsoft Access Database and Migration Challenges
Microsoft's Dr. Zhiming Xue interviews Luke Chung on topic of dealing with Access
database solutions and challenges that project teams deal with
when migrating them to more scalable solutions.
Watch the
video (22 minutes) and read more about
Migrating
Microsoft Access Databases to SQL Server. (Blog))
 FMS
is Serving the United States State Department
FMS is honored to provide custom application design and development
work for the headquarters of the US State Department in Washington, DC.
The State Department is using our ASP.NET
development and SQL Server database expertise to enhance one of
their existing public web site which is being converted from legacy
ColdFusion and Delphi technologies.
Total Access Analyzer Version X.8 for Microsoft Access 2003, 2002,
and 2000 is Shipping (January 2009)
 An
updated version of Total Access Analyzer
is now shipping for Access 2003, 2002, and 2000. Many new features were
added to help you find more ways to improve your Access databases. Here
are the new
features. Customers on support contracts receive the upgrade
automatically, other customers can upgrade for a nominal fee.
Excel Security Patch Conflicts with Pasting Data into Access Tables (December 2008)
If you're used to pasting Excel spreadsheet data into an Access
table, you may have encountered this error recently:
The data on the Clipboard is damaged, so Microsoft Office Access can't
paste it. Maybe you thought there was something wrong with your
spreadsheet, data, or memory. It turns out this is caused by a Microsoft
Excel 2007 security patch that was released December 9th. Learn about
the issue and a few workarounds.
 The Hot Mommas Project:
FMS Creates a Social Networking Website for Female Entrepreneurs (December 2008)
Seeking to build the world's leading case study site for
businesswomen and entrepreneurs, a professor at the George
Washington University Business School chose FMS to get it
done. Key Features include:
-
 Social networking features including tagging and public profiles
- Rich text authoring
- Search Engine Optimization (SEO) driven URLs for participants' cases
- Great prizes for competition winners!
Read more about this
social networking website.
White Paper: Application Development During Uncertain Times (November 2008)
Read FMS president Luke Chung's
white paper on how to best develop applications and
position yourself during these challenging economic times.
Balancing budgets, application requirements, and the rapidly
changing external environment, a strategy that's quick and
nimble is in more demand than ever. Learn how to best
position yourself and your organization in these challenging
times. Minimize risk and maximize your potential by getting
solutions into production quickly and letting the market
decide what survives and dies. Application evolution and
natural selection is most powerful during times like these.
Make sure you anticipate those forces.
Streamlining the Harvard College Interview Process (November 2008)
 It's
the season for high school seniors to apply to college. This
year our Professional Solutions
Group is helping
Harvard
College automate their interview process. Almost every
student who applies to be a freshman is offered a personal
interview with a local Harvard alum. With over 22,000
applicants last year, it's quite a challenge to match up
applicants with interviewers, and manage all the paperwork.
Our Professional Solutions Group created a web based
solution using SQL Server, Visual Studio .NET, and an Access
administrative interface to assist with the process. With
Harvard now providing massive scholarships based on
financial need (families making under $80K a year don't have
to pay anything and those making up to $200K pay only 10%),
we expect an even larger pool of applicants. Best wishes to
all who apply!
Total Access Speller 2007 Ships (October 2008)
The Microsoft Access 2007 version of
Total
Access Speller is now shipping with many
new features.
New X.5 versions are also available for Access 2003, 2002, and 2000.
Total Access Analyzer 2007 Ships (October 2008)
Thank
you for your patience! The much awaited Microsoft Access 2007 version of
Total Access Analyzer is now shipping.
Total Access Memo 2007 Ships (August 2008)
Total Access Memo 2007
for Microsoft Access 2007 is now shipping with full
support for Access 2007 through Access 2000. Easily add
rich text memo fields to your forms and reports tied to
your tables. Includes a built-in full screen text editor
to let you easily add fonts, point sizes, styles,
paragraph settings, graphics, hyperlinks, and more! You
can even spell check your formatted text with support
for 20 languages.
Free Seminar for Microsoft Access to SQL Server Upsizing Co-Sponsored by Microsoft on June 27, 2008 (Reston, Virginia)
Please join us for a half-day seminar on upsizing Access applications to SQL Server.
Luke Chung, FMS President, and Steve Clark, FMS Project Manager and
Microsoft MVP, will present these topics:
- Where Microsoft Access Fits in the Overall Database Strategy of an Organization
- Approaches to Upsizing Access to SQL Server
Microsoft Access to SQL Server Upsizing Seminar
Microsoft TechEd Panel Discussion: Are we there yet? Successfully
navigating the bumpy road from Access to SQL Server (June 18, 2008)
Watch the televised video of Luke Chung, FMS President, on a panel
discussion at the 2008 Microsoft TechEd Conference in Orlando, Florida.
Hosted by Microsoft's Mary Chipman, the panel discusses the
challenges and approaches of migrating Microsoft Access applications to
SQL Server.
Microsoft Access to SQL
Server Upsizing video
Total Visual CodeTools 2007 Ships (May 13, 2008)
Total Visual CodeTools 2007 helps you write, cleanup, and
deliver better VB6 and VBA code. Discover why so many
Access, Office and VB6 developers rely on Total Visual
CodeTools to simplify their application development, fix
existing and inherited projects, and deliver more robust
and supportable solutions.
New features
include support for Access 2007, detecting unused
variables, improved code builders and utilities, and
much more.
Free demo available.
 Special Offer for Microsoft MSDN Premium Subscriptions (May 2008)
FMS
is pleased to provide a two year MSDN Premium
Subscription for almost the same price as a one
year subscription. If you're serious about
developing applications on the Microsoft
platform, you need to get this amazing resource!
Available while supplies last.
Details...
Total Access Startup 2007 Ships (March 13, 2008)
 Total
Access Startup 2007 is now shipping. Discover how Total Access
Startup ensures your users run the latest version of your database with
the correct version of Microsoft Access. Centrally manage an unlimited
number of Access databases across your network and simplify upgrades
between versions.
New features
include support for Access 2007, launching ADPs, supporting multiple
Access versions on the same database, and much more.
Press Release.
See you in San Diego, CA (March 2008)
Luke Chung is speaking at the March 19th meeting of the San Diego
Access User Group from 6-8PM.
FMS is exhibiting at the Microsoft booth at the DoDIIS conference
March 16-19th, so stop by if you're there.
For details, visit our
Upcoming Events page..
Total Access Admin 2007 Ships (Feb 5, 2008)
Total Access Admin 2007
is now shipping. Discover how Total Access Admin lets you monitor any
Access database (Access 97 through 2007) to see all the current user
connections. Watch how and when they enter and exit your database in
real-time, keep a log file, and troubleshoot problems. You can even set
it to compact the database once everyone exits.
Microsoft Access Help and Resource Center
Due to our extensive resources for Microsoft Access, a centralized
page was created to make it easy to find all the information:
Microsoft Access Help and Resources
It includes a brief history of Access, our experiences with Access,
links to technical papers, tips, and other resources. New items include
 Free
Book Offer for Microsoft Access 2007
Get this Access 2007 book, a $24.99 value, for free! Through special
arrangements with Zac Woodall and his book publisher, we're pleased to
offer a limited quantity of his book, The Rational Guide To Microsoft
Office Access 2007 Templates, with the purchase of one of our Microsoft
Access 2007 products.
Details...
New Technical Paper for Creating Monthly Summary Reports in Access
Written by Luke Chung, learn how to create spreadsheet like reports
with monthly summary columns without writing any code.
Details...
New Product: Sentinel Visualizer is Shipping (September 5, 2007)
Sentinel
Visualizer revolutionizes data analysis with a powerful combination
of features to let you maximize the understanding of your data. Gain
insight into multi-level relationships and complex networks. Apply link
charts, data filtering, gradient metrics, geospatial maps, timelines,
social network analysis, and much more.
Press Release
FMS Participating and Speaking at Advisor Summit in Miami, FL
FMS President Luke Chung is speaking in the Microsoft Access track of
this event. We will also have a booth among the exhibitors.
Details...
FMS Product Announcements for Microsoft Access 2007
We've been working with Access 2007 for over a year since the alpha
version was released and are delighted by the considerable investment
Microsoft made to enhance Access.
Rather than simply porting our products to
Access 2007 with the same functionality as before, we've invested the
time and effort to make sure we take advantage of the new capabilities
of Access 2007, added features requested by our customers, and applied
the new Office/Access 2007 look and feel.
Here's a summary of our plans
and schedule
Total Access Statistics 2007 is Shipping (July 20, 2007)
Total Access Statistics for
Access 2007 is now shipping with many new features. Enhancements for
users of Access 2000, 2002, and 2003 is also available in a new
X.7 Version.
Additionally, the Total Access Statistics web site is updated with
information on the new versions,
product PDF fact sheet, new tour, etc.
Total Access Emailer 2007 is Shipping (May 18, 2007)
FMS is pleased to release our first product for Microsoft Office Access 2007.
Total Access
Emailer 2007 is now shipping and introduces several exciting
enhancements over the original release, including support for the new
ACCDB database format, new field types, new user interface, and the
ability to attach Access reports as PDF or XPS files to your emails.
 GSA Schedule Contract Awarded to FMS (April 16, 2007)
FMS
receives a General Services Administration (GSA) Schedule Contract to
provide software products and consulting services to the US Federal
Government.
 Microsoft Gold Certification for 5th Consecutive Year
Microsoft designates FMS as a Microsoft Gold Certified Partner for the 5th year in
a row. This is Microsoft’s highest partner certification level and
reflects the proven experience and expertise of FMS for creating
solutions using Microsoft technology.
Read on...
Protecting our Children with the National Center For Missing and
Exploited Children (Feb 07)
We recently began working with the good people at the National Center
for Missing and Exploited Children (www.ncmec.org)
to see how we could help their efforts. We also learned a lot about how
to better protect our children.
Read on...
FMS Free Links to Outside Resources (Feb 07)
Can't find what you're looking for on Microsoft Access, .NET, SQL
Server? Visit our newly updated
free links page
and utilize the list of outside resources we've put together for your
convenience.
Microsoft Featured White Paper, by Luke Chung, Updated (Jan 07)
In an effort to keep you, our customer, up with the latest advances
in the industry, we have again updated one of the key white papers
regarding Microsoft Access.
Learn when to use Microsoft
Access and when to use SQL Server in your organization. This newly
updated white paper discusses database needs, evolution, and challenges,
the advantages, limitations, and myths of Access, and how to use Access
and SQL Server strategically in your organization.
Total .NET SourceBook 2005 is Shipping (Oct 06)
FMS released
Total .NET SourceBook 2005,
the latest version of its best-selling professional source code library
and code repository for Visual Studio .NET. The newest version supports
Visual Studio .NET 2005 with a comprehensive collection of royalty free,
ready-to-use .NET programming code in C# and Visual Basic .NET.
Find out more...
FMS Celebrates 20 year Anniversary (Oct 06)
Founded in 1986, FMS is celebrating its 20th anniversary in business.
This proud achievement is a very significant milestone for us. Very few
companies survive so long, much less firms in our rapidly changing
technology industry. Our success over the years stems from properly
serving our customers, employees, and vendors through many business and
technology cycles. And, of course, the continued support our customers
give us for our innovation and customer service.
We'd like to thank you...
New Versions of Total Access Analyzer Available (Oct 5, 2006)
FMS, Inc. is proud to release new versions of
Total Access Analyzer with many new features and enhancements.
Version 11.7 is now available for Access 2003, Version 10.7 for Access
2002/XP, and Version 9.7 for Access 2000. Total Access Analyzer is the
most popular Microsoft Access add-in winning every industry “Best Access
Add-in” award since 1994. The new versions generate even more
comprehensive documentation and analysis of Access databases to help
help users and developers create better solutions.
FMS President Luke Chung featured on Microsoft website (Sep 06)
Learn when to use Microsoft
Access and when to use SQL Server in your organization. This white
paper discusses database needs, evolution, and challenges, the
advantages, limitations, and myths of Access, and how to use Access and
SQL Server strategically in your organization.
News Archive
|
