Looking for the right ActiveX control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rene - 31 Mar 2005 14:16 GMT

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!

Reply to this Message

Terry - 31 Mar 2005 15:19 GMT

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

> Hello group,
>
[quoted text clipped - 18 lines]
>
> Thanx!

Reply to this Message

Scott McDaniel - 31 Mar 2005 17:29 GMT

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.

> Hello group,
>
[quoted text clipped - 18 lines]
>
> Thanx!

Reply to this Message

jeff@bennet-tec.com - 01 Apr 2005 00:57 GMT

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
    Jeff@Bennet-Tec.Com

    * 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

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

Reply to this Message