 2010
Issue 2
For Microsoft Access, SQL Server,
Visual Studio .NET, and VB6 Professionals
 As
I enjoyed walking with my family near the reflecting pool by the Lincoln
Memorial, I was reminded that cherry blossom season is near. Spring has
finally arrived after a record breaking season of snow here in northern
Virginia. The trash pickup and snow removal software that we created for
the DC Public Works department was valiantly used during the major
storms but there's only so much you can do when back-to-back storms
leave no room to put the snow you've plowed.
Meanwhile, our Logistics Support Solution for the Pan American Health
Organization was called upon again to address the humanitarian needs
after the tragic earthquake in Chile. This system helps humanitarian
relief organizations coordinate the distribution of relief supplies and
personnel from around the world to disaster zones. Our professional
solutions group continues to create complex solutions, but
has also recently implemented several simple solutions for improving email
communications with Access, .NET, and Exchange platforms. Visit our
revamped consulting site for more
information.
Over the past few months, we've been busily creating cloud solutions
using Windows Azure with .NET and SQL Server. This new platform opens up
many exciting possibilities. We look forward to making a significant
announcement about our work to extend Access to the web with Azure, and
will be extending an invitation for beta testers in the near future.
Stay tuned!
Luke Chung
President
Contents
Total Visual
SourceBook is the most comprehensive professional source code
library for Microsoft Access, VBA, and VB6. Its 194 royalty-free modules
and classes cover all aspects of application development and includes
detailed documentation and examples.
A complete list of all its
VBA/VB6 modules and
procedures is now available for your review. 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. Here's a sample
of the module code.
Using Microsoft Access with Exchange/Outlook to Manage Email
Lists and Automate Unsubscribe/Removal Requests
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.
Paper: Microsoft Access Delete Query and SQL Syntax
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.
Office Tip: Introducing Microsoft
Office/Access 2010 and SkyDrive
The release candidate of Office 2010 is now available, and Office
2010 is expected to be shipping by mid-year. Hopefully you take the chance to
download it, or at least review some of the many videos and articles
about the new features.
For Access enthusiasts, the new version makes
Access even more accessible to non-developers by
exposing more functionality without requiring code or queries. For
example, Reports are much richer, with added calculation tools and the
ability to combine data from multiple sources. Microsoft has also
created a whole new set of Templates to get users started more quickly,
and what can be characterized as data triggers for Jet databases.
Most interesting is the ability to create solutions that can be
exposed to the web. There are lots of restrictions and it's not the same
as putting an existing Access application on the web, but by leveraging
SharePoint and cloud computing, it's a whole new option for Access users
and developers.
Part of Office 2010 is the Office Web Applications (OWA), a web
version of Excel, PowerPoint, Word programs that allows you to create,
edit and host Office files on the web without having Office installed
locally. Microsoft is actually providing 25GB of space for you for free
on their new SkyDrive
site (with you Microsoft Live account).
Access Tip: Starting an
AutoNumber Field with a Number You Want
In Access tables, the AutoNumber field type allows you to
automatically assign a
unique sequential number to each row in a table. AutoNumber fields are
often used as the Primary Key, since they are unique and permanent.
By default, AutoNumber begins with 1. However, you may want to start
with another number. Here's an easy way to
set the
AutoNumber at a number higher than 1.
 Updated FMS Consulting Site for Microsoft
Custom Software Development Services
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.
Can we help you with a project?
Contact us for a
Risk Free Assessment
Thank you for your continued interest in FMS, Inc.
|
Email Newsletter
Developer Team Blog
Facebook
Twitter
Support Forum
Demos
Microsoft Access
Developer Help Center
Microsoft Access
Query Help Center
Technical Papers
Tips and Techniques
Videos
Newsletters
