| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Active X and Data Grid
I am trying to access a SQL database and get a list for the user to select
from to be used in additional queries. I have created an ActiveX Data Object and a Data Grid Object, and I am trying to figure out how to link the two. In visual basic, in the properties, there is a line called datasource that links the two that isn't present in VBA. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
Active X and Data Grid
"Richard Mogy" wrote ...
I am trying to access a SQL database and get a list for the user to select from to be used in additional queries. I have created an ActiveX Data Object and a Data Grid Object, and I am trying to figure out how to link the two. In visual basic, in the properties, there is a line called datasource that links the two that isn't present in VBA. Any help would be appreciated. I assume you mean MSDATAGRD.OCX. I use it in an Excel project, but I'm using a recordset rather than a data control. The Datasource property is available at run-time e.g. Set DataGrid1.DataSource = rs -- |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
Active X and Data Grid
Thank you.
"onedaywhen" wrote in message om... "Richard Mogy" wrote ... I am trying to access a SQL database and get a list for the user to select from to be used in additional queries. I have created an ActiveX Data Object and a Data Grid Object, and I am trying to figure out how to link the two. In visual basic, in the properties, there is a line called datasource that links the two that isn't present in VBA. Any help would be appreciated. I assume you mean MSDATAGRD.OCX. I use it in an Excel project, but I'm using a recordset rather than a data control. The Datasource property is available at run-time e.g. Set DataGrid1.DataSource = rs -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
| Pulling data from grid | Excel Worksheet Functions | |||
| data not aligned in grid when printing | Excel Discussion (Misc queries) | |||
| I need to convert grid.doc to an Excel Grid. | Charts and Charting in Excel | |||
| Is it possible to use 'grid' as a value in vb to process XL data? | Excel Discussion (Misc queries) | |||
Linear Mode
