Re: Simple multi-layered form

Tech-Archive recommends: Fix windows errors by optimizing your registry

It couldn't be any easier. The subreport controls have Link Master and Link
Child properties where you enter the field names that identify the "key".

--
Duane Hookom
MS Access MVP

<seth.northrop@xxxxxxxxx> wrote in message
news:1161705672.202373.265660@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
And is passing variables betwwn the report and subreport fairly
straight forward? Ie, I'll have to pass the key from each row of the
original query to each instance of the sub report.

Marshall Barton wrote:
seth.northrop@xxxxxxxxx wrote:
I am a former DB guy who's hand has been forced into using Access for a
project. I am now coming to you for direction.

I have what I suspect is a simple problem - I just don't have any
experience in MS Access GUI development to know how to address is.

Given multiple relational tables, I want to create a series of reports.
The main one would be a query such as

SELECT bar, bar2 from foo.

I would then get a series of rows which I would display. Under each
row, I would want to run a series of queries on the relation tables.
For example, SELECT * from baz where bar = "bar," SELECT * from baz2
where bar = "bar," etc.

Each of these sub queries would display some portion of their data with
a link to open up a new report that would merely contain all of the
data from baz, or baz2, etc (ie, you would click to get all of the
otherwise summarized information).

So, basically something might look like:

FOO ROW 1 DATA

HEADING
BAZ DATA

HEADING
BAZ2 DATA

FOO ROW 2 DATA

.........

Can anyone recommend any resources to someone with some programming
background (I would have normally done this in something like PHP and
MySQL) that is completely new to the MS Access world on dealing with
what I suspect is a fairly simple loop progression through a query
combined with some variable passing back and forth?


This kind of thing is done either by Joining the table is
the report's record source query and using Sorting and
Grouping (View menu in report design) to segregate the data.

If your data is more complex than your example indicates,
then use a separate subreport for each dependent table's
data.

--
Marsh
MVP [MS Access]



.

Relevant Pages

  • Re: how to build a report to show multiple queries?
    ... Separate reports, embedded in Subreport Controls on a "master" report may ... be able to join them in the Query and not have the problem you describe. ... > I need to take the data from several queries, and have them all show their ...
    (microsoft.public.access.reports)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)