Design a report

[Alfred]

Hi
I am using access 2002
How can I give my clients the right to alter (design) a report

I only supply them with the mde file.

Thanks
Alfred

 

[Rick Brandt]

Hi
I am using access 2002
How can I give my clients the right to alter (design) a report

I only supply them with the mde file.

You can build an interface that allows them to *configure* your reports. By
that I mean they can choose criteria, which fields to sort on, whether they want
to include grouping levels or not and all of those changes can be applied in the
Open event of the report. These changes would not be permanent of course, but
only apply to that instance of the report.

If you need customization beyond this, then you have to give them an MDB. This
could be a separate MDB set up exclusively for this purpose so you can still
distribute an MDE of the main file.

 

[Duane Hookom]

You might want to import the objects from DH Query By Form from
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
This applet allows users to create their own queries on the fly. The query
"definitions" are stored in two tables in your app so users can modify and
re-run. The results of the queries are displayed in a datasheet subform. The
main form has option buttons that provide one-click ability to send the
results to print, Word Merge, Word Table, Excel, HTML, graph, CSV...