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
|
|||
|
|||
parameter query
I have one parameter query source on one of my listbox that requires to enter
the beginning and ending date... Everytime i switched the form to its design view and go back to form view the parameter query in that list is running requiring me to enter the beginning and ending dates before i could enter to form view.. How can i resolve this problem..? Pls help me.. tnx... -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
parameter query
IMHO the solution is to never use parameter prompt queries. Always use values
from controls on forms. -- Duane Hookom Microsoft Access MVP "hugz via AccessMonster.com" wrote: I have one parameter query source on one of my listbox that requires to enter the beginning and ending date... Everytime i switched the form to its design view and go back to form view the parameter query in that list is running requiring me to enter the beginning and ending dates before i could enter to form view.. How can i resolve this problem..? Pls help me.. tnx... -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
parameter query
I have often seen that we should switch to controls on forms but I was under
the impression that if the report is based on a query than it can't be done this way. I've tried several items and have had no luck, is there a way to do it if you're using a query to aggregate your data? "Duane Hookom" wrote: IMHO the solution is to never use parameter prompt queries. Always use values from controls on forms. -- Duane Hookom Microsoft Access MVP "hugz via AccessMonster.com" wrote: I have one parameter query source on one of my listbox that requires to enter the beginning and ending date... Everytime i switched the form to its design view and go back to form view the parameter query in that list is running requiring me to enter the beginning and ending dates before i could enter to form view.. How can i resolve this problem..? Pls help me.. tnx... -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
parameter query
You should always be able to replace a parameter prompt with a reference to a
control value of an open form. If this doesn't work for you, come back with more information. -- Duane Hookom Microsoft Access MVP "Joey" wrote: I have often seen that we should switch to controls on forms but I was under the impression that if the report is based on a query than it can't be done this way. I've tried several items and have had no luck, is there a way to do it if you're using a query to aggregate your data? "Duane Hookom" wrote: IMHO the solution is to never use parameter prompt queries. Always use values from controls on forms. -- Duane Hookom Microsoft Access MVP "hugz via AccessMonster.com" wrote: I have one parameter query source on one of my listbox that requires to enter the beginning and ending date... Everytime i switched the form to its design view and go back to form view the parameter query in that list is running requiring me to enter the beginning and ending dates before i could enter to form view.. How can i resolve this problem..? Pls help me.. tnx... -- Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
parameter query
Thanks, I thought it would be more appropriate to begin my own thread, since
hugz problem is not he quite the same as mine. Can you please see the post called "Date Range for a report" that I just posted. Thanks "Duane Hookom" wrote: You should always be able to replace a parameter prompt with a reference to a control value of an open form. If this doesn't work for you, come back with more information. -- Duane Hookom Microsoft Access MVP "Joey" wrote: I have often seen that we should switch to controls on forms but I was under the impression that if the report is based on a query than it can't be done this way. I've tried several items and have had no luck, is there a way to do it if you're using a query to aggregate your data? "Duane Hookom" wrote: IMHO the solution is to never use parameter prompt queries. Always use values from controls on forms. -- Duane Hookom Microsoft Access MVP "hugz via AccessMonster.com" wrote: I have one parameter query source on one of my listbox that requires to enter the beginning and ending date... Everytime i switched the form to its design view and go back to form view the parameter query in that list is running requiring me to enter the beginning and ending dates before i could enter to form view.. How can i resolve this problem..? Pls help me.. tnx... -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|