Mar 23

Microsoft Access Forms with Cascading Combo Boxes and List Boxes

Microsoft Access
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.

To learn more, read our Microsoft Access Cascading Combo Boxes tip and download our sample database demonstrating how to create cascading combo boxes and list boxes.

Feb 16

Linked In Communities for the Microsoft Access, Azure, SQL Server and Visual Studio .NET Communities


LinkedIn
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 Access, Excel and VBA

Microsoft AzureMicrosoft Azure and SQL Server


Visual Studio .NET

Aug 31

Recover Unsaved Documents or Return to an Earlier Version of Your Document in Microsoft Excel, PowerPoint, and Word 2010

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.

For more details, read our Mircosoft Office tip: Recover unsaved documents or return to an earlier version of your document in Microsoft Excel, PowerPoint, and Word 2010

Aug 26

Show Data Trends with Tiny Sparkline Charts in Microsoft Excel 2010

A new feature in Microsoft Excel 2010 lets you insert tiny charts, or Sparklines, into worksheet cells. Sparklinkes 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:

For more details, read our Microsoft Excel tip article: Show Data Trends with Tiny Sparkline Charts in Microsoft Excel 2010

Aug 26

Broadcast Microsoft PowerPoint Slide Shows to Remote Viewers for Free using Windows Live ID

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.

For more details, read our Microsoft PowerPoint tip: Broadcast Microsoft PowerPoint Slide Shows to Remote Viewers for Free using Windows Live ID