Opening 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

Opening Report

James Hopkins

3 months ago

Hey Richard and the Crew, I have added the Calendar Form into our Database. It is work great, thanks for the Addendum to the Calendar Seminar. But I am having a problem open the Calendar Report.

	Alex Hedley @Reply 3 months ago
Does it turn blue?

	James Hopkins OP @Reply 3 months ago

	James Hopkins OP @Reply 3 months ago

	Alex Hedley @Reply 3 months ago
What Control is `Calendar`?

	James Hopkins OP @Reply 3 months ago
No Alex, the Report has not Load. The Monthly Calendar Form Loads correct, but when opening the Report from the Form. It Errors out before it Loads. But without the Format Code it opens like this:

	James Hopkins OP @Reply 3 months ago

	Alex Hedley @Reply 3 months ago
`Forms!MonthlyCalendarViewF!Calendar`

	James Hopkins OP @Reply 3 months ago
Here's the Code in the Report: Details `Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim X As Integer Dim S1 As String, S2 As String For X = 1 To 42 S1 = "Date" & X S2 = "Day" & X If Month(Me(S1)) <> Month(Forms!MonthlyCalendarViewF!Calendar) Then Me(S2).BackColor = &HD8D8D8 End If Next X End Sub`

	Alex Hedley @Reply 3 months ago
But what Control is `Calendar` that you are referencing?

	James Hopkins OP @Reply 3 months ago
Yes, on the Monthly Calendar Form there is a "Calendar" Text Box name that but it does not same to load correctly.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Calendar Seminar Lessons.

Next Unseen

New Feature: Comment Live View