How to disable query parameters when opening MS Access report?

  • Thread starter Thread starter myayalar
  • Start date Start date
M

myayalar

<<<Need expert advise>>>
Have created a report based on a query that has parameters set. I would
like to disable them (from the report), so that the users are not
receiving the prompt, when they open the report.
 
By definition, parameters are values that must be supplied at runtime. If
you do not want your users to supply values at runtime, remove the
parameters from the query.

There are alternative ways to sometimes limit the report: the WhereCondition
of OpenReport is probably the most common. For an example, see Method 2 in
this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query In Report Title 3
Rerun query 2
Custom Parameter Dialogs for Reports 2
parameters using docmd.openreport 7
how to publish access parameter based query report 5
Access 2000 reducing query parameter prompts in reports 1
Automatically Enter Parameter Value 2
pass query parameter value to report 8

Back
Top