Simple multi-layered form

  • Thread starter Thread starter seth.northrop
  • Start date Start date
S

seth.northrop

Greetings.

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?

Thanks!
 
I'm not sure I understand the situation, but have you looked at report
Sorting and Grouping?
 
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?
Click to expand...


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.
 
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.
 
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

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.
Click to expand...
 
Back
Top