Linking a VB Form to Access

keith_hampson
10-15-2004, 12:58 PM
Hi i was jus wondering if someone could perhaps give me the a code so that my VB created form will display daat from an Access database?

My requirement is i will have a drop down list of peoples names and when that name is selected i want the info on that person in the Access data base to be displayed on the form.

Any help appreciated!!

Thanx

MikeJ
10-15-2004, 04:16 PM
I think you'll want to check out the ...

keith_hampson
10-19-2004, 11:58 AM
Hi i read the ADO tutorial but i'm having some problems!
This is the code i have,

Private Sub Command1_Click()

Dim MyConn As ADODB.Connection
Dim MyRecSet As ADODB.Recordset
Dim strPost As String


Set MyConn = New ADODB.Connection
MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Programming\Project\Database\Client.mdb;"
MyConn.Open

Set MyRecSet = MyConn.Execute("SELECT Postal Code FROM Customers")

Do Until MyRecSet.EOF
strPost = MyRecSet.Fields.Item("Postal Code").Value

lstData.AddItem strName

MyRecSet.MoveNext
Loop

MyConn.Close
End Sub

Could someone point as to why its wrong i get the error msg Sytax error (missing operator)

Thanx

loquin
10-19-2004, 01:11 PM
You didn't say which line was generating the error, but here's a couple of things I noticed:

You're adding the item of strName, yet you're getting strPost from the recordset.

Second, you need to add square brackets around the field name in the select statement because you're using a field name with a space in it. While Access allows spaces in field names, most real databases don't.

"SELECT [Postal Code] FROM Customers"

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum