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!

Recent Issues

• May 2013
  Errant goose, Total Access Analyzer, Total Access Detective, Blaming Access and Excel, Query Sorting, Shortcut Keys, Outlook Tips, Sentinel Visualizer, Azure
• March 2013
  New Blog, Portland Access Conference, Updates for Total Visual CodeTools, Total Access Statistics, and Sentinel Visualizer, Union Queries
• November 2012
  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
• September 2012
  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 solutions
• July 2012
  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 Recovery Plans
• June 2012
  Total Access Emailer Feature, Announcements from TechEd, ComboBox Searches, Crosstab Queries, Taking Over an Existing Access application, LightSwitch applications
• April 2012
  Total Access Analyzer 2010 Update, Space Shuttle Fly-By, Microsoft Access vs. Excel, Top 5 Combo Box Tips, Update your SkyDrive
• March 2012
  Total Access Analyzer for Microsoft Access 2010 Ships, Tips for Cascading Combo Boxes and List Boxes, Virginia Governor, Smartphone Application, Impact Aid funding software
• February 2012
  Total Access Analyzer 2010 Preview, Total Access Detective 2010 Ships, Portland Access Conference, LinkedIn Groups, Education
• December 2011
  Happy Holidays! Total Access Components 2010 Ships, Popular Blog Topics, Windows 7 SP1 ADO compatibility, Sentinel Visualizer
• November 2011
  Free Preview of Total Access Detective 2010, Updates for Total Access Emailer and Total Visual CodeTools, MS Access 2010 Error Reference List
• September 2011
  Total Access Startup for Microsoft Access 2010 Ships, Using Terminal Services and RemoteApp, Treating Exchange and Outlook as a Database
• August 2011
  Total Visual CodeTools 2010 Ships, New Microsoft Access Developer Help Center, Innovations Video, Total Access Analyzer Product Review
• June 2011
  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 thanks!
--Greg Dermer

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

Luke,

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.
--D. Dowler, 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 again.
--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 needed.
-- 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.

Sign Up or Change Address Now!