SQL Selection from Visual Basic 6.0

Question:
I’m trying to install a search facility on a database program I have written using VB6 and an Access database. I’ve opened by inserting a data control onto my form and linking it to my database, and appropriate table. This gets all the data from the table fine. How do I execute another SQL statement to refine the records into those that come back from the SQL statement?

Answer:
You can specify a SQL statement as the source for your data control. If you look up how to create a WHERE clause in SQL, that will allow you to filter your records to a smaller set.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: