B
Brad Pears
I am working in Access 2000.
I am creating a dynamic query on the fly and wonder if someone could post
code that allows me to do the following with the querydef object...
1) delete a column from the queries field list after the query has been
created
2) set a column to be NOT displayed (I want it left in the query but just
not selected for display depending on circumstances)
3) Set sort order on a particular field (I wanmt to change this at
anytime...)
I can not seem to find anything for any of this. I tried using the querydef
objects ".fields.delete("fieldname)" method but that did not work at all.
There does not appear to be much available as far as properties go on the
querydef object's field list...
Thanks, Brad
I am creating a dynamic query on the fly and wonder if someone could post
code that allows me to do the following with the querydef object...
1) delete a column from the queries field list after the query has been
created
2) set a column to be NOT displayed (I want it left in the query but just
not selected for display depending on circumstances)
3) Set sort order on a particular field (I wanmt to change this at
anytime...)
I can not seem to find anything for any of this. I tried using the querydef
objects ".fields.delete("fieldname)" method but that did not work at all.
There does not appear to be much available as far as properties go on the
querydef object's field list...
Thanks, Brad