O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Constraining Query Choices with Combo Boxes

Users of decision-support applications, especially managers, aren't likely to be able or want to use Access's graphical Query Design window. Instead, most users prefer to pick criteria (SELECT query WHERE clause elements) from one or more lists of available options. One primary advantage of offering users a set of choices to construct a query is the ability to prevent execution of ad hoc queries that return an excessive number of rows. Accidentally returning thousands of rows or—even worse—a Cartesian product of a million rows or more can bring a multiuser application or the entire network to its knees. Network and database administrators call such events queries from hell.

Combo boxes are the better ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required