
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.