access2k and datagrid control

[dwhawley]

using access 2000, i am trying to pass the results of a sql statement to a data grid control (or a flexgrid control if it is more convenient). from there, i want the user to be able to select the appropriate record which will then be displayed on the original form. unfortunately, i'm not quite sure how to get the data grid to display my results. does anyone have any suggestions?

[Dr_Evil]

If you use the MSFlexGrid Control you could try something similar to the following.


Dim cnn As Connection
Dim rs As Recordset
Dim cmd1 As New ADODB.Command
Dim str1 As String
Dim fldLoop As ADODB.Field

With cmd1
.ActiveConnection = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\\My Documents\Access Files\*.mdb;"
.CommandText = "SELECT `*` FROM `TableName`"
.CommandType = adCmdText
End With

'Run Query
cmd1.Execute

'Open Recorset on cmd1
rs.Open cmd1

Do Until rs.EOF

str1 = ""
For Each fldLoop In rs.Fields
str1 = str1 & fldLoop.Value
Next fldLoop
MSFlexGrid1.AddItem str1
rs.MoveNext
Loop

rs.Close