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!
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
Happy Holidays! Total Access Components 2010 Ships, Popular Blog
Topics, Windows 7 SP1 ADO compatibility, Sentinel Visualizer
Free Preview of Total Access Detective 2010, Updates for Total
Access Emailer and Total Visual CodeTools, MS Access 2010 Error
Total Access Startup for Microsoft Access 2010 Ships, Using
Terminal Services and RemoteApp, Treating Exchange and Outlook as a
Total Visual CodeTools 2010 Ships, New Microsoft Access Developer
Help Center, Innovations Video, Total Access Analyzer Product Review
Free Total Visual CodeTools 2010 Preview, New Microsoft Access Query
Center, Creating a Backup and Disaster Recovery Plan, Custom
Software Solutions for Large Businesses
Sign Up 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!