"Enter Parameter Value" box problem

[Guest]

I know this is a common problem, but I haven't been able to find a solution
by reading through past Discussions. The "Enter Parameter Value" box pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the "Price"
parameter.

The name of the control (text box) is "Price". The Control Source is:

=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])

If I just click OK on the Enter Parameter box, the report shows the correct
data based on the expression. From past problems, I know that I have to name
the Text Box something different from the field names. But obviously the
report is looking for value associated with the name of the control.

The query upon which the report is based works fine. It includes the
[POTotalPrice] and [AsBidBasePrice] fields.

I'm sure the solution is simple for those of you who know it! Why is it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane

 

[fredg]

I know this is a common problem, but I haven't been able to find a solution
by reading through past Discussions. The "Enter Parameter Value" box pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the "Price"
parameter.

The name of the control (text box) is "Price". The Control Source is:

=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])

If I just click OK on the Enter Parameter box, the report shows the correct
data based on the expression. From past problems, I know that I have to name
the Text Box something different from the field names. But obviously the
report is looking for value associated with the name of the control.

The query upon which the report is based works fine. It includes the
[POTotalPrice] and [AsBidBasePrice] fields.

I'm sure the solution is simple for those of you who know it! Why is it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane

If the query is OK with the prompt, then it is coming from the report.
The usual culprit is the Report's Sorting and Grouping dialog. You may
have once had a reference there to a [Price] field that has since been
removed from the report but not from the Sorting and Grouping dialog
box.

 

[Guest]

Fred,
Thanks, but ... I never had a field named "Price", and I've never sorted or
grouped on any of the fields related to price. Any other ideas?
Thanks!
Diane

I know this is a common problem, but I haven't been able to find a solution
by reading through past Discussions. The "Enter Parameter Value" box pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the "Price"
parameter.

The name of the control (text box) is "Price". The Control Source is:

=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])

If I just click OK on the Enter Parameter box, the report shows the correct
data based on the expression. From past problems, I know that I have to name
the Text Box something different from the field names. But obviously the
report is looking for value associated with the name of the control.

The query upon which the report is based works fine. It includes the
[POTotalPrice] and [AsBidBasePrice] fields.

I'm sure the solution is simple for those of you who know it! Why is it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane

If the query is OK with the prompt, then it is coming from the report.
The usual culprit is the Report's Sorting and Grouping dialog. You may
have once had a reference there to a [Price] field that has since been
removed from the report but not from the Sorting and Grouping dialog
box.

 

[Duane Hookom]

My guess is that you have attempted to Sum your Price text box in a group or
report footer. This doesn't work. You would need to Sum the expression:
=Sum(IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice]))


--
Duane Hookom
MS Access MVP
--

Fred,
Thanks, but ... I never had a field named "Price", and I've never sorted
or
grouped on any of the fields related to price. Any other ideas?
Thanks!
Diane

I know this is a common problem, but I haven't been able to find a
solution
by reading through past Discussions. The "Enter Parameter Value" box
pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the
"Price"
parameter.

The name of the control (text box) is "Price". The Control Source is:

=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])

If I just click OK on the Enter Parameter box, the report shows the
correct
data based on the expression. From past problems, I know that I have to
name
the Text Box something different from the field names. But obviously
the
report is looking for value associated with the name of the control.

The query upon which the report is based works fine. It includes the
[POTotalPrice] and [AsBidBasePrice] fields.

I'm sure the solution is simple for those of you who know it! Why is
it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane

If the query is OK with the prompt, then it is coming from the report.
The usual culprit is the Report's Sorting and Grouping dialog. You may
have once had a reference there to a [Price] field that has since been
removed from the report but not from the Sorting and Grouping dialog
box.

 

[fredg]

Fred,
Thanks, but ... I never had a field named "Price", and I've never sorted or
grouped on any of the fields related to price. Any other ideas?
Thanks!
Diane

I know this is a common problem, but I haven't been able to find a solution
by reading through past Discussions. The "Enter Parameter Value" box pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the "Price"
parameter.

The name of the control (text box) is "Price". The Control Source is:

=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])

If I just click OK on the Enter Parameter box, the report shows the correct
data based on the expression. From past problems, I know that I have to name
the Text Box something different from the field names. But obviously the
report is looking for value associated with the name of the control.

The query upon which the report is based works fine. It includes the
[POTotalPrice] and [AsBidBasePrice] fields.

I'm sure the solution is simple for those of you who know it! Why is it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane

If the query is OK with the prompt, then it is coming from the report.
The usual culprit is the Report's Sorting and Grouping dialog. You may
have once had a reference there to a [Price] field that has since been
removed from the report but not from the Sorting and Grouping dialog
box.

1) Once again, did you actually look in Sorting and Grouping? Don't
assume.

2) Somewhere in your report you have a control with a control source
expression, something similar to = [Price] * [Tax] and the field price
is not included in that section or in the report record source. You'll
have to look. Look for miss-spelled words, etc. It's there...
somewhere.

3) You write that you have a control named "Price". What happens if
you change that control name to "txtPrice",
Do you still get a prompt? Is the prompt now asking for 'txtPrice'
instead of Price?

4) When you do get that prompt try entering a strange bit of data,
such as 99999. See if that affects your report in any way.

5) Check your code. It may be in one of the report event's code.

 

[Guest]

Duane,
You're absolutely correct! That's what was happening, and when I inserted
the expression that you suggested, it worked fine. Thank you! Why doesn't
someone like you sit in the office next to me?!?
- Diane

My guess is that you have attempted to Sum your Price text box in a group or
report footer. This doesn't work. You would need to Sum the expression:
=Sum(IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice]))


--
Duane Hookom
MS Access MVP
--

Fred,
Thanks, but ... I never had a field named "Price", and I've never sorted
or
grouped on any of the fields related to price. Any other ideas?
Thanks!
Diane

On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:

I know this is a common problem, but I haven't been able to find a
solution
by reading through past Discussions. The "Enter Parameter Value" box
pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the
"Price"
parameter.

The name of the control (text box) is "Price". The Control Source is:

=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])

If I just click OK on the Enter Parameter box, the report shows the
correct
data based on the expression. From past problems, I know that I have to
name
the Text Box something different from the field names. But obviously
the
report is looking for value associated with the name of the control.

The query upon which the report is based works fine. It includes the
[POTotalPrice] and [AsBidBasePrice] fields.

I'm sure the solution is simple for those of you who know it! Why is
it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane


If the query is OK with the prompt, then it is coming from the report.
The usual culprit is the Report's Sorting and Grouping dialog. You may
have once had a reference there to a [Price] field that has since been
removed from the report but not from the Sorting and Grouping dialog
box.

 

[Guest]

Fred,
My problem was as Duane described it. Thanks for all your help!
-Diane

Fred,
Thanks, but ... I never had a field named "Price", and I've never sorted or
grouped on any of the fields related to price. Any other ideas?
Thanks!
Diane

On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:

I know this is a common problem, but I haven't been able to find a solution
by reading through past Discussions. The "Enter Parameter Value" box pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the "Price"
parameter.

The name of the control (text box) is "Price". The Control Source is:

=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])

If I just click OK on the Enter Parameter box, the report shows the correct
data based on the expression. From past problems, I know that I have to name
the Text Box something different from the field names. But obviously the
report is looking for value associated with the name of the control.

The query upon which the report is based works fine. It includes the
[POTotalPrice] and [AsBidBasePrice] fields.

I'm sure the solution is simple for those of you who know it! Why is it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane


If the query is OK with the prompt, then it is coming from the report.
The usual culprit is the Report's Sorting and Grouping dialog. You may
have once had a reference there to a [Price] field that has since been
removed from the report but not from the Sorting and Grouping dialog
box.

1) Once again, did you actually look in Sorting and Grouping? Don't
assume.

2) Somewhere in your report you have a control with a control source
expression, something similar to = [Price] * [Tax] and the field price
is not included in that section or in the report record source. You'll
have to look. Look for miss-spelled words, etc. It's there...
somewhere.

3) You write that you have a control named "Price". What happens if
you change that control name to "txtPrice",
Do you still get a prompt? Is the prompt now asking for 'txtPrice'
instead of Price?

4) When you do get that prompt try entering a strange bit of data,
such as 99999. See if that affects your report in any way.

5) Check your code. It may be in one of the report event's code.

 

[Duane Hookom]

How much do you pay and where are you ;-)

--
Duane Hookom
MS Access MVP
--

Duane,
You're absolutely correct! That's what was happening, and when I inserted
the expression that you suggested, it worked fine. Thank you! Why
doesn't
someone like you sit in the office next to me?!?
- Diane

My guess is that you have attempted to Sum your Price text box in a group
or
report footer. This doesn't work. You would need to Sum the expression:
=Sum(IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice]))


--
Duane Hookom
MS Access MVP
--

Fred,
Thanks, but ... I never had a field named "Price", and I've never
sorted
or
grouped on any of the fields related to price. Any other ideas?
Thanks!
Diane

:

On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:

I know this is a common problem, but I haven't been able to find a
solution
by reading through past Discussions. The "Enter Parameter Value"
box
pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the
"Price"
parameter.

The name of the control (text box) is "Price". The Control Source
is:

=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])

If I just click OK on the Enter Parameter box, the report shows the
correct
data based on the expression. From past problems, I know that I have
to
name
the Text Box something different from the field names. But
obviously
the
report is looking for value associated with the name of the control.

The query upon which the report is based works fine. It includes
the
[POTotalPrice] and [AsBidBasePrice] fields.

I'm sure the solution is simple for those of you who know it! Why
is
it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane


If the query is OK with the prompt, then it is coming from the report.
The usual culprit is the Report's Sorting and Grouping dialog. You may
have once had a reference there to a [Price] field that has since been
removed from the report but not from the Sorting and Grouping dialog
box.

 

[Basenji]

The "Enter Parameter Value" box appears. The text box is in the report
footer. I added "sum" to the beginning of the expression. When the report is
run, it returns 40 rather than 4, appearing to add numbers rather than
returning the number for the risk level.

E/ Risk Level=sum(IIf([ErrorRate
Percentage]<=0.15,"1",(IIf([ErrorRatePercentage]<=0.25,"2",(IIf([ErrorRatePercentage]<=0.35,"3",(IIf([ErrorRatePercentage]<0.5,"4","5"))))))))

Suggestions?

My guess is that you have attempted to Sum your Price text box in a group or
report footer. This doesn't work. You would need to Sum the expression:
=Sum(IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice]))


--
Duane Hookom
MS Access MVP
--

Fred,
Thanks, but ... I never had a field named "Price", and I've never sorted
or
grouped on any of the fields related to price. Any other ideas?
Thanks!
Diane

On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:

I know this is a common problem, but I haven't been able to find a
solution
by reading through past Discussions. The "Enter Parameter Value" box
pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the
"Price"
parameter.

The name of the control (text box) is "Price". The Control Source is:

=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])

If I just click OK on the Enter Parameter box, the report shows the
correct
data based on the expression. From past problems, I know that I have to
name
the Text Box something different from the field names. But obviously
the
report is looking for value associated with the name of the control.

The query upon which the report is based works fine. It includes the
[POTotalPrice] and [AsBidBasePrice] fields.

I'm sure the solution is simple for those of you who know it! Why is
it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane


If the query is OK with the prompt, then it is coming from the report.
The usual culprit is the Report's Sorting and Grouping dialog. You may
have once had a reference there to a [Price] field that has since been
removed from the report but not from the Sorting and Grouping dialog
box.