[Flex]Grid replacements? 1

[markSaunders]

Within forms that our application is to contain we require lists to be available for the user. The lists will be manipulated in a similar way to rows and columns in Excel with the addition of combos and calendars being available in certain columns.<br><br>can anyone recommend specific ActiveX objects that are already out there - what are their dis/advantages? or even just pass advice/tips in respect of this required object?<br><br>specific options that would be desireable include:<br><FONT FACE=monospace>ability to move columns<br>ability to sort by ...<br>ability to format specific cells (such as use combo, calendar, text box etc) - also we have our own ActiveX MaskedEdit box that would need to be used too!<br>ability to resize columns/rows</font><br>oh yes, and also <FONT FACE=monospace>the ability to save settings in the registry for a particular user</font><br><br>any comments/advice would be welcome.<br>Mark

 

[srikanthpalla]

why don't you try a list view control instead of a flex grid so that using win32 api you can move the columns by their column headers..

 

[markSaunders]

we are currently looking at the listbox, but what we need is a mixture of the functionality from the two really?

 

[Vince]

there are two ActiveX controls that we use on a regular basis for just this purpose <br><br>You can get demo versions of these controls at <br><br>True Grid 6 <A HREF="

http://www.Apexsc.com"

TARGET="_new">

http://www.Apexsc.com</A>

<br>VBAccelatator Grid <A HREF="

http://www.vbAccelerator.com"

TARGET="_new">

http://www.vbAccelerator.com</A><br><br><br>hope

this is useful <br><br>

 

[MikeLacey]

Mark,<br><br>If you can - stick to the MS controls. It's much easier to upgrade your work to the next version of VB if you use no 3rd party controls.<br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[markSaunders]

looking at the ActiveX objects advised by <i>Vinny</i> demonstrates just some of what it is possible; time permitting.<br><br>i agree with <i>Mike</i> in staying as close to the core product as possible, but unfortunately the <FONT FACE=monospace>FlexGrid</font> appears to have been neglected a little by MS. i dont think we want to go quite to the degree that, such as, TrueGrid goes but we will definately have to ActiveX the <FONT FACE=monospace>MSFlexGrid</font> to do the little bits of singing and dancing we need.<br>cheers<br>mark

 

[bigfoot]

True rid is a great product.&nbsp;&nbsp;The customer support is very good (I've galled them about 10x since Christmas).<br><br>But it wants to be a bound control, or you have to include it's other activex product called xarray.

 

[johnk]

We only use 2 controls other than from MS.&nbsp;&nbsp;And one of them is the TrueGrid6 from Apex.&nbsp;&nbsp;No problem in 4 years with upgrades for new VB versions.&nbsp;&nbsp;Apex is certainly a major factor in the controls market.&nbsp;&nbsp;However, I do acknowledge Mike's point that there needs to be good reason before using non-MS controls.<br><br>Due to our multi-tier architecture we use TrueGrid6 exclusively in the unbound mode, along with their xArray which eliminates the need for the cumbersome For..Next routine to populate the grid from the array.<br><br>Don't know whether it will answer all of your issues, but it has served us well. <p>John Kisner<br><a href=mailto:jlkisner@jlkisner.com>jlkisner@jlkisner.com</a><br><a href= > </a><br>

 

[markSaunders]

on TRUEGRID...<br><br>i am currently looking at the truegrid (where to start?!?) but a quick question that occured to me was are we likely to have lots of trouble trying to bind to a cobol application. as far as i am aware (almost guessing) we write our own odbc routines to get at the data - will this have a major impact on the usefulness of truegrid?<br>cheers<br>m

 

[MikeLacey]

Possibly yes. To bind controls like TrueGrid to the database you need to have either:<br><br>a Data Control;<br><br>or write your own Data Aware class - to which you can bind your controls. There's a good example of how to do this in the VB6 help that works with .CSV files. You would need to satisfy yourself that the effort needed to develop your own Data Aware Class would be justified... <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[katya]

we use Videosoft flexgrid which is used by MS as the heart of excel. It is an excellent product and documentation is very good. You can move, sort format total and combo box and column or cell.<br><br><A HREF="

http://www.componentsource.com"

TARGET="_new">

http://www.componentsource.com</A>

provide a downloadable demo for free<br><br>

 

[scking]

While using the VB6 Application wizard last night and generating an application to use the Heirarchical FlexGrid the wizard placed code on the load event that accomplishes much of what you are requiring. I tested the drag and drop to move columns, and it was able to sort. I'm not sure about using formatted controls. Concerning the registry save settings, that is a relatively easy piece of code to accomplish. From and of the supported events you can executed the SaveSettings function from VB6 or build you own functions to perform customized registry read/writes.

Steve King
Growth follows a healthy professional curiosity

 

[petermeachem]

You really need to look closely at Janus grid. Sold by componentsource. You move columns, group by columns, sort, calendars, combos, looks pretty, etc etc. Can't say about cobol abilities, but if truegrid can, then janus should be able to. Support is very good. The only thing I found that truegrid can do that janus can't is to highlight a selection of cells by dragging a mouse across them. Peter Meachem
peter@accuflight.com

Support Joanna's Bikeathon

http://www.accuflight.com/blue_peter_bikeathon_2002.htm

 

[petermeachem]

I've just seen the date at the top of this lot. Sorry, I didn't realise it was so old. Peter Meachem
peter@accuflight.com

Support Joanna's Bikeathon

http://www.accuflight.com/blue_peter_bikeathon_2002.htm