I can add buttons to filter by on the report view but that just seems cluttered.
Jim Wagner
On Saturday, March 21, 2015 10:30 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
No can do.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Mar 21, 2015, at 5:55 PM, Joseph luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
We were hoping to allow the users the ability to not go back and forth
From: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]
Sent: 3/21/2015 8:37 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Report view Filter
Jim,
Do you really need to place the combo box on the report or can you get by with a combo box on a form and then opening and closing filtered reports?
Duane Hookom, MVP
MS Access
________________________________
> Date: Sat, 21 Mar 2015 08:26:43 -0700
> Subject: RE: [MS_AccessPros] Report view Filter
>
>
>
> The combo box has a list of recruiters, that the report has a group on.
> I have been playing with other reports at home with other data because
> the db is at work.
> ________________________________
> From: John Viescas JohnV@msn.com
>
> Jim-
>
> Well, I played around with this in both Access 2007 and 2010. You can
> add a combo box to a report, but it will display as just a text box in
> Report View. It will display as a combo in Print Preview, but you
> can't select a value in it.
>
> ApplyFilter is tough to use because you can't really reference a
> control with a value.
>
> What is in the combo box Row Source, and how would you like to use that
> value as a filter?
>
> John Viescas, Author
>
> On Mar 21, 2015, at 4:04 AM,
> luvmymelody@yahoo.commailto:luvmymelody@yahoo.com>
>
> So we have a report that we would like to put a combo box on the report
> and allow the users to choose from the drop down box to filter the
> report. We have added the combo box. But now we need to figure out how
> to get the combo box to use a macro to filter the report. We tried the
> apply filter and set filter in the macro action catalog and it does not
> work. Is there a way of getting a macro to filter a report from the
> combo box?
>
>
> Thank You
> Jim Wagner
Do you really need to place the combo box on the report or can you get by with a combo box on a form and then opening and closing filtered reports?
Duane Hookom, MVP
MS Access
________________________________
> Date: Sat, 21 Mar 2015 08:26:43 -0700
> Subject: RE: [MS_AccessPros] Report view Filter
>
>
>
> The combo box has a list of recruiters, that the report has a group on.
> I have been playing with other reports at home with other data because
> the db is at work.
> ________________________________
> From: John Viescas JohnV@msn.com
>
> Jim-
>
> Well, I played around with this in both Access 2007 and 2010. You can
> add a combo box to a report, but it will display as just a text box in
> Report View. It will display as a combo in Print Preview, but you
> can't select a value in it.
>
> ApplyFilter is tough to use because you can't really reference a
> control with a value.
>
> What is in the combo box Row Source, and how would you like to use that
> value as a filter?
>
> John Viescas, Author
>
> On Mar 21, 2015, at 4:04 AM,
> luvmymelody@yahoo.commailto:luvmymelody@yahoo.com>
>
> So we have a report that we would like to put a combo box on the report
> and allow the users to choose from the drop down box to filter the
> report. We have added the combo box. But now we need to figure out how
> to get the combo box to use a macro to filter the report. We tried the
> apply filter and set filter in the macro action catalog and it does not
> work. Is there a way of getting a macro to filter a report from the
> combo box?
>
>
> Thank You
> Jim Wagner
__._,_.___
Posted by: Jim Wagner <luvmymelody@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar