Using parameters with queries and reports

[Guest]

Using parameters with queries and reports

I'm using a form to supply data to a parameter query. When I run the
report, it opens the form, I enter the data to pass to the query, click "ok"
it hides the form, runs the query and displays the resut in a datasheet query
view instead of the report. The report is never displayed.

 

[Rick Brandt]

Using parameters with queries and reports

I'm using a form to supply data to a parameter query. When I run the
report, it opens the form, I enter the data to pass to the query, click "ok"
it hides the form, runs the query and displays the resut in a datasheet query
view instead of the report. The report is never displayed.

If the report is bound to the query then there is no need to "run" the query.
Just remove that line of code and replace it with a line that opens the report.
Normally you would open such a form first and have it open the report rather
than having the report open the form. At that point it might be too late for
the report to make use of the parameter.

 

[fredg]

Using parameters with queries and reports

I'm using a form to supply data to a parameter query. When I run the
report, it opens the form, I enter the data to pass to the query, click "ok"
it hides the form, runs the query and displays the resut in a datasheet query
view instead of the report. The report is never displayed.

The query is the record source for the report?
Here is an example that uses a Start date and End date as parameters
for the report record source (the query).

Create an unbound form.

Add 2 unbound text controls.
Set their format to a valid date format.
Name them "StartDate" and "EndDate"

Add a Command Button to the form.
Code the button's click event:

Me.Visible = False

Name this form 'ParamForm'.

As criteria in the query date field write:
Between forms!Paramform!StartDate and forms!ParamForm!EndDate

Next, code the report's Open event:
DoCmd.OpenForm "ParamForm", , , , , acDialog

Code the report's Close event:
DoCmd.Close acForm, "ParamForm"

When ready to run the report, open the report.
The form will open and wait for the selection of the Company and the
entry of the starting and ending dates wanted.
Click the command button and then report will run.
When the report closes, it will close the form.
You never 'see' the query.

 

[Guest]

I am creating a form to supply parameters to a report, so I enter code in the
report's OPEN & CLOSE events. I created a form (Sales by Category Dialog) and
a query (Source Query for Sales By Category Report).
the VBA code in the CLOSE & OPEN looks like this:

Private Sub Report_Close()
DoCmd.Close acForm, "Sales By Category Dialog"
End Sub

Private Sub Report_Open(Cancel As Integer)
' Set public variable to true to indicate that the report
' is in the Open event
bInReportOpenEvent = True

' Open Sales By Category Dialog
DoCmd.OpenForm "Sales By Category Dialog", , , , , acDialog

' Cancel Report if User Clicked the Cancel Button
If IsLoaded("Sales By Category Dialog") = False Then Cancel = True

' Set public variable to false to indicate that the
' Open event is completed
bInReportOpenEvent = False
End Sub

Computer says : compile error: sub or function not defined, ("IsLoaded"
marked yellow), any idea why?