Microsoft has released Service Pack 2 (SP2) for Microsoft Office 2010. It includes enhancements to Access, Excel, Groove, Office. Outlook, PowerPoint, Project, SharePoint, Visio, Word, and more.
Read our new paper listing:
Links to the Download and List of Enhancements
List of Updated Products
Microsoft Access Enhancements and Fixes:
Microsoft Access Object Issues
Repair and Compact Issues
Microsoft Excel Related Issues
Access Web/SharePoint Issues
Windows 8 64-bit Issue
Runtime Version
Known Issues from Microsoft
A Confirmed Bug between MS Access 2010 and SharePoint 2013
Additional Resources for Microsoft Office and Office 2010 SP1
FMS developer Molly Pell is a guest blogger on the Microsoft Access developer blog. This post demonstrates a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box.
We are often asked by Microsoft Office power users whether, why, and when they should use Microsoft Access versus Microsoft Excel. Especially when they are very comfortable using MS Excel and don’t understand the reasons why anyone would use MS Access or databases. We’ve written a new paper that describes the issues in detail:
How Microsoft Access and Excel Empower Information Workers
When working with ComboBoxes and ListBoxes, we often find the need to select the first item in the list by default. This can be done when the form loads, or when the rowsource values of the ListBox or ComboBox are changed.
We’ve written a new paper containing an explanation and sample database of how to do this with the ItemData(0) property.
Our example database contains a form with a ComboBox containing ProductCategoties, and a ListBox containing Products.
When the form loads, it selects the first Category in the list. When the Category is changed, the Products list is updated, and the first product is selected.
In Microsoft Access, a common need is to have multiple combo boxes or list boxes on a form, and to have the selection in one combo box limit the choices in a second combo box or listbox. For example, consider an Address form containing State and City lookups. When you select a state, you want the list of cities list to be limited the selected state.
This is known as cascading combo boxes or synchronized combo boxes.
We recently posted a tip and demo database containing a sample of species, both plants and animals, categorized by their taxonomic rank (kingdom, phylum, class, order, family, and genus). When you select the value “Animal” from the Kingdom combo box, the Phylum combo box is updated to only show Animal phylum. The Species list box is also filtered by your selection.
LinkedIn offers many opportunities for professionals to interact with each other. There are many groups available for the Microsoft Access, Azure, SQL Server, and Visual Studio .NET communities. Here are some of the vibrant groups we’ve discovered:
Microsoft Excel, Word, and PowerPoint 2010 have a new feature that allows you to recover unsaved documents, even ones that you never saved. This expands on the Autosave feature that was available for years, but unlike earlier versions of MS Office, the automated backups are not deleted when you close your Office host. Additionally, multiple versions of your file are maintained, so that you can return to an earlier version of your document.
A new feature in Microsoft Excel 2010 lets you insert tiny charts, or Sparklines, into worksheet cells. Sparklines are a powerful way to show a quick snapshot of data trends.
To insert a Sparkline:
Select the cell where you want to insert the mini chart.
On the Insert tab of the Ribbon, choose the desired Sparkline type in the Sparklines group:
A new feature in Microsoft PowerPoint 2010 allows you to broadcast slide shows to remote viewers over the web. All you need is a Windows Live ID. Microsoft provides a free Broadcast service, and creates the URL for you to share with your viewers. Just click File, Save & Send, Broadcast Slide Show, Broadcast Slide Show.
FMS is pleased to announce the release of Total Visual CodeTools 2010, the most popular commercial Visual Basic for Application (VBA) and Visual Basic 6 (VB6) coding product for the Microsoft Office/Access community.
Total Visual CodeTools is an add-in that is integrated with the module editor of all VBA platforms such as Microsoft Office, Access, Excel, Outlook, Word, etc. It offers a wide range of utilities to help developers become more productive when creating new code, taking over existing projects, and delivering more robust solutions.
“Total Visual CodeTools is by far my favorite third-party product,” says Alison Balter, author of Mastering Access Desktop Development, instructor and developer. “Total Visual CodeTools helps you get your job done more quickly and allows you to focus on the fun and exciting aspects of application development. My favorite feature is the Code Cleanup. If you’ve ever inherited a code-intensive database, you’ll appreciate this feature.”
Total Visual CodeTools 2010 includes many enhancements over its predecessor for Office 2007. In addition to supporting VBA in Office 2010, there are new options and better performance for Code Cleanup and Delivery, enhancements to many Code Builders including the Message Box Builder, Recordset Builder, Select Case Builder, and SQL Text Builder. New features simplify the replacement of existing error handling code, and the user interface is enhanced to support Windows 7. There’s also improved support for international languages and operating systems.
“We are very pleased to ship Total Visual CodeTools 2010,” said Luke Chung, President of FMS. “This version represents our seventh major release of this product and our continued support of the VBA and VB6 developer communities.”
Edwin Blancovitch of Advanced Developers in Puerto Rico adds, “I really recommend it. This tool definitely increased my productivity, allows for code optimization and quality, and best of all reduced my costs.”
“I really love Total Visual CodeTools,” said Peter Weinwurm of Axium Canada. “I am completely blown away by how much the products in the Total Access Developer Suite can do, and how much time they will save me.”
Product Information
Total Visual CodeTools supports all Visual Basic 6.0 and VBA development environments including all versions of Microsoft Office from Office 2000 through 2010. Additional information is available on these web pages:
Total Visual CodeTools can be purchased directly from FMS, corporate resellers, and international distributors. All FMS products include a 30-day money back guarantee.
Microsoft has released Service Pack 2 (SP2) for Microsoft Office 2010. It includes enhancements to Access, Excel, Groove, Office. Outlook, PowerPoint, Project, SharePoint, Visio, Word, and more.
Microsoft Azure and SQL Server
Microsoft SQL Server
A new feature in Microsoft Excel 2010 lets you insert tiny charts, or Sparklines, into worksheet cells. Sparklines are a powerful way to show a quick snapshot of data trends.
