The FMS Buzz Email Newsletter
The Buzz is a free email newsletter highlighting the latest news,
technical papers, time saving tips and techniques, products, and other
resources for Microsoft Access, SQL Server, Visual Studio .NET, and Visual
Basic 6.0 users and developers. Our topics are commonly referenced by other
experts, newsgroups, blogs, and newsletters in the community. Sign up now so
you get it first!
Total Visual Agent 2013 Ships, Total Access Speller 2013 and 2010
Ship, Review of Total Access Analyzer, Access Day and PAUG
conferences, more Healthcare.gov news, Access Runtime download, ADO
Version Tip, Microsoft News, New Clients
Healthcare.gov Technical Disaster, Review of Total Access Analyzer
and Total Access Detective, Access Day, Total Access Emailer,
Microsoft Office 2010 SP2 Release, Microsoft Resources
Total Access Analyzer and Total Visual CodeTools recognized; Matrix
Comparison of Access, LightSwitch and Visual Studio; National
Archives Application; Inconsistent Compile Error; Installation
Folder; New Support Forum; Azure Enhancements including Oracle
Errant goose, Total Access Analyzer, Total Access Detective, Blaming
Access and Excel, Query Sorting, Shortcut Keys, Outlook Tips,
Sentinel Visualizer, Azure
New Blog, Portland Access Conference, Updates for Total Visual
CodeTools, Total Access Statistics, and Sentinel Visualizer, Union
Data Analysis with Total Access Statistics, Disaster Recovery,
Review of Total Access Analyzer, Technology and Education,
Microsoft's Fix for their Common Control Fix, Visual Studio
LightSwitch and Microsoft Access, Thank You Veterans
Microsoft Access User Group meeting in New York City,
Total Access Emailer Updates for Microsoft Access 2010 and 2007,
Fixing the Microsoft Common Control Security update, Tip foe Error
3045 Opening a Database, Using Visual Studio LightSwitch for custom
Total Access Analyzer Updates for Microsoft Access 2010, 2007 and
2003, Microsoft MVP, Microsoft Access Development Standards, Windows
Azure development, Government Services, Derecho and Disaster
Total Access Emailer Feature, Announcements from TechEd, ComboBox
Searches, Crosstab Queries, Taking Over an Existing Access
application, LightSwitch applications
Total Access Analyzer 2010 Update, Space Shuttle Fly-By, Microsoft
Access vs. Excel, Top 5 Combo Box Tips, Update your SkyDrive
Total Access Analyzer for Microsoft Access 2010 Ships, Tips for
Cascading Combo Boxes and List Boxes, Virginia Governor, Smartphone
Application, Impact Aid funding software
Total Access Analyzer 2010 Preview, Total Access Detective 2010
Ships, Portland Access Conference, LinkedIn Groups, Education
p or Update Your Contact Information
Some Subscriber Comments
I used your advice about looping through Recordsets on a project at
work. I simplified the project and exceeded expectations; many
Glad to get your newsletter today. I'd been trying to figure out a way
for Access to mate with Outlook, then Poof!!!, the answer was in your email,
Access tip...five easy steps
to retrieve info from an Outlook data file into an Access database.
--Paul Binet, Germany
Thank you! Thank you! I have just finished reading your paper, which was
part of a link in the recent Buzz newsletter. I have printed it for others
to read, especially those skeptical on the
powers of Microsoft
Access and its capabilities.
Recently I had the opportunity to prove to my employer that a proper
redesign of an existing Access solution was the better choice to make. The
previous design was completed by what Access professional developers would
consider a rookie. Over 30 users were sharing the same MDB program which
also included the tables. Egad!
The business was screaming for help and the IT staff, not knowing any
better, claimed that if they pushed the data to SQL Server, the problems
would go away. Wrong!
I rewrote the application using unbound forms and split it into an MDE and
MDB, altering the Shift-Key-Bypass property in both to prevent unwarranted
access. The business loves it! The amount of data created annually didn't
justify moving it to SQL and I knew their connectivity issues would be
corrected once they used my application.
I have been writing applications in Access for over 7 years, learning and
growing each year.
I had the opportunity to attend the Advisor Developer's Conference in
Phoenix. After attending a session that spoke highly of
Total Access Analyzer and
the other FMS Access tools, I knew I had to purchase them. Thanks to your
company's products I have reduced my development time and technical
documentation time greatly.
Once again, thanks for your document and I look forward to reading more.
Information Systems, Enterprise Rent-a-Car
I just wanted to thank you for providing a link to the FreeWheel utility that enables scrolling within the Visual Basic
window. What a joy it is to be able to move up and down
the screen freely. My partner thinks I'm completely
barking that such an insignificant thing could provide
such pleasure but I'm sure you guys know how frustrating
it is to keep moving the scrollbar manually.I always
read your tips section in the newsletter as I'm
self-taught and work from home mostly so I don't get the
benefit of working with other more experienced
colleagues and pinching all their good ideas! Thanks
--Linda Lawson, United Kingdom
Hey, I love you guys. I didn't know about the Access decompile tip.
During development, my application database had ballooned to over 21
megabytes. I ran the
Microsoft Access decompile tip, compile and save modules, and
compacted, and it was reduced to just over 12 megs; what a huge
reduction!! I'm amazed. Thanks for this great tip. It was just what I
-- M. Baldwin
"In this field, I need every resource possible to keep me more
up-to-date than my clients; the FMS Buzz provides me with just that type
of valuable information with each and every issue."
-- James Overholser
The Buzz is a monthly Free email newsletter. If there is any topic you
would like our experts to cover in future articles just let us know. You
don't want to miss another priceless issue.
or Change Address Now!