Report wizard

[Jade5]

Hello:
Is there a way to open the report wizard from a form and allow the user to
create reports and save them to their hard drive instead of to the database?
Thanks,
J.

 

[Duncan Bachen]

Hello:
Is there a way to open the report wizard from a form and allow the user to
create reports and save them to their hard drive instead of to the database?
Thanks,
J.

Nope. All the report objects in Access are stored within the database.
That being said, you should look at splitting your database into a front
end/back end if you haven't done so already.

This will give each person their own local copy of the front end, so
that the reports that they create are only available to them and not
bloating the overall database -- since the backend only contains the data.

This might be the solution to your problem

 

[BruceM]

Note that you can export a report to another format such as .xls or .rtf.
However, if you mean to have users create reports, see Duncan's response.

 

[Jade5]

Thank you

Nope. All the report objects in Access are stored within the database.
That being said, you should look at splitting your database into a front
end/back end if you haven't done so already.

This will give each person their own local copy of the front end, so
that the reports that they create are only available to them and not
bloating the overall database -- since the backend only contains the data.

This might be the solution to your problem

 

[Jade5]

Thank you Bruce.
J.

Note that you can export a report to another format such as .xls or .rtf.
However, if you mean to have users create reports, see Duncan's response.