Looking for the right ActiveX control

[Rene]

Hello group,

Here's my scenario:
- using AccessXP
- Frontend/Backend setup
- Frontend is 'disconnected', meaning that forms/controls are not bound
'live' to tables or recordsets on the back-end
- All back-end data access is implemented via a DataClass written in VB and
using DAO;
- FrontEnd obtains data for display primarily from 'Snapshot' recordsets.

Question:
Where can I find a suitable control to display Text AND CheckBox columns?
I don't insist on the control being 'data-aware'; I can fill it through code
if need be.
I want this control to allow editing/updating any given cell and to raise an
event after a cell update has completed; from that event I will invoke the
relevant DataClass method.

I've looked at the MSFlexGrid - it doesn't offer CheckBoxes;

Thanx!

 

[Terry]

It's a long time ago but I seem to remember that the original Flexgrid did
offer this option. When MS took up MS Flexgrid they used Flexgrid Lite -
Flexgrid stripped down. Flexgrid was originally developed by Videosoft, now
ComponentOne, who still market Flexgrid Pro which offers this functionality.
Check the ComponentOne web site
Terry

 

[Scott McDaniel]

Any decent grid control will work, but make sure it's listed to work in the
Access environment. FWIW, I use the Janus Grid:
http://www.janusys.com/janus/beta/products.htm. I've used in Access 2000 and
2002 with no real issues.

 

[jeff]

Our TList 7 ActiveX control will meet your needs.
TList will allow you to have both Text and Checkbox columns as well as
drop down, increment/Decrement, and date/time selection.
TList will also give you events after cell update is completed, as well
as events during update in case you need to handle this as well.
You can specify the type of cell on a row, column, or individual cell
basis.
You can also control which cells are editable and which are not.

Take a look at www.Bennet-Tec.com

Write back right here if you have any questions,
or drop me a note directly at Jeff @ Bennet-Tec.com
( Please include a copy of this posting with your note ).


Jeff Bennett
(e-mail address removed)

* Bennet-Tec Information Systems, Inc
* 50 Jericho Tpk, Jericho, NY 11753
* Phone 516 997 5596, Fax - 5597
* RELIABLE Components Make You Look Sharp!
* TList/Pro * ALLText HT/Pro * MetaDraw *
* Custom Software Development Services Too.
* WWW.Bennet-Tec.Com

=================== ===================