Ready to get started with anonymous questions today? It's easy! Learn more.
Polish Reports in Access
Posted on
10,182 Points
25:07
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled out.
If you haven't already seen it, watch and do all the steps for 'Create a Query and Grouped Report and Modify Design using Access'
https://www.experts-exchan
If you haven't already seen it, watch and do all the steps for 'Create a Query and Grouped Report and Modify Design using Access'
https://www.experts-exchan
Video Steps
1. Download the START and SOLUTION databases
ReportPolish_START_SOLUTION.zip2. Change equations for sum descriptions in each of the group footer sections to cut extra words.
Month format code is mmm-yy
Year format code is yyyy
Year format code is yyyy
3. Set Width of product category footer descriptive equation to 2.8 inches and Left to 0.2 inches.
4. Delete extra labels with the caption = sum
5. Set width of other group footer descriptive equations to 3 inches.
6. Set Top of sum amount controls to 0 in the group footer sections.
7. Bold header and footer group section controls.
8. Tighten spacing to reduce pages.
9. Set group sections to 'keep header and first record together on one page'.
10. Set Back Color and Alternate Back Color for each section:
- Product Category = aqua
- Day = orange
- Month = blue
- Year = green
- Day = orange
- Month = blue
- Year = green
11. Set group header and footer controls to Back Style = Transparent.
12. Save, Close, and Rename the report.
13. Modify the menu form to add a command button with a Click [Event Procedure] to open the report in print preview.
Remember to Debug, Compile, and then Save
14. Write VBA code to construct criteria that the user may have picked and ignore criteria that is not specified.
15. Modify the OpenReport code to call the criteria function for the WhereCondition argument.
Remember to Debug, Compile, and then Save
16. Now for the fun part ... open your new report for any date, or date range, or no criteria!
Featured Post
Join & Write a Comment Already a member? Login.
Suggested Videos
| Title | Views | Activity |
|---|---|---|
| The Email Laundry | 16 | |
| Microsoft Bookings Review | 146 | |
| How To Make a Graph with Microsoft Access | 123 | |
| Percona Server for MongoDB | 42 |
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
In this article, we’ll look at how to deploy ProxySQL.
- Databases
- Network Analysis
- Network Operations
- Network Security
- MySQL Server
- Network Architecture, Percona, *proxy servers, *Data Migration
Suggested Courses
Course of the Month9 days, 14 hours left to enroll
Next Video:How To Make a Graph with Microsoft Access