Allen Brown's Calendars

[Guest]

I am using Allen's Calendar Forms for start date and end date parameters on a
report. The source for the report is a query. I have put two text boxes
labeled start and end date in the header of the report naming the txt boxes
the calendars fill on the form as their individual control sources
(=Forms!frm_RptPayPeriod!txt_BeginPay), hoping to have the dates print in the
header of each page of the report. The dates only appear on the 1st page of
the snp view of the report and not on the remaining pages. When I print the
report the dates do not appear at all.what does get printed is #Name?.. Can
anyone tell me what I am doing wrong?

Thank You

 

[Jeff Conrad]

in message:

I am using Allen's Calendar Forms for start date and end date parameters on a
report. The source for the report is a query. I have put two text boxes
labeled start and end date in the header of the report naming the txt boxes
the calendars fill on the form as their individual control sources
(=Forms!frm_RptPayPeriod!txt_BeginPay), hoping to have the dates print in the
header of each page of the report. The dates only appear on the 1st page of
the snp view of the report and not on the remaining pages. When I print the
report the dates do not appear at all.what does get printed is #Name?.. Can
anyone tell me what I am doing wrong?

The first thing that jumps out at me is does the form stay open when you open the
report or does the form close when the report is opened?

Your issue will usually happen because the report will see the form to fill the text
boxes on the first page, but once the form closes, the text box cannot find the
references on the subsequent pages.

The usual way to handle this is to set the visibility of the form to False to hide
it behind the report. The report will still be able to get all the information since
the report is still open, but hidden. In the report's close event you can either
set the visibility of the form back to True or just close it all together.

Hope that helps,

 

[Guest]

That was it..... thanks Jeff!!!

in message:


The first thing that jumps out at me is does the form stay open when you open the
report or does the form close when the report is opened?

Your issue will usually happen because the report will see the form to fill the text
boxes on the first page, but once the form closes, the text box cannot find the
references on the subsequent pages.

The usual way to handle this is to set the visibility of the form to False to hide
it behind the report. The report will still be able to get all the information since
the report is still open, but hidden. In the report's close event you can either
set the visibility of the form back to True or just close it all together.

Hope that helps,

 

[Jeff Conrad]

in message:

That was it..... thanks Jeff!!!

Excellent, that is great news!
Glad to help.