Category Archives: Old Material

Top Values, Hierarchical Lists, and Almost Equivalent Strings

This month, Ken takes on three topics:  modifying the Top Values property of a query, selecting items from a hierarchical list on a form, and why two equivalent strings really aren’t. The next two topics apply equally to both Access … Continue reading

Posted in Old Material | Leave a comment

Surfs Up with Doug

This month, Doug gets some questions that send him back to an earlier topic: linking your Access application into data on the Internet. How can I get information from the Internet into my app? Back in November 2003, I wrote … Continue reading

Posted in Old Material | Leave a comment

Your Listbox-Filling Options

Powerful list and combo boxes have always been an important part of Access as Andy Baron shows in this article. This article uses SQL Server as a back-end. Combo and list boxes have always been very full-featured in Access. Access … Continue reading

Posted in Old Material | Leave a comment

Using Access to Prototype for SQL Server

As Jamie shows, even when you’re working with SQL Server, Access can have an important role to play. Here’s what to do to make sure that you get the most out of using the two tools together. Because I’m a … Continue reading

Posted in Old Material | Leave a comment

Working with or without a DSN

This month, Doug Steele answers questions about connecting to external databases like SQL Server and Oracle. Okay, I know how to work with desktop data sources other than Access, such as Excel or dBase. What about using other databases such … Continue reading

Posted in Old Material | Leave a comment