Dear reader
Place an ADODC control on your form in VB.
In the properties of the ADODC control goto the TAB General.
click "Use Connection String. With the button Build you can point to your database.
Thats it.
With the following code you can connect to db:
With Adodc
.RecordSource = "SELECT * From YOURTABLE"
.Refresh
End With
Now you have the table in the adodc control.
you can now do this:
Label1.caption = Adodc.Recordset!YOURFIELD
YOURTABLE = the name of your table in the database.
YOURFIELD = the fieldname in YOURTABLE you want to show.
Kind regards Fred.
171 views
Usually answered in minutes!
×