VB & Database, DataGrid Control and ADO Jet 4.0 Provider

DataGrid Control and ADO Jet 4.0 Provider

Author	Message
Harold Disman #1 / 2	DataGrid Control and ADO Jet 4.0 Provider Hi, All I am using several stored Access queries.. approx 72, in a VB6 application. Long story on why we did not convert the queries to use a vanilla class function since they are very similar but thats another story. The question is.. I am using ADO Jet 4.0 DLL to execute the Access queries and populate a datagrid control dynamicly. No Connection Controls all "hand made" Class Functions are used. I know I can Append the WHERE clause in ADO using the .Filter method and I know I can Hide a column when the queries are ran from within ACCESS tm. is there a way I can Hide columns from the DataGRid without rewriting 72 Access queries or removing the Dynamic Nature of the DataGrid Control I am using. I populate it like Datagrid.DataSource = [CLASS Pointer].[CLASS Function(VAR1,VAR2,VAR3)] and The Control does all the rest very nicely. I can even adjust the size of the column but does anyone know if I can HIDE a column number from the GRID. I could "Hard Code" in the CLASS Function as I would be hiding the same ones for all 72 Access Queries. Thanks for your help and if I have not made the question clear enough respond and I'll give more detail. Harold Dismang DW Software Inc.
Mon, 21 Jun 2004 00:58:41 GMT

JK #2 / 2	DataGrid Control and ADO Jet 4.0 Provider To hide a column in the datagrid, set the column visible property to false like this: Me.DataGrid1.Columns("FieldName").visible = False NB: I have experienced that if the furthermost left (amd possibly the furthermost right) column is hidden, you will have difficulties controlling the cursor. Somehow, the cursor wanders into the hidden column if the column is in the left (or right). Hope this is what you are looking for :-) John Ku Quote: > Hi, All > I am using several stored Access queries.. approx 72, in a VB6 > application. Long story on why we did not convert the queries to use a > vanilla class function since they are very similar but thats another story. > The question is.. I am using ADO Jet 4.0 DLL to execute the Access queries > and populate a datagrid control dynamicly. No Connection Controls all "hand > made" Class Functions are used. I know I can Append the WHERE clause in ADO > using the .Filter method and I know I can Hide a column when the queries are > ran from within ACCESS tm. is there a way I can Hide columns from the > DataGRid without rewriting 72 Access queries or removing the Dynamic Nature > of the DataGrid Control I am using. I populate it like Datagrid.DataSource = > [CLASS Pointer].[CLASS Function(VAR1,VAR2,VAR3)] and The Control does all > the rest very nicely. I can even adjust the size of the column but does > anyone know if I can HIDE a column number from the GRID. I could "Hard Code" > in the CLASS Function as I would be hiding the same ones for all 72 Access > Queries. > Thanks for your help and if I have not made the question clear enough > respond and I'll give more detail. > Harold Dismang > DW Software Inc.
Mon, 21 Jun 2004 06:51:56 GMT

Page 1 of 1

[ 2 post ]