|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Ha! Good point... I was hoping that it was a common newby error. No such
luck. Ok. Here goes my attempt to summarize the details that may enable you
to pinpoint my error[s]:
PROBLEM: A form/dialog box, tied to the opening of a report with a subreport
prompting for beginning and ending dates for a report with a subreport, comes
ups approximately 12 times (i.e., I enter beginning and ending date and click
on the OK command button and then the form/dialog box comes up again).
Interestingly, if I enter the same beginning and ending dates 12 times, the
expeced data comes up in the report, but when I try to go to pages 2 and so
on, I am again prompted with the form/dialog box for the beginning and ending
dates.
SUMMARY OF UNDERLYING QUERIES AND RECORD SOURCES:
I have a main report with a sub report (see details on field and record
souces below). Each of these reports when opened as stand alone reports are
prompted ONLY ONCE with a form/dialog box containing two fields beginning
date and ending date (which limits the recordes by the datecompleted field)
according to this expression which I have in the query for the main report
and in the query for the sub report in the criteria row for the
completiondate field column:
---"Between [Forms]![Production Dialog]![BeginningDate] And
[Forms]![Production Dialog]![EndingDate]"---
DETAILS:
---main report fields from the underlying query---
[crewchief/text]; [completiondate/where criteria (so it does not actually
appear in the table]; [sumcontractamountcomplete/currency-calculated];
[sumoftotalexpenses/currency-calculated]; [sumprofit/percent-calculated];
[countofID/number]
---sub report fields from the unerlying query---
[crew chief/text]; [jobtype/text]; [salesman/text];
[completiondate/date/time];[customername]; [customeraddress/text];
[contractamountcomplete/currency]; [totalexpenses/currency-calculated];
[profit/percent-calculated]
---report link properties---
Master Field: [crewchief]
Child Field: [crewchief]
I hope this provides enough detail without too much extraneous infor to
offer some solutions or insight that may be causing the repeated dialog
box/forms.
Thanks so much!!!
Brandye
"Duane Hookom" wrote:
> I am having trouble seeing your screen to know what the dialog boxes say or
> what your report's record source looks like.
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "Baxter101" <Baxter101@discussions.microsoft.com> wrote in message
> news:9D225982-D23A-45E9-BAB1-1221A3FA1797@microsoft.com...
> > Duane (or another expert),
> > I set up a form to collect beginning and ending dates according to MS
> > Office
> > Online "Create a form to enter report critieria". It worked! BUT, now I am
> > prompted with like 12 dialog boxes before the report and subreport will
> > open.
> > Any suggestions???
> > Thanks in advance for your continued assistance!
> > Brandye
> >
> > "Duane Hookom" wrote:
> >
> >> Don't use parameter prompts for criteria. Always allow your users to
> >> enter
> >> values into controls on forms.
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >> --
> >>
> >> "Baxter101" <Baxter101@discussions.microsoft.com> wrote in message
> >> news:7BD708B9-7B92-4B54-90B0-9240636675A1@microsoft.com...
> >> >I have created a report and a subreport each based on different queries
> >> >with
> >> > 'Between [Type beginning date] And [Type ending date] criteria prompts.
> >> > When
> >> > I open the stand alone reports, I only get promted once for the
> >> > beginning
> >> > and
> >> > ending dates (as expected). However, when I open the report with the
> >> > subreport I get prompted many many times for the beginning and ending
> >> > dates.
> >> > So many times that it is difficult to count. I have tried removing the
> >> > criteria from the sub report via the underlying query thinking that the
> >> > main
> >> > report's criteria would apply to these records as well, but it did not
> >> > apply
> >> > to these records. Has anyone encountered this and come up with a
> >> > solution?
> >> > Any advice would help.
> >> > Thanks!!!
> >>
> >>
> >>
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
Are you opening the form/dialog box with code in the On Open event of the
report? If so, don't.
Open your criteria form prior to opening your report. Enter your criteria
values and then open the report.
--
Duane Hookom
MS Access MVP
--
"Baxter101" <Baxter101@discussions.microsoft.com> wrote in message
news:792C51F0-B6D5-4338-A163-92A04636C1AC@microsoft.com...
> Ha! Good point... I was hoping that it was a common newby error. No such
> luck. Ok. Here goes my attempt to summarize the details that may enable
> you
> to pinpoint my error[s]:
>
> PROBLEM: A form/dialog box, tied to the opening of a report with a
> subreport
> prompting for beginning and ending dates for a report with a subreport,
> comes
> ups approximately 12 times (i.e., I enter beginning and ending date and
> click
> on the OK command button and then the form/dialog box comes up again).
> Interestingly, if I enter the same beginning and ending dates 12 times,
> the
> expeced data comes up in the report, but when I try to go to pages 2 and
> so
> on, I am again prompted with the form/dialog box for the beginning and
> ending
> dates.
> SUMMARY OF UNDERLYING QUERIES AND RECORD SOURCES:
> I have a main report with a sub report (see details on field and record
> souces below). Each of these reports when opened as stand alone reports
> are
> prompted ONLY ONCE with a form/dialog box containing two fields beginning
> date and ending date (which limits the recordes by the datecompleted
> field)
> according to this expression which I have in the query for the main report
> and in the query for the sub report in the criteria row for the
> completiondate field column:
> ---"Between [Forms]![Production Dialog]![BeginningDate] And
> [Forms]![Production Dialog]![EndingDate]"---
>
> DETAILS:
> ---main report fields from the underlying query---
> [crewchief/text]; [completiondate/where criteria (so it does not actually
> appear in the table]; [sumcontractamountcomplete/currency-calculated];
> [sumoftotalexpenses/currency-calculated]; [sumprofit/percent-calculated];
> [countofID/number]
>
> ---sub report fields from the unerlying query---
> [crew chief/text]; [jobtype/text]; [salesman/text];
> [completiondate/date/time];[customername]; [customeraddress/text];
> [contractamountcomplete/currency]; [totalexpenses/currency-calculated];
> [profit/percent-calculated]
>
> ---report link properties---
> Master Field: [crewchief]
> Child Field: [crewchief]
>
> I hope this provides enough detail without too much extraneous infor to
> offer some solutions or insight that may be causing the repeated dialog
> box/forms.
> Thanks so much!!!
> Brandye
>
>
> "Duane Hookom" wrote:
>
>> I am having trouble seeing your screen to know what the dialog boxes say
>> or
>> what your report's record source looks like.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Baxter101" <Baxter101@discussions.microsoft.com> wrote in message
>> news:9D225982-D23A-45E9-BAB1-1221A3FA1797@microsoft.com...
>> > Duane (or another expert),
>> > I set up a form to collect beginning and ending dates according to MS
>> > Office
>> > Online "Create a form to enter report critieria". It worked! BUT, now I
>> > am
>> > prompted with like 12 dialog boxes before the report and subreport will
>> > open.
>> > Any suggestions???
>> > Thanks in advance for your continued assistance!
>> > Brandye
>> >
>> > "Duane Hookom" wrote:
>> >
>> >> Don't use parameter prompts for criteria. Always allow your users to
>> >> enter
>> >> values into controls on forms.
>> >>
>> >> --
>> >> Duane Hookom
>> >> MS Access MVP
>> >> --
>> >>
>> >> "Baxter101" <Baxter101@discussions.microsoft.com> wrote in message
>> >> news:7BD708B9-7B92-4B54-90B0-9240636675A1@microsoft.com...
>> >> >I have created a report and a subreport each based on different
>> >> >queries
>> >> >with
>> >> > 'Between [Type beginning date] And [Type ending date] criteria
>> >> > prompts.
>> >> > When
>> >> > I open the stand alone reports, I only get promted once for the
>> >> > beginning
>> >> > and
>> >> > ending dates (as expected). However, when I open the report with the
>> >> > subreport I get prompted many many times for the beginning and
>> >> > ending
>> >> > dates.
>> >> > So many times that it is difficult to count. I have tried removing
>> >> > the
>> >> > criteria from the sub report via the underlying query thinking that
>> >> > the
>> >> > main
>> >> > report's criteria would apply to these records as well, but it did
>> >> > not
>> >> > apply
>> >> > to these records. Has anyone encountered this and come up with a
>> >> > solution?
>> >> > Any advice would help.
>> >> > Thanks!!!
>> >>
>> >>
>> >>
>>
>>
>>
.
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
Question
Answer
Notify me of replies