Datagrid

[milly]

Hi all!
I have to bound a datagrid in a form, to a table in access db, is it
sufficient
Set datagrid1.datasource = rs

where rs is my recordset.

thanks.
Milly

 

[Ron Weiner]

Milly

Is there any specific reason that you are considering using a Active X
datagrid control in lieu of the intrinsic Access Form in Datasheet view
bound to the recordset? Access is not the most friendly place on the planet
for Active X controls and I try to avoid them at all costs. Unless you need
some truly obscure capability that an Access Form CANT do I'd recommend you
rethink this.

Ron W
www.WorksRite.com

 

[Albert D.Kallal]

Hi all!
I have to bound a datagrid in a form, to a table in access db, is it
sufficient
Set datagrid1.datasource = rs

I suppose it depends on what datagrid you are using. There are MANY out
there.....

Also, not all data grids can accept a dao, or ado reocrdset....you don't
mention what kind of reocrdset you created.

Further, as mentioned, if possible, you might find using a multi-column
listbox, or a continues form better. Here is some screen shots of a listbox,
and continuous forms that displays data as a grid.

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

The above might give you some ideas, and thus eliminate he need for a
activeX control.