? on extending the Create Report Wizard

[Guest]

We want to use Ms Access reports and the Create Report Wizard to allow our
end users to do ad hoc reporting.

Since the Create Report Wizard really expects the base query to be already
created so that any joins or selection is already performed in the query, we
would like to allow the execute code from the button to create the query, (we
have that part figured out) then launch the provided Ms Access Create Report
Wizard.

If possible we would like to provide the base query name and the Report Name
to the wizard without the user typing these in, then allow user to go throgh
the rest of the wizard to create the complete report. But we can't find the
object name or method or whatever to get the standard Create Report Wizard to
come up.

 

[Duane Hookom]

If your required reports don't require a lot of formatting etc, consider
using the query-by-form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
applet allows users to select fields, set sorting and criteria, use combo
box for criteria, group and total,...

The results are displayed in a datasheet subform. There are several buttons
on the main form that allow users to send the results to print, CSV, Word
Merge, Word Table, Excel, HTML, graph,...