1. Start a new application. We’ll develop a form where we can skim through
the books database,
examining titles and ISBN values. Place an ADO
data control, two label boxes, and two text boxes on the form.
2. If you haven’t done so, create a data link for the BIBLIO.MDB database
following the steps given under Data Links in these notes.
3. Set the following properties for each control. For the data control and
the two text boxes, make sure you set the properties in the order given.
Form1:
BorderStyle - 1-Fixed Single
Caption - Books Database
Name - frmBooks
Adodc1:
Caption - Book Titles
ConnectionString - BIBLIO.UDL (in whatever folder you saved it in - select, don’t
type)
RecordSource - SELECT * FROM Titles
Name - dtaTitles
Label1:
Caption - Title
Label2:
Caption - ISBN
Text1:
DataSource - dtaTitles (select, don’t type)
DataField - Title (select, don’t type)
Locked - True
MultiLine - True
Name - txtTitle
Text - [Blank]
Text2:
DataSource - dtaTitles (select, don’t type)
DataField - ISBN (select, don’t type)
Locked - True
Name - txtISBN
Text - [Blank]
When done, the form will look something like this (try to space your controls
as shown; we’ll use all the blank space as we continue with this example):
4. Save the application. Run the application. Cycle through the various book
titles using the data control. Did you notice something? You didn’t have
to write one line of Visual Basic code! This indicates the power behind the data
tool and bound tools.
