MSHFlexGrid

[mcnews]

is it possible to use MSHFlexGrid with Access forms.
i don't see it in the list of controls.

 

[Albert D. Kallal]

is it possible to use MSHFlexGrid with Access forms.
i don't see it in the list of controls.

You have to make a distinction between the list of built in controls you see
in the toolbox, and that all of the various in many third party ActiveX
controls that you can also use in MS access. If you do click the little
hammer and wrench icon in the toolbox menu bar, you will actually see a list
of all installed ActiveX controls. You should see the flex grid control in
that list. Keep in mind not all of them will actually work with Microsoft
access. Furthermore since the ActiveX control is not part of the native
controls of a MS access, then documentation and how to use that control will
be outside the scope of this newsgroup.

While the flex grid is actually control form Microsoft, it's not built into
MS access. I would think long and hard before committing to using ActiveX
controls in MS access application. The number one reason for this
consideration is as a general rule you're not using an installer to set up
and install your application. Without the advantage of having an installer,
then you're gonna have to take very careful consideration to making sure
that these third party ActiveX controls are actually installed and
registered correctly on the target computer.

Furthermore pepin mind that you have to use the developer edition of the
ActiveX control, since even windows 3.1 had an licensing mechanism built in.
You simply just can't copy the activeX control to the target machine. Hence,
you'll need to use the developer edition of that control, and furthermore
you're also need to ensure that the ActiveX control is installed and
registered correctly on the target machine -- you have to satisfy both of
these important requirements.

I have some sample screen shots here of using the built in continuous forms
feature of MS access, and for the most part not only are they easier to use
than the Flex Grid, but are more flexible, and much less code is involved.
With conditional formatting, you can have rows show as different colors for
different values.

What's really terrific about continuous forms, is that they follow the same
coding an event modeled as your regular forms. If you use something like the
flex grid, then you're going have to write a lot of code to load up the
grid, pull data out of the grid, and even write data back to the table. It's
quite a bit work as compared to those continuous forms that does all the
work for you, and continuous forms also allow you to edit the data without
writing additional code.

here is the screen shots, they might give you some ideas:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

 

[mcnews]

You have to make a distinction between the list of built in controls you see
in the toolbox, and that all of the various in many third party ActiveX
controls that you can also use in MS access. If you do click the little
hammer and wrench icon in the toolbox menu bar, you will actually see a list
of all installed ActiveX controls. You should see the flex grid control in
that list. Keep in mind not all of them will actually work with Microsoft
access. Furthermore since the ActiveX control is not part of the native
controls of a MS access, then documentation and how to use that control will
be outside the scope of this newsgroup.

While the flex grid is actually control form Microsoft, it's not built into
MS access. I would think long and hard before committing to using ActiveX
controls in MS access application. The number one reason for this
consideration is as a general rule you're not using an installer to set up
and install your application. Without the advantage of having an installer,
then you're gonna have to take very careful consideration to making sure
that these third party ActiveX controls are actually installed and
registered correctly on the target computer.

Furthermore pepin mind that you have to use the developer edition of the
ActiveX control, since even windows 3.1 had an licensing mechanism built in.
You simply just can't copy the activeX control to the target machine. Hence,
you'll need to use the developer edition of that control, and furthermore
you're also need to ensure that the ActiveX control is installed and
registered correctly on the target machine -- you have to satisfy both of
these important requirements.

I have some sample screen shots here of using the built in continuous forms
feature of MS access, and for the most part not only are they easier to use
than the Flex Grid, but are more flexible, and much less code is involved.
With conditional formatting, you can have rows show as different colors for
different values.

What's really terrific about continuous forms, is that they follow the same
coding an event modeled as your regular forms. If you use something like the
flex grid, then you're going have to write a lot of code to load up the
grid, pull data out of the grid, and even write data back to the table. It's
quite a bit work as compared to those continuous forms that does all the
work for you, and continuous forms also allow you to edit the data without
writing additional code.

i was asking about the MS H FlexGrid.
i have a VB6 app that has some parts i'd like to move to Access.
lots of code centered around the MSHFlexGrid.
so far i have it working pretty good with the MSFlexGrid, but some
stupid stuff isn't working right.