Active X and Data Grid

  • Thread starter Thread starter Richard Mogy
  • Start date Start date
R

Richard Mogy

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 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.
Click to expand...

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

--
 
Thank you.
onedaywhen said:
...


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

--
Click to expand...
 
Back
Top