A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

parameter query



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2007, 08:12 AM posted to microsoft.public.access.reports
hugz via AccessMonster.com
external usenet poster
 
Posts: 16
Default 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  
Old June 4th, 2007, 04:53 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old July 26th, 2007, 07:36 PM posted to microsoft.public.access.reports
Joey
external usenet poster
 
Posts: 150
Default 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  
Old July 26th, 2007, 08:56 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old July 26th, 2007, 09:06 PM posted to microsoft.public.access.reports
Joey
external usenet poster
 
Posts: 150
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.