Reports without query..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I know we can set some criteria in the query and then we can create a report
based on that query. But can we do:

I have a form with some dropdown fields, check boxes, combo boxes..can we
create a report....just by making selections for these fields on that form
and create a report (with no query involved) based on the selections I make
for these controls (dropdowns, check boxes, combo boxes)?

I really need your help. I would appreciate your help.

Thanks
 
Yes, you can definately do this, however you probably need to know some VBA
programming in order to do so.

All reports are actually based off of queries but what you are looking for
requires you to dynamically build the query based on the values that were
entered/selected on your form.

For instance, the user makes his/her selections from the combo boxes, check
boxes, etc on the form and clicks a 'Report' button. The code behind the
button will create a query based on the users' selections and then open the
report, which will always reference that queryname. This way, the queryname
will always be the same but the actual SQL that makes up the query will be
different each time depending on what the user selects.

As I mentioned, this requires some VBA programming skills which, once
learned or utilized, can greatly enhance the power that Access can give you.

Thanks,
Larry
 
Hi,

I know we can set some criteria in the query and then we can create a report
based on that query. But can we do:

I have a form with some dropdown fields, check boxes, combo boxes..can we
create a report....just by making selections for these fields on that form
and create a report (with no query involved) based on the selections I make
for these controls (dropdowns, check boxes, combo boxes)?

I really need your help. I would appreciate your help.
Click to expand...

YOu still need a query - but what you need is a *PARAMETER* query.

Create a Query that contains the data you want to see on the report,
based on a table containing the data.

On the Criteria under the search fields, put

=Forms![NameOfYourForm]![NameOfTheControl]

to filter the table to the values which match the selected controls.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Larry,

I know basic VB coding. Could you please give me some example how I should
be writting the query behind the button? I would appreciate yor help.

Earlier I was creating a query but when I preview my report it displays the
dialog window where it asks the user to enter the criteria for each field.
And I have more
than 10 check boxes in the form so it asks me 10 times (it displays dialog
box for 10 different check boxes plus other fileds I have with teh criteria
on it) to enter the criteria I am looking for... How can I avoid this step
like entering critera more than 10 times to get the report? How can I make it
easy on the user to create reports based on the selection he makes on the
form with no dialog box


Please let me know..Thanks
 
I know basic VB coding. Could you please give me some example how I should
be writting the query behind the button? I would appreciate yor help.

Earlier I was creating a query but when I preview my report it displays the
dialog window where it asks the user to enter the criteria for each field.
And I have more
than 10 check boxes in the form so it asks me 10 times (it displays dialog
box for 10 different check boxes plus other fileds I have with teh criteria
on it) to enter the criteria I am looking for... How can I avoid this step
like entering critera more than 10 times to get the report? How can I make it
easy on the user to create reports based on the selection he makes on the
form with no dialog box


Please let me know..Thanks
 
Back
Top