Full Year Report - How To Build a Fully Functional Calendar Form and Printable Monthly Report in Microsoft Access


	Back to Calendar Seminar Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Full Year Report

Alfred Curling

6 days ago

i have managed to add a new report that creates all 12 monthly reports. The problem i have is that i cannot preview all 12 months , just the first one. I can print all 12 reports automatically but this doesn’t feel right albeit that it works.

I would like to generate the 12 monthly reports as a single multi-page report so that i can preview it and make a decision how to print it or save it to PDF

Has anyone got any ideas or suggestions where i could start.

	Alex Hedley @Reply 6 days ago
What are you previewing it with? Does it not have paging controls?

Alfred Curling OP @Reply

6 days ago

the code i am using is as follows:

Details

 For i = 1 To 12

    

       Me.Calendar = DateSerial(Year(Calendar), i, 1)

       StartDate = Me.Calendar



       While Weekday(StartDate) <> 1

            StartDate = StartDate - 1

       Wend

       MsgBox StartDate

       

       ' DoCmd.OpenReport "MonthlyCalendarR", acViewPreview

       DoCmd.OpenReport "MonthlyCalendarR", acViewNormal

       

       MsgBox (Forms!DatePickerF!Calendar)

   Next i

In the above loop you can see that i preview, although currently commented out, with acViewPreview
and auto print the report on each loop with acViewNormal

regards

Alfred

	Alfred Curling OP @Reply 6 days ago
I don't know about paging controls, could you point me in the right direction

	Richard Rost @Reply 6 days ago
You could do it by making the monthly report a sub-report. It's a work-around, that it should do it. Ideally, you would generate a single report that's got all 12 months' worth of data in it, but if you want each month printed out in the monthly format, then that gets tricky.

	Alfred Curling OP @Reply 6 days ago
Thanks Richard, Yes I want it in monthly format so that i can add an image on each month to create a family Calendar as presents

Richard Rost @Reply

6 days ago

This would actually make a pretty cool TechHelp video. I don't think I've covered something like this before: how to get specific sub-report items to show. Give me a couple of days, and I'll make a video explaining how this works. In a nutshell, basically, you'll create a master report for the year and then you'll create 12 subreports, one for each month. Linking them is tricky, but I'll show you how to do it in the video.

	Alfred Curling OP @Reply 6 days ago
Many many thanks Richard Live Long and Prosper………

Next Unseen

New Feature: Comment Live View