|| Feedback | A report template | 20 things to do with a Query ||
Access contains a helpful wizard which allows you to place a button on a form that will open a report. If you have several reports you may wish to create a reports manager which lists them and provides a choice of displaying, printing or saving them to disk.
In this example, design a simple form containing two Option Groups. The left hand group shows the various reports made available to the user and the right hand group gives a choice of destination. If you have a large number of reports you can use the Tab Control with a separate Option Group on each tab. These tabs could all share a single destination Option Group.
The XPS option generates a report file which can be shared by other Windows users. The program code can be easily modified to choose PDF or Rich Text Formats. Look at the program help for the DoCmd.OutputTo command to see the various options.
Each of the Option Groups can be created using the design wizard. Add a button to the form and link the following VB code to the button's On Click event.
A study by accountants Coopers and Lybrand has shown that 90% of spreadsheets with more than 150 rows contain errors. Check out my information on creating well designed spreadsheets.
|file: areptmngr.htm||© MeadInKent.co.uk 2014||Page last updated Apr14|