Date Prompts in Subreport

[Guest]

Is it possible to combine 2 reports together if they are both based on
queries that require date prompts?

The reason I am asking is that I have 2 reports of employee time, each for a
different department. Both are based on queries that have the criteria
Between [Beginning Date:] and [Ending Date:]. That way, when each report is
generated, the user can select the date range to display. Now, I am trying
to combine them so that they both show up on the same report. I tried making
one a subreport of another, but when I try to run the report, I keep getting
the date prompts over and over again and the report won't generate.

You have all been such a great help to me in the past, so any help you could
give would be much appreciated! Worst case scenario, I'll just have to make
my manager run 2 separate reports.

Thanks!

 

[Guest]

IMHO, parameter prompts should never be used. Consider kicking your
application up a notch and replace prompts with references to controls on
forms.

 

[Guest]

Excuse my inexperience, but could you elaborate on that or provide an
example? I'm not sure exactly what you mean. Thanks!!

IMHO, parameter prompts should never be used. Consider kicking your
application up a notch and replace prompts with references to controls on
forms.
--
Duane Hookom
Microsoft Access MVP

Is it possible to combine 2 reports together if they are both based on
queries that require date prompts?

The reason I am asking is that I have 2 reports of employee time, each for a
different department. Both are based on queries that have the criteria
Between [Beginning Date:] and [Ending Date:]. That way, when each report is
generated, the user can select the date range to display. Now, I am trying
to combine them so that they both show up on the same report. I tried making
one a subreport of another, but when I try to run the report, I keep getting
the date prompts over and over again and the report won't generate.

You have all been such a great help to me in the past, so any help you could
give would be much appreciated! Worst case scenario, I'll just have to make
my manager run 2 separate reports.

Thanks!

 

[Guest]

You create or use an existing form and place some text boxes or combo boxes
or other nice user interface controls. Users can then enter or select values
in these controls. You would then replace the [Enter Starting Date] prompt
with something like:
[Forms]![frmYourFormName]![txtStartDate]
Using controls on a form allows you to provide defaults, ignore nulls, check
for integrity, select from combo boxes, ....
--
Duane Hookom
Microsoft Access MVP

Excuse my inexperience, but could you elaborate on that or provide an
example? I'm not sure exactly what you mean. Thanks!!

IMHO, parameter prompts should never be used. Consider kicking your
application up a notch and replace prompts with references to controls on
forms.
--
Duane Hookom
Microsoft Access MVP

Is it possible to combine 2 reports together if they are both based on
queries that require date prompts?

The reason I am asking is that I have 2 reports of employee time, each for a
different department. Both are based on queries that have the criteria
Between [Beginning Date:] and [Ending Date:]. That way, when each report is
generated, the user can select the date range to display. Now, I am trying
to combine them so that they both show up on the same report. I tried making
one a subreport of another, but when I try to run the report, I keep getting
the date prompts over and over again and the report won't generate.

You have all been such a great help to me in the past, so any help you could
give would be much appreciated! Worst case scenario, I'll just have to make
my manager run 2 separate reports.

Thanks!

 

[Guest]

That does make a lot more sense. Thanks so much for your help.

You create or use an existing form and place some text boxes or combo boxes
or other nice user interface controls. Users can then enter or select values
in these controls. You would then replace the [Enter Starting Date] prompt
with something like:
[Forms]![frmYourFormName]![txtStartDate]
Using controls on a form allows you to provide defaults, ignore nulls, check
for integrity, select from combo boxes, ....
--
Duane Hookom
Microsoft Access MVP

Excuse my inexperience, but could you elaborate on that or provide an
example? I'm not sure exactly what you mean. Thanks!!

IMHO, parameter prompts should never be used. Consider kicking your
application up a notch and replace prompts with references to controls on
forms.
--
Duane Hookom
Microsoft Access MVP


:

Is it possible to combine 2 reports together if they are both based on
queries that require date prompts?

The reason I am asking is that I have 2 reports of employee time, each for a
different department. Both are based on queries that have the criteria
Between [Beginning Date:] and [Ending Date:]. That way, when each report is
generated, the user can select the date range to display. Now, I am trying
to combine them so that they both show up on the same report. I tried making
one a subreport of another, but when I try to run the report, I keep getting
the date prompts over and over again and the report won't generate.

You have all been such a great help to me in the past, so any help you could
give would be much appreciated! Worst case scenario, I'll just have to make
my manager run 2 separate reports.

Thanks!