|Subject:||Re: Active X and Data Grid|
|Posted by:||onedaywhen (onedaywh…@fmail.co.uk)|
|Date:||18 May 2004|
"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
Active X and Data Grid posted by Richard Mogy on Sun, 16 May 2004