Apply Filter to A Report

[Nhmiller]

I already have a report designed under Reports. When I use filtering in Forms
or Tables, I see no way to select that filtered list when I am in Reports, and
there appears to be no way to do the filtering when I am in Reports.

I have received two replies to this message, posted a few days ago within
another Subject. One requires making programming type statements. That should
not be necessary -- Access must have a quick way to just click on something to
apply the filter to my already formatted report layout. The other reply said to
base the report on a query -- it appears to me I can only do that if I then
create a new report.

Thanks to anyone who can give me the simple instructions that must be in
Access, but sure are not in the Help menus.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

[fredg]

On 11 Nov 2004 19:52:27 GMT, Nhmiller wrote:

I already have a report designed under Reports. When I use filtering in Forms
or Tables, I see no way to select that filtered list when I am in Reports, and
there appears to be no way to do the filtering when I am in Reports.

I have received two replies to this message, posted a few days ago within
another Subject. One requires making programming type statements. That should
not be necessary -- Access must have a quick way to just click on something to
apply the filter to my already formatted report layout. The other reply said to
base the report on a query -- it appears to me I can only do that if I then
create a new report.

Thanks to anyone who can give me the simple instructions that must be in
Access, but sure are not in the Help menus.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

Are you using a form, and filtering the records using the "Filter by
Selection" or "Filter by Form" tool buttons?

If so, Add a command button to the form.
Code it's Click event:
DoCmd.OpenRepor t "ReportName ", acViewPreview , , Me.Filter

Filter the records on the form, then click the button.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Nhmiller]

>Are you using a form, and filtering the records using the "Filter by

Selection" or "Filter by Form" tool buttons?
Yes, Filter By Selection

If so, Add a command button to the form.
Code it's Click event:
DoCmd.OpenRepo rt "ReportName ", acViewPreview , , Me.Filter
My report is called Roster. Do I just substitute "Roster" for "ReportName "? I
tried that and nothing happened after I continued as below:

Filter the records on the form, then click the button.

Do you know what I did wrong? Also, how would anyone know to use a statement
like that? I'm surprised Microsoft does not have an easy way to accomplish this
task.

Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

[Nhmiller]

>Are you using a form, and filtering the records using the "Filter by

Selection" or "Filter by Form" tool buttons?
Yes, Filter By Selection

If so, Add a command button to the form.
Code it's Click event:
DoCmd.OpenRepo rt "ReportName ", acViewPreview , , Me.Filter
My report is called Roster. Do I just substitute "Roster" for "ReportName "? I
tried putting the statement in the Event Tab but the characters wouldn't
appear.

Filter the records on the form, then click the button.

Do you know what I did wrong? Also, how would anyone know to use a statement
like that? I'm surprised Microsoft does not have an easy way to accomplish this
task. Perhaps if you could instruct me on this with me using the Wizard button
in conjunction with placing the Command button in my form, that might be
easier.

Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

[fredg]

On 11 Nov 2004 21:41:35 GMT, Nhmiller wrote:

Are you using a form, and filtering the records using the "Filter by
Selection" or "Filter by Form" tool buttons?

Yes, Filter By Selection

If so, Add a command button to the form.
Code it's Click event:
DoCmd.OpenRep ort "ReportName ", acViewPreview , , Me.Filter

My report is called Roster. Do I just substitute "Roster" for "ReportName "? I
tried putting the statement in the Event Tab but the characters wouldn't
appear.

Filter the records on the form, then click the button.

** snipped **

When you have added the command button to the form, display it's
property sheet.
Click on the Event tab.
On the Click line write:
[Event Procedure]
Then click on the button with 3 dots that appears on that line.
When the code window opens, the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines, write:

DoCmd.OpenRepor t "Roster", acViewPreview , , Me.Filter

Exit the code window and save the changes.
Open the Form. Filter the records using one of the filter tool
buttons. Click the command button.
The Roster report will open, with just the filtered records.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Nhmiller]

>** snipped **

When you have added the command button to the form, display it's
property sheet.
Click on the Event tab.
On the Click line write:
[Event Procedure]
Then click on the button with 3 dots that appears on that line.
When the code window opens, the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines, write:

DoCmd.OpenRepo rt "Roster", acViewPreview , , Me.Filter

Exit the code window and save the changes.
Open the Form. Filter the records using one of the filter tool
buttons. Click the command button.
The Roster report will open, with just the filtered records.

Thank you. That worked. I gather there are several ways of accomplishing this
same task. An earlier reply on another Subject said to do it through a query.
What I am concerned about is how does a user, who expects Windows software to
be user friendly, know how to create code like yours? For comparison, the 1994
version of Lotus Approach requires nothing like this -- all tasks are done from
commands in dropdown menus, and apply universally to all views of a database.
Could you explain to me why Access is so code oriented? When I read the Help
topics, I have no clue what they are talking about or how to do what they are
saying. And I am a software engineer, though only as part of my work and on a
lower level.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

[Salad]

Nhmiller wrote:

** snipped **

When you have added the command button to the form, display it's
property sheet.
Click on the Event tab.
On the Click line write:
[Event Procedure]
Then click on the button with 3 dots that appears on that line.
When the code window opens, the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines, write:

DoCmd.OpenRep ort "Roster", acViewPreview , , Me.Filter

Exit the code window and save the changes.
Open the Form. Filter the records using one of the filter tool
buttons. Click the command button.
The Roster report will open, with just the filtered records.

Thank you. That worked. I gather there are several ways of accomplishing this
same task. An earlier reply on another Subject said to do it through a query.
What I am concerned about is how does a user, who expects Windows software to
be user friendly, know how to create code like yours? For comparison, the 1994
version of Lotus Approach requires nothing like this -- all tasks are done from
commands in dropdown menus, and apply universally to all views of a database.
Could you explain to me why Access is so code oriented?

Flexibility. Expandability.

Many tasks are repetitious. Many aren't.
When I read the Help topics, I have no clue what they are talking about or how to do what they are
saying. And I am a software engineer, though only as part of my work and on a
lower level.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

[Nhmiller]

>DoCmd.OpenRepo rt "Roster", acViewPreview , , Me.Filter

Would you be able to tell me where in Access (Help or otherwise) there is an
explanation of this command, and if there is a Help section with instructions
about writing code for the various needs you have run into? Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

[Sunil Korah]

nh******@aol.co mnojunk (Nhmiller) wrote in message news:<20******* *************** *****@mb-m25.aol.com>...

I already have a report designed under Reports. When I use filtering in Forms
or Tables, I see no way to select that filtered list when I am in Reports, and
there appears to be no way to do the filtering when I am in Reports.

I have received two replies to this message, posted a few days ago within
another Subject. One requires making programming type statements. That should
not be necessary -- Access must have a quick way to just click on something to
apply the filter to my already formatted report layout. The other reply said to
base the report on a query -- it appears to me I can only do that if I then
create a new report.

Thanks to anyone who can give me the simple instructions that must be in
Access, but sure are not in the Help menus.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

The other reply said to base the report on a query -- it appears to
me I can only do that if I then create a new report.

Not so. Create the query. Then change the 'Record Source' property of
the existing report to the name of the query.

HTH

Sunil Korah

[Nhmiller]

>Create the query. Then change the 'Record Source' property of

the existing report to the name of the query.

I created the query using the query wizard. I selected all the fields, then did
a filter by selection on one of the fields. When I go to the report tab and
right click on the report name, then click on properties, there is just a
general tab and a window to enter descriptive information. Where is Record
Source? Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com