Showing data dynamically

[Aenathras]

I don't know if anyone can help me with this one at all.

I have a query that contains all the possible data that my users will wish to get data from but I want them to have the option to show/hide particular columns to make the query ad-hoc.

I have some code that copies my query to another of a unique name during the course of their Access session so they end up with a query with the name 'ABC' for example that they can run.

If this query ABC has columns A,B,C,D which are all defaulted to be shown and the user decides they are not interested in columns B and C is there Access code that is equivilent to this pseudo-code?

ABC.A.Show = True
ABC.B.Show = False
ABC.C.Show = False
ABC.D.Show = True

where ABC is a query, A..D are columns and Show is the checkbox in the query definition.

That I can run in VB 6.3?

Aenathras

 

[Vassago]

Why would you post this in gaming? Moved to queryforum.

 

[Aenathras]

Access show query

Thank-you for being alert and moving that for me - I think I must have scrolled down a drop-down menu in error when starting my thread and I couldn't figure out how to changed it afterwards.



Still looking for suggestions though!

 

[pdx_man]

My suggestion would be to use a QueryDef object to re-write the underlying SQL.