I need help, because i must show to my users a filtered or query of access database. i already have the code to make the query i think so, but maybe it's wrong, so i need your help and some advices to make a good query and then show it to my user in the screen or printer.<br>thank's a lot<br>best regards.<br>i'll be waiting your answer.<br><br>atte. CARLOS AND FERNANDO.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to show in screen a filtered query of access database
- Thread starter cfyanez
- Start date
Are you allowing your users to input the "WHERE" part of the SQL in a free-form manner? Handling bad input by the user can be a problem.<br><br>I've seen some WHERE-clause designers that use drop-down listboxes and textboxes to allow their users to construct a query. Usually, they're like (in left-to-right order):<br> 1) listbox of available columns<br> 2) Listbox of comparison operators ("Like", "<", "<>", etc)<br> 3) Textbox for entering the right side of the comparison<br> 4) listbox or radio button to choose a conjunction: "and", "or", or <nothing><br><br>You still have to do some elementary parsing to check for input that makes sense. Or maybe just let it fail, and require that the user RTFM.<br><br>Chip H.<br>
- Status
