Re: Active X and Data Grid

Giganews Newsgroups
Subject: Re: Active X and Data Grid
Posted by:  onedaywhen (onedaywh…
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



In response to

Active X and Data Grid posted by Richard Mogy on Sun, 16 May 2004