DataGrid Control and ADO Jet 4.0 Provider 
Author Message
 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  
 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  
 
 [ 2 post ] 

 Relevant Pages 

1. ADO Data Control fails to refresh with Jet 4.0 provider

2. question for DataGrid and MS Jet 4.0 OLD DB Provider

3. ADO 2.1, Jet 4.0 as a Provider ?

4. Replace OLEDB provider Jet 3.51 with Jet 4.0

5. ADO Jet 4.0 performance problem vs Jet 3.51

6. Data Environment/Jet 4.0 OLE DB Provider problem

7. How to set Format property in ACCESS2k thru ADOX using JET OLEDB 4.0 provider

8. OLE DB Provider 4.0 for Jet SLOW

9. Create Jet 3.5x DB with OLE DB Provider 4.0

10. OLE DB Jet Provider 3.51 or 4.0 ?

11. Jet Provider 4.0

12. JET 4.0 ole db provider

 

 
Powered by phpBB® Forum Software