Editing a flexgrid

[Philippe]

Hello,

I would like to edit a MSHflexgrid in Access 2000, as I've done many times
in VB6, using a floating Textbox.

However in Access, my textbox always appears BEHIND the FlexGrid control,
and so it is always hidden, even if I bring it to front in design view. And
there is no Zorder method in Access as there is in VB.

Is there a solution?

 

[Warren]

Hi Philippe,

I would just like to add another question to your post, please forgive
the backwards step.

What is a flexigrid, and how does it work? What do the grid controls
do? I'm hoping they allow data to be displayed in a html-style table on
a report (if so, how?)


Thanks Philippe,

Warren

 

[Philippe]

Hi Warren,

A Flexgrid is an ActiveX object that you can include in a form. To use it,
you must set a reference to "Microsoft Hierarchical MSHFlexgrid" in your
project.

It allows to display data in a tabular way, as you can see in Excel for
example. It is very flexible to display tabular data.

The problem is that a Flexgrid doesn't allow for editing the values in the
table. To edit the value in a cell, you must superpose a "floating" TextBox
on this cell, copy the data from the FlexGrid to the Textbox, edit the data,
and then copy again from the TextBox to the FlexGrid cell. It works fine in
VB6, but in Access, I cant manage to put the TextBox in front of the
FlexGrid, it always appears behind and is hidden.

 

[mtermoul]

In my case I just wanted to put an image on top of the grid saying "Loading,
please wait..." however I couldn't position the image on top of the flexgrid
no matter what until I found out about the subforms.
So to solve the issue I've put my image in a subform and put the subform on
top of the flexgrid and it works, since Access is saying that subforms and
list boxes will always be on top of other controls no matter what!

I hope that this is helpful.