Grid and ADO

  • Thread starter Thread starter George
  • Start date Start date
G

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.
 
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
 
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
 
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
 
Back
Top