Category Archives: Old Material

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. Note Time has … Continue reading

Posted in Old Material | Leave a comment

Trolling for Articles

In May, I was in Europe presenting at the Software Developer’s Group of the Netherlands “Conference to the Max” (and trolling for consulting work). There were a number of Smart Access contributors there, including Stephen Forte and Michael Kaplan. Stephen … Continue reading

Posted in Old Material | Leave a comment

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