If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I stop the expression Enter Parameter Value?
I have a report that used to draw from Query A. One of the fields in the
report, "Nominator," got its information from Query A. I've removed that field and changed the underlying query to Query B. But, when I try to open the report, a pop-up comes up that says "Enter Parameter Value" and says "Nominator." The thing is, the report is now drawing upon Query B, there is no "Nominator" field in Query B and there is no "Nominator" field in the report. Can somebody help? Thanks. |
#2
|
|||
|
|||
Check the Sorting and Grouping dialog.
-- Duane Hookom MS Access MVP -- "Eric Rodriguez" Eric wrote in message ... I have a report that used to draw from Query A. One of the fields in the report, "Nominator," got its information from Query A. I've removed that field and changed the underlying query to Query B. But, when I try to open the report, a pop-up comes up that says "Enter Parameter Value" and says "Nominator." The thing is, the report is now drawing upon Query B, there is no "Nominator" field in Query B and there is no "Nominator" field in the report. Can somebody help? Thanks. |
#3
|
|||
|
|||
Doing research on a similar problem. Not too clear on what is meant by the
statement "Check the Sorting and Grouping dialog." What need to be done in the dialog? In my case, I have created 4 groups. for the sake of argument, let's call them grp1, grp2, grp3, grp4. They are not based on any data elements in the tables. When I run the report, I receive the enter parameter input box for each of these. How do I turn these off? "Duane Hookom" wrote: Check the Sorting and Grouping dialog. -- Duane Hookom MS Access MVP -- "Eric Rodriguez" Eric wrote in message ... I have a report that used to draw from Query A. One of the fields in the report, "Nominator," got its information from Query A. I've removed that field and changed the underlying query to Query B. But, when I try to open the report, a pop-up comes up that says "Enter Parameter Value" and says "Nominator." The thing is, the report is now drawing upon Query B, there is no "Nominator" field in Query B and there is no "Nominator" field in the report. Can somebody help? Thanks. |
#4
|
|||
|
|||
The Sorting and Grouping dialog is opened by View-Sorting and Grouping. If
you want to remove these, click the selector button to the left of the expression and press the delete key. -- Duane Hookom MS Access MVP "Andy Dorph" wrote in message ... Doing research on a similar problem. Not too clear on what is meant by the statement "Check the Sorting and Grouping dialog." What need to be done in the dialog? In my case, I have created 4 groups. for the sake of argument, let's call them grp1, grp2, grp3, grp4. They are not based on any data elements in the tables. When I run the report, I receive the enter parameter input box for each of these. How do I turn these off? "Duane Hookom" wrote: Check the Sorting and Grouping dialog. -- Duane Hookom MS Access MVP -- "Eric Rodriguez" Eric wrote in message ... I have a report that used to draw from Query A. One of the fields in the report, "Nominator," got its information from Query A. I've removed that field and changed the underlying query to Query B. But, when I try to open the report, a pop-up comes up that says "Enter Parameter Value" and says "Nominator." The thing is, the report is now drawing upon Query B, there is no "Nominator" field in Query B and there is no "Nominator" field in the report. Can somebody help? Thanks. |
#5
|
|||
|
|||
Removing the grouping is not an option for me. Is there some way I can
programmatically override the request for the parameters? Thanks "Duane Hookom" wrote: The Sorting and Grouping dialog is opened by View-Sorting and Grouping. If you want to remove these, click the selector button to the left of the expression and press the delete key. -- Duane Hookom MS Access MVP "Andy Dorph" wrote in message ... Doing research on a similar problem. Not too clear on what is meant by the statement "Check the Sorting and Grouping dialog." What need to be done in the dialog? In my case, I have created 4 groups. for the sake of argument, let's call them grp1, grp2, grp3, grp4. They are not based on any data elements in the tables. When I run the report, I receive the enter parameter input box for each of these. How do I turn these off? "Duane Hookom" wrote: Check the Sorting and Grouping dialog. -- Duane Hookom MS Access MVP -- "Eric Rodriguez" Eric wrote in message ... I have a report that used to draw from Query A. One of the fields in the report, "Nominator," got its information from Query A. I've removed that field and changed the underlying query to Query B. But, when I try to open the report, a pop-up comes up that says "Enter Parameter Value" and says "Nominator." The thing is, the report is now drawing upon Query B, there is no "Nominator" field in Query B and there is no "Nominator" field in the report. Can somebody help? Thanks. |
#6
|
|||
|
|||
It isn't clear what is causing the parameters and why. If they are coming
from expression entered into the sorting and grouping then either delete them or suggest why you won't delete them. -- Duane Hookom MS Access MVP -- "Andy Dorph" wrote in message ... Removing the grouping is not an option for me. Is there some way I can programmatically override the request for the parameters? Thanks "Duane Hookom" wrote: The Sorting and Grouping dialog is opened by View-Sorting and Grouping. If you want to remove these, click the selector button to the left of the expression and press the delete key. -- Duane Hookom MS Access MVP "Andy Dorph" wrote in message ... Doing research on a similar problem. Not too clear on what is meant by the statement "Check the Sorting and Grouping dialog." What need to be done in the dialog? In my case, I have created 4 groups. for the sake of argument, let's call them grp1, grp2, grp3, grp4. They are not based on any data elements in the tables. When I run the report, I receive the enter parameter input box for each of these. How do I turn these off? "Duane Hookom" wrote: Check the Sorting and Grouping dialog. -- Duane Hookom MS Access MVP -- "Eric Rodriguez" Eric wrote in message ... I have a report that used to draw from Query A. One of the fields in the report, "Nominator," got its information from Query A. I've removed that field and changed the underlying query to Query B. But, when I try to open the report, a pop-up comes up that says "Enter Parameter Value" and says "Nominator." The thing is, the report is now drawing upon Query B, there is no "Nominator" field in Query B and there is no "Nominator" field in the report. Can somebody help? Thanks. |
#7
|
|||
|
|||
How do I stop the expression Enter Parameter Value?
The parameter keeps popping up because it needs to be removed from the
Parameters dialog box in the query. Even when you remove it from the query grid you have to remove it from the Parameters box as well. "Duane Hookom" wrote: It isn't clear what is causing the parameters and why. If they are coming from expression entered into the sorting and grouping then either delete them or suggest why you won't delete them. -- Duane Hookom MS Access MVP -- "Andy Dorph" wrote in message ... Removing the grouping is not an option for me. Is there some way I can programmatically override the request for the parameters? Thanks "Duane Hookom" wrote: The Sorting and Grouping dialog is opened by View-Sorting and Grouping. If you want to remove these, click the selector button to the left of the expression and press the delete key. -- Duane Hookom MS Access MVP "Andy Dorph" wrote in message ... Doing research on a similar problem. Not too clear on what is meant by the statement "Check the Sorting and Grouping dialog." What need to be done in the dialog? In my case, I have created 4 groups. for the sake of argument, let's call them grp1, grp2, grp3, grp4. They are not based on any data elements in the tables. When I run the report, I receive the enter parameter input box for each of these. How do I turn these off? "Duane Hookom" wrote: Check the Sorting and Grouping dialog. -- Duane Hookom MS Access MVP -- "Eric Rodriguez" Eric wrote in message ... I have a report that used to draw from Query A. One of the fields in the report, "Nominator," got its information from Query A. I've removed that field and changed the underlying query to Query B. But, when I try to open the report, a pop-up comes up that says "Enter Parameter Value" and says "Nominator." The thing is, the report is now drawing upon Query B, there is no "Nominator" field in Query B and there is no "Nominator" field in the report. Can somebody help? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to stop repeated 'Enter Network Password' dialogue messages? | Blue Plasma | General Discussion | 1 | February 14th, 2005 09:40 PM |
Select Query Parameter Repeating | Neutron1871 | Running & Setting Up Queries | 1 | October 8th, 2004 08:07 AM |
Enter Parameter Value | Kieran | Setting Up & Running Reports | 1 | July 12th, 2004 05:13 PM |