How to get a query to call the parameter form
in [Queries]
|
Prev: pivot table calculations
Next: runtime access
From: WillyNPG on 7 Mar 2010 16:15 I am trying to use a form to get query parameter dates as is detailed in the help article "Make a query ask for input" The query does not open the date range form when the query is used If the form is opened in advance and dates entered then the dates in the form are used what is missing? How is the open form macro called ?
From: Marshall Barton on 7 Mar 2010 16:46 WillyNPG wrote: >I am trying to use a form to get query parameter dates as is detailed in the >help article "Make a query ask for input" The query does not open the date >range form when the query is used If the form is opened in advance and dates >entered then the dates in the form are used what is missing? How is the open >form macro called ? Well, there is probably some convoluted way to get a query to open a form, but you can not guarantee that the form would be opened and the values entered before the query tried to use the values. Instead you need to use some code to open the form before the query runs. For example, if you want to use the query as the record source for a report: DoCmd.OpenForm "your form", WindowMode:=acDialog DoCmd.OpenReport "your report", acviewPreview -- Marsh MVP [MS Access]
From: John W. Vinson on 7 Mar 2010 16:57 On Sun, 7 Mar 2010 13:15:01 -0800, WillyNPG <WillyNPG(a)discussions.microsoft.com> wrote: >I am trying to use a form to get query parameter dates as is detailed in the >help article "Make a query ask for input" The query does not open the date >range form when the query is used If the form is opened in advance and dates >entered then the dates in the form are used what is missing? How is the open >form macro called ? You've got it backward. Queries don't have events that would let you open a form; it's vice versa. Open the form first, and open the query (or, much better, the report or form based on the query) from some event on the form - a command button or the AfterUpdate event of some appropriate control on the form. -- John W. Vinson [MVP]
From: KenSheridan via AccessMonster.com on 7 Mar 2010 19:49 My recent response in the following thread includes a description of one way (there are others) to get a report to open a dialogue form for entering parameters for the report's underlying query: http://www.accessmonster.com/Uwe/Forum.aspx/access-reports/41078/subreport-repeating-parameters Something similar could be done with a form based on the query. While people sometimes prefer to do it this way, the only situation in which I can see it has any advantage is if the same dialogue form is used for multiple reports or forms, in which case a small variation to the code involves passing the report name to the form as its OpenArgs property. If the dialogue simply feeds one report or form just opening the dialogue form first and then opening the report or bound form (or even a query in datasheet view, though that's a rather crude approach in a developed application) from it has always seemed to me to be a perfectly adequate way of going about it. Ken Sheridan Stafford, England WillyNPG wrote: >I am trying to use a form to get query parameter dates as is detailed in the >help article "Make a query ask for input" The query does not open the date >range form when the query is used If the form is opened in advance and dates >entered then the dates in the form are used what is missing? How is the open >form macro called ? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1
From: Steve Schapel on 7 Mar 2010 19:52
Willy, As I stated in the other group where you posted this... The behaviour you have described is expected. The form will not, and can not be made to, open when the query is run. If the query uses criteria based on the values of controls on a form, then the form has to be open in advance. As for the macros, it sounds like you are using Access 2007 and they are embedded macros. That is fine... but they won't appear in the Navigation Pane. -- Steve Schapel, Microsoft Access MVP "WillyNPG" <WillyNPG(a)discussions.microsoft.com> wrote in message news:01FCBD7F-74A7-4ACC-8072-2A995EFE7790(a)microsoft.com... > I am trying to use a form to get query parameter dates as is detailed in > the > help article "Make a query ask for input" The query does not open the date > range form when the query is used If the form is opened in advance and > dates > entered then the dates in the form are used what is missing? How is the > open > form macro called ? |