Access and SQL Part 5: More Instant Queries
By poweruser
Access and SQLPart 5: More Instant Queries
In the last part of this tutorial I showed how you could build an all-purpose query by supplying the user with a dialog box from which they could choose their query criteria. The dialog box had combo boxes displaying criteria choices and when the user clicked a command button their choices were used to construct an SQL statement. The SQL statement was then applied to a stored query and the user saw the result of their choices without having to get involved with query design. This tutorial takes the idea a stage further.
No comments:
Post a Comment