Re: Active X and Data Grid

Giganews Newsgroups
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

--

Replies

In response to

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