Re: Report Filters

Thanks Duane for publishing your tool. Although I need something where my
users can create queries and somewhat formatted reports on the fly without
going through the DB window, your tool will be a handy study item. I need to
audit activity in the DB, so i am trying to keep everyone working through
forms.
--
MCP, MCSA, MCT, A+, Network+, Master MOS - Office XP


"Duane Hookom" wrote:

> 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

  • RE: Report/subreports working on-screen but not printing
    ... Thanks for your help Duane - you must be bored today! ... this information is in the report "GMA header"; ... All other tables, queries and subreports are ...
    (microsoft.public.access.reports)
  • Re: Set up a report using more than one query
    ... I selected code builder and it took me to the code and placed ... Docmd.Maximize and closed the window. ... Thanks again Duane for your guidance. ... I, also, have something further to report on the other problem I was having ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Horizontally expand child crosstab queries in a report
    ... Thanks Duane and yes, I did check that sample out. ... be able to do - expand a child object on a report when the underlying data ... > report that "wraps" extra columns. ... >> the days of the month accross the top of the queries. ...
    (microsoft.public.access.reports)
  • Re: Difference in amounts
    ... Databases that deal with words are not nearly as exciting as databases with ... Duane Hookom ... >> The total for Invoice Only could use an expression in a report footer of: ... >> To get the sum of InvoiceAmount for Expenditures and Personal Expenses ...
    (microsoft.public.access.queries)
  • Re: Dynamic report
    ... footer and for each item in the category in the footer, ... "Duane Hookom" wrote: ... Then add these subreports to the Report Footer ... >> at the end that totals the different CallTypes by group and Declarations ...
    (microsoft.public.access.reports)