topic Re: in VBA Forum

Where is MSFlexGrid in VBA?

Anonymous — Sun, 31 Oct 1999 03:32:26 GMT

Where is MSFlexGrid in VBA? I want to fill a grid with data from a database
table. All the connection and recordset stuff in my program is working just
fine, but I want to display the contents of a recordset in a scrollable grid
for viewing.

Re: Where is MSFlexGrid in VBA?

Anonymous — Sun, 31 Oct 1999 18:57:35 GMT

VBA doesn't anywhere near the number of available controls VB does so you'll
find yourself forced to deal a tremendous loss of functionality unless you
own a copy of VB. If you do, you can always add VB controls to your tool
palette.

Matt Slay wrote in message
news:7vgd8s$9q79@adesknews2.autodesk.com...
> Where is MSFlexGrid in VBA? I want to fill a grid with data from a
database
> table. All the connection and recordset stuff in my program is working
just
> fine, but I want to display the contents of a recordset in a scrollable
grid
> for viewing.
>
>
>
>

Re:

Anonymous — Sun, 31 Oct 1999 22:12:13 GMT

I do own VB6.0 Professional and it is installed on the same machine as
Acad2000.

Now what?

Even if I get it working on my local machine, what will happen if someone
else in the office (or if I post my program on the internet) tries to run
the .dvb file and they do not have VB installed on there machine?

Frank Oquendo wrote in message
news:7vi3db$crg5@adesknews2.autodesk.com...
> VBA doesn't anywhere near the number of available controls VB does so
you'll
> find yourself forced to deal a tremendous loss of functionality unless you
> own a copy of VB. If you do, you can always add VB controls to your tool
> palette.
>
> Matt Slay wrote in message
> news:7vgd8s$9q79@adesknews2.autodesk.com...
> > Where is MSFlexGrid in VBA? I want to fill a grid with data from a
> database
> > table. All the connection and recordset stuff in my program is working
> just
> > fine, but I want to display the contents of a recordset in a scrollable
> grid
> > for viewing.
> >
> >
> >
> >
>
>

Re:

Anonymous — Mon, 01 Nov 1999 03:16:21 GMT

Exactly. However, VB can help solve that problem, too. Create a setup for
your dvb. Just be sure to avoid creating unnecessary icons.

Matt Slay wrote in message
news:7viesk$cp39@adesknews2.autodesk.com...
> I do own VB6.0 Professional and it is installed on the same machine as
> Acad2000.
>
> Now what?
>
> Even if I get it working on my local machine, what will happen if someone
> else in the office (or if I post my program on the internet) tries to run
> the .dvb file and they do not have VB installed on there machine?
>
>
>
> Frank Oquendo wrote in message
> news:7vi3db$crg5@adesknews2.autodesk.com...
> > VBA doesn't anywhere near the number of available controls VB does so
> you'll
> > find yourself forced to deal a tremendous loss of functionality unless
you
> > own a copy of VB. If you do, you can always add VB controls to your tool
> > palette.
> >
> > Matt Slay wrote in message
> > news:7vgd8s$9q79@adesknews2.autodesk.com...
> > > Where is MSFlexGrid in VBA? I want to fill a grid with data from a
> > database
> > > table. All the connection and recordset stuff in my program is working
> > just
> > > fine, but I want to display the contents of a recordset in a
scrollable
> > grid
> > > for viewing.
> > >
> > >
> > >
> > >
> >
> >
>
>

Re: Where is MSFlexGrid in VBA?

Anonymous — Thu, 04 Nov 1999 20:54:56 GMT

I've been having the same problem. The only way I've found around it is to
create another dummy program with a FlexGrid on it & make a SETUP.EXE.
Also, have you had any problems with the coordinates and/or Z-order with
MSFlexGrid? I had posted a question about that in the middle of October. I
can no long find it in this NG, but here's the jist:
It looks like most of the calls like ColWidth are returning values in points
instead of twips. They seem to be 20 times the twips number I'd get in VB6.
Second problem was the if I try to create an EditBox & place it on top of
the FlexGrid, it disappears. It still works, but you can't see it! It acts
as though its under the FlexGrid.
Too bad, 'cause you can do some really nice stuff with that MSFlexGrid.

Matt Slay wrote in message <7vgd8s$9q79@adesknews2.autodesk.com>...
>Where is MSFlexGrid in VBA? I want to fill a grid with data from a database
>table. All the connection and recordset stuff in my program is working just
>fine, but I want to display the contents of a recordset in a scrollable
grid
>for viewing.
>
>
>
>