Re: Report Filters

The sample from the fontstuff website I believe was authored by Martin
Green. His stuff is very good.

The applet that I suggested is a good method for allowing users with very
little knowledge of the tables and relationships to create and run queries.
It is not designed to be used as the record source of a published report. I
generally include this applet in most applications that I create. It doesn't
take long to train users on how to use this and most like to push the
records to Excel where they can supply their own formatting.

--
Duane Hookom
MS Access MVP
--

"Marguerite Hall" <MargueriteHall@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:BA844A9B-A18B-4532-8986-275D1659CBCC@xxxxxxxxxxxxxxxx
>A belated thanks to DuncanG for his sample Q&A database. It wasn't quite
> what I had in mind, however. The functionality I want is so basic, simple
> and straight forward that I can't believe that it's not "built" into
> Access.
> In Lotus Approach, I could just chose a report design option that limited
> the
> records appearing in a report to the most recently selected subset of the
> table. Do I truly need to use an applet (re: the Duane Hook message) or
> to
> come up with some complicated macro employee an advanced filter???? At
> the
> moment I'm filtering by form, cutting and pasting the ad hoc forms filter
> properties into the record filter properties. Truly UGLY! Again, am I
> missing something I should have picked up in Access 101?
>
> "DuncanG" wrote:
>
>> Try the following url :http://www.fontstuff.com/access/acctut19.htm
>>
>> "Brook" wrote:
>>
>> > I am setting up a expense account database and want to create several
>> > reports
>> > that are based on my Expense Table (I.E. Reconciled, Recimbursed, By
>> > Date,
>> > etc), but I don't want to have to create separate reports/queries for
>> > each
>> > report I want.
>> >
>> > Is there a way that I can set up a Pop Up Form that I can use to filter
>> > my
>> > report based on my table and or query?
>> >
>> > thanks,
>> > Brook


.

Relevant Pages

  • Report Filters
    ... I am setting up a expense account database and want to create several reports ... Is there a way that I can set up a Pop Up Form that I can use to filter my ... report based on my table and or query? ...
    (microsoft.public.access.reports)
  • Re: Filter for Report not working?????
    ... Do I need to release the filter or close the TableFame? ... contFilter DynArrayString ... Your first example based on ContractNo ... I decided to go with a table in PRIV for the report. ...
    (comp.databases.paradox)
  • Re: Show all records through combo box
    ... I should not have used the term report to describe what it is I ... was refering to is a MCReport. ... the subforms to the main form using the Company_ID and the MCReport_ID. ... There is no code in the filter section. ...
    (microsoft.public.access.forms)
  • Re: Show all records through combo box
    ... provided by an assortment of suppliers. ... If this basic model sounds like it would work, the report can be devised. ... the filter remains disabled. ... all of the other subforms change according to the MCReport selected ...
    (microsoft.public.access.forms)
  • Re: Filter for Report not working?????
    ... then when the form opens the proper records are NOW displayed for data ... Do I need to release the filter or close the TableFame? ... contFilter DynArrayString ... I decided to go with a table in PRIV for the report. ...
    (comp.databases.paradox)