I'm not sure wheter this is possible, but I need to create an Access Report from VB. (Not just call it.)
My VB app creates a table in Access with columns changes depending on user choices.
(The amount of columns and also the column names).
The report is not very complex. If I run report wizard in Access by selecting the mentioned table as my datasource and following the wizard, I get the desired results, by using the default values. The problem comes in when the table structure change, the report structure does not refresh accordingly.
I suppose what I'm trying to ask is, is there a way to 'use' the MS Access Report Wizard from within VB, and if so how..?