Generating SQL

[Etienne]

Do anyone know if it is possible in Access to do what you
do in the Query Designer from code? A function that would
let you give it an array of the fields you want and then
it would return the SQL code you need to have the
information from all those fields. I would need this so
that a user choose the fields he want to display in a
report from a form and then I would need to make the SQL
statement to pass it to a PivotTable and PivotChart. That
way I can make "dynamic" reports from any data in a
standard template.

 

[BJ Freeman]

yes it is possible. If you have Visual Basic look up the "Visual Data
Manager" Source code.
it will give you most of the code you need to accomplish this.

 

[BJ Freeman]

here is a link to the Code
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vb98/html/v
didxcontents.asp

 

[Etienne]

But I suppose I could not use this code for a
professionnal application if I don't own a copy of Visual
Basic?

-----Original Message-----
yes it is possible. If you have Visual Basic look up the "Visual Data
Manager" Source code.
it will give you most of the code you need to accomplish

this.

 

[BJ Freeman]

it is sample code, and has no license.
however you can not use it as it is, in Access. you will have to modify it
to work with VBA.
Then again you may have to buy VB to get the sample code, if it is not on
the MSDN site anymore.