Grid Control

[Guest]

There doesn't seem to be a grid control available with Access. A vsFlexGrid
came with our edition of Access but it didn't seem to include a license to
use it. What needs to be purchased to have access to Msflxgrd.ocx. Or, is
there another worthy grid control that is cheaply available??

 

[chris.nebinger]

What is wrong with subforms in datasheet format? Or you can make your
own continous forms. The sample databases that ship with Access (Time
& Billing , for example) include subforms that look like grid controls.


Chris Nebinger

 

[Albert D. Kallal]

Unless you have VB6,or the developer edition of ms-access, I don't think you
have the rights to distribute the grid control...

However, ms-access does have a native ability to display data in a grid
format. You can use a listbox, or a continues form..

....here is some screen shots of both...
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

 

[Guest]

I was hoping to be able to avoid having to deal with defining and interacting
with an underlying table. I just seems simpler to deal with an array that is
an integral part of the form. With tables I have to accomodate the
possibility that this form will have more than one instance open at a time
and will require several underlying tables (one per open form).

 

[chris.nebinger]

That makes sense. But, if you are not dealing with internal tables,
why are you using Access vs. VB6 or .NET?

And your third sentence is not correct. If you have a form based on a
table, with a subform based on a subtable (Orders and OrderDetails),
then multiple forms can be open. Access only locks the record that
you're currently on, not the entire table. And doing a simple
Form.Requery will ensure you have the most up to date data, without
worrying about filling an array.


Chris Nebinger