Grid and ADO

[George]

Hi all,

I have XP and am using ADO Recordset to populate a grid.
However I got stuck, not knowing which grid component to
choose.

The grid needs to be able to display data that is
editable. The user wants to just click on a cell and
changes its value and it's done. There will not be a lot
of rows and cols.

Which grid should I use between MS FlexGrid and MS
DataGrid? Can anyone give me some pointers?

Also, after placing both of them on a form and trying to
accessing their properties, the IntelliList (the thing
that after typing a dot brings up a list of properties and
methods) only shows a "standard" list of properties and
methods, and they are identical for both controls. Am I
missing anything?

TIA.

 

[Chris Nebinger]

Yes, you are missing the entire point of Access. You
should be using subforms to display and edit the data.
Using Datasheets gives more power to the user, and is also
alot faster.


Chris Nebinger

 

[George]

Thanks Chris for your reply. However my question was which
grid I should choose based on my needs.

Also when I asked "am I missing anything" I refered to why
the IntelliList only brings up what appears to be a
partial list of properties and methods.

George

 

[Chris Nebinger]

After rereading my reply, it might sound a bit sarcastic.
Sorry, not intended.

Yes, IntelliList only brings up partial lists, mostly
ActiveX standards. I get around it by:

Dim d As DataGrid
Set d = Me.ActiveXCtl0.Object


Now intellisense works.

But, let me get back to my original thought. Why would
you use a DataGrid as opposed to a subform datasheet?
With the subform, you wouldn't have to write any code, it
would just work.

Anyway, good luck. Let me know if I can be of any more
help.


Chris Nebinger

 

[Albert D. Kallal]

Any reason you don't use the built in controls or a continues form?

Why do you need a grid control?

Check out the following screen shots....these are done in ms-access..and no
grid control was needed...

And, you can edit the data..no code is needed to fill to grid..or to edit
it...!

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm