Microsoft DataGrid Control 6.0 (OLEDB)

[Oliver76]

I’m using a Microsoft DataGrid 6 and ADODC. In the Grid’s properties, in Layout tab, I’ve checked the checkedbox “button”. So that I can put or choose records from it like a combo box. But it gives me nothing. I don’t know if my code is correct… here it is…I’m already confused please help me!


Private Sub DataGrid1_Click()
Dim txt As String
txt = ("SELECT * FROM tblambot&quot
DataGrid1 = txt
‘My purpose is when I click the button in datagrid1 the records in tblambot should appear.
End Sub

‘Where tblambot is another table.
'Should i specify the field to use?

 

[vishnuprasad]

Use a ADO recordset to run your query and set the recordset to Datagrid/adodc.
'say rec is recordset
Set rec = datagrid1.recordset.

 

[Oliver76]

to vishnuprasad

when i declare this line "Set rec = datagrid1.recordset" it gives me an error. Saying "Method or data member not found" Heres the code...
private sub A_()
dim rec as recordset
set rec = datagrid1.recordset
...
...
endsub

Any suggestion, please clarify....

thanx in advace....

 

[sanjaya]

After a long gap in this area, a very lucid readymade control, named Hotkey DataGridPlus, is now available at

http://www.hot-soft.com

This control adds to the functionality of Microsoft DataGrid, is very easy to use, and is capable of handling data aware combo boxes, column size and capital letter convertion while entry.

If this is of your use...