victorlong
asked on
List control bound to a field?
Hi,
After connecting a mdb by ADO
Dim oCon As New ADODB.Connection
Dim oRec As New ADODB.Recordset
oCon.Open "Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=c:\try.mdb"
oRec.Open "select * from table1", oCon
How to bind a list control to a field?
After connecting a mdb by ADO
Dim oCon As New ADODB.Connection
Dim oRec As New ADODB.Recordset
oCon.Open "Provider=Microsoft.Jet.OL
oRec.Open "select * from table1", oCon
How to bind a list control to a field?
set list1.datasource = orec
ASKER
Hi emoreau,
What is orec?
You mean using ADODC control or not? Can you show me the whole code?
What is orec?
You mean using ADODC control or not? Can you show me the whole code?
oRec is your recordset!
Dim oCon As New ADODB.Connection
Dim oRec As New ADODB.Recordset
oCon.Open "Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=c:\try.mdb"
oRec.Open "select * from table1", oCon
set list1.datasource = orec
Dim oCon As New ADODB.Connection
Dim oRec As New ADODB.Recordset
oCon.Open "Provider=Microsoft.Jet.OL
oRec.Open "select * from table1", oCon
set list1.datasource = orec
ASKER
Hi emoreau,
Thank you.
But list1 will be bound with which fiels? How a list is bound to a whole recordset ?
Thank you.
But list1 will be bound with which fiels? How a list is bound to a whole recordset ?
ASKER
Hi emoreau,
And I have just tested we can not set property, DataSource during run time.
And I have just tested we can not set property, DataSource during run time.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nobody can help me ??
Or, perhaps using ADODC control would be easier?