Re: Report Criteria: Query works, but report doesn't call up query???
Date: Fri, 15 Oct 2004 17:31:32 -0600
On Fri, 15 Oct 2004 09:33:08 -0700, "BARKAROO"
>I'm trying to create a report where the the user can enter criteria
>(beginning date, end date) to generate a report.
>*I've created a form to enter the criteria. (with macros "ok", "cancel").
>*I've created the query to generate the report.
>The query itself works. The form opens and allows me to enter the criteria.
>However, they don't seem to work together. When I open the form, enter the
>criteria, and click "ok" (macro), it doesn't seem to know to run the query.
>Instead, it pulls all of the records from the record source. How can I get
>the criteria form to work with the actual query - and get it to show in the
>All advise is greatly appreciated.
You don't need to "run" the Query at all. Instead, change the Report's
Recordsource property to the name of the query. The macro behind your
button should simply open the Report - which will in turn call the
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
- Re: report based query
... I have a query and report based on that query which requires 2 parameters to ... Create an unbound form. ... When the New Form dialog opens select Design View. ...
- Re: UPDATE DATE FIELD IN QUERY
... In the Date Field of my Query I have entered the following into the Criteria ... I can open the query, and it does prompt start & end dates, but it opens the ... When I open the report it opens the same parameter window & not my form, ... End dates 6 times & it just kept bringing up the prompt. ...
- Re: Query data into report
... When this form is opened it has the two command buttons I mentioned earlier. ... When I select a name from the combobox the form main1 closes and the query is ... With this datasheet open I then open the report called ... When this report opens it has the parameter entry box ...
- Re: Combox box query tries to run again
... When the report opens it will run the query used as its RecordSource. ... If the user chooses to Cancel, the code in the Cancel button's Click event ...
- Re: Calculating time worked without having an EndTime field
... The DMincould use a query as its domain if necessary. ... The code could go in the Open event of the report if users open the report directly from the Database Window/NavPane. ... If you provide an interface with a command button that opens the report, you could use the Click event of the command button. ... I've included below the subquery I used to get the ...