I have a database in visual basic 6 and the data is viewed in text boxes. Now, when I'm cycling through the records with the arrows on my adodc, I only want to see certain records in this database. I can't seem to get it to stop showing me the ones I don't want it to display. I've tried if statements and a loop but I can't get it to work. :-(
2007-04-10 02:00:09 · 4 answers · asked by teh_samby 2 in Computers & Internet ➔ Programming & Design
Try the case loop, it works better than the if
2007-04-10 02:04:28 · answer #1 · answered by SAgirl 5 · 1⤊ 0⤋
Instead of connecting the db controls on your form to the basic table, connect them to a query which only returns the values you want. Look in your database documentation for how to set up a query.
2007-04-10 02:24:57 · answer #2 · answered by Daniel R 6 · 1⤊ 0⤋
try changing the SQL to limit the result set with a WHERE clause
2007-04-10 02:10:52 · answer #3 · answered by Anonymous · 0⤊ 0⤋
There is no control. But there is a method. Find.
2016-05-21 05:24:34 · answer #4 · answered by ? 3 · 0⤊ 0⤋