Need Help With Groups and Stored Drawings

[ChadDiesel]

Hello everyone,

I'm having a problem with Access that I need some help with. The short
version is, I want to print a list of parts and part quantities that belong
to a certain part group---One list per page. I created a report that groups
the parts by part classification group with a force new page after each
group. The report is based on a query of that week's orders. Some of these
parts have drawings (usually 2 each stored in an OLE link field) that need
to be included in the report. I want to print the needed drawings on
separate pages after each group of parts. I'm confused (about many things)
on how to set something like this up-especially printing multiple pages
after a group. I'm used to having a corresponding field for each record.
There might be 10 parts in the group, but only 2 might need drawings-maybe
none. I don't want to have a bunch of blank pages after each group. I'm
not having any luck printing out the drawings. I posted a more detailed
explanation below. Is it possible to do something like this, or would I
have to do separate reports for each group? I would really appreciate some
help.

Thanks,

Chad
Long Version:
--------------------------------

I have a report that shows all the parts used in the previous week. It looks
something like this:

------------------------------------
Part Group AAA

Part Number QTY
------------ -----
Part 1 23
Part 2 35
Part 3 48
Part 4 16
------------------------------------

(****New Page*****)
Part Group BBB

Part Number QTY
------------ -----
Part 5 23
Part 6 35
Part 7 48
Part 8 16

-------------------------------------

As you can see, I have the parts grouped in the report by Part Group they
belong to. I have each group on a separate page with group page breaks.

I have a table that contains the part number, its part group classification,
and an OLE Field that contains a link to an Excel spreadsheet which contains
a drawing file. I want to link the part numbers that show up in the report
query to the needed drawing in the table.

Part Description Table
------------------------------------------
Part Number-----Part Group----Drawing

My situation is, I would like to include drawings for certain parts after
each group. What I want to do is print a page for each group followed by the
needed drawings-one on each page:
Page 1
------------------------------------
Part Group AAA

Part Number QTY
------------ -----
Part 1 23
Part 2 35
Part 3 48
Part 4 16
------------------------------------

Page 2
------------------------------------
Part 1 Drawing #1

Page 3
------------------------------------
Part 1 Drawing #2

Page 4
------------------------------------
Part 3 Drawing #1

Page 5
------------------------------------
Part 3 Drawing #2

Page 6
------------------------------------
Part Group BBB

Part Number QTY
------------ -----
Part 5 23
Part 6 35
Part 7 48
Part 8 16.
..
..
..
and so on...

[Johnny Meredith]

..
..
I'm used to having a corresponding field for each record.
There might be 10 parts in the group, but only 2 might need
drawings-maybe
none. I don't want to have a bunch of blank pages after each group.
..
..

How do you determine which part group needs a drawing and how many
drawings to assign to a part group? Is there one drawing per part,
several, or does one drawing serve several parts?

Johnny

[Tom van Stiphout]

On 1 Jun 2005 16:49:34 -0700, "Johnny Meredith" <jm*******@gmail.com>
wrote:

Get back to us after the cocaine wears off.
-Tom.

.
.
I'm used to having a corresponding field for each record.
There might be 10 parts in the group, but only 2 might need
drawings-maybe
none. I don't want to have a bunch of blank pages after each group.
.
.

How do you determine which part group needs a drawing and how many
drawings to assign to a part group? Is there one drawing per part,
several, or does one drawing serve several parts?

Johnny

[ChadDiesel]

Thanks for responding. I have a part description table which has a list of
all the parts. Two of the fields are OLE fields containing a links to the
drawings. There are usually 2 drawings per part. Some of these fields are
blank because those parts do not need drawings. The drawings are usually
unique to the part number. There is one drawing that covers more than one
part, but that is very rare and I can print out an extra copy of the
drawing. That's not a big deal. As for how to determine what groups needs
what drawings, I guess it is the part number in the group since that is how
I have them in my table. Figuring out how to associate these parts with
drawings and print only the needed drawings after the group is what is
confusing me.

Chad

"Johnny Meredith" <jm*******@gmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

.
.
I'm used to having a corresponding field for each record.
There might be 10 parts in the group, but only 2 might need
drawings-maybe
none. I don't want to have a bunch of blank pages after each group.
.
.

How do you determine which part group needs a drawing and how many
drawings to assign to a part group? Is there one drawing per part,
several, or does one drawing serve several parts?

Johnny

[Salad]

ChadDiesel wrote:

Thanks for responding. I have a part description table which has a list of
all the parts. Two of the fields are OLE fields containing a links to the
drawings. There are usually 2 drawings per part. Some of these fields are
blank because those parts do not need drawings. The drawings are usually
unique to the part number. There is one drawing that covers more than one
part, but that is very rare and I can print out an extra copy of the
drawing. That's not a big deal. As for how to determine what groups needs
what drawings, I guess it is the part number in the group since that is how
I have them in my table. Figuring out how to associate these parts with
drawings and print only the needed drawings after the group is what is
confusing me.

Chad

"Johnny Meredith" <jm*******@gmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

.
.
I'm used to having a corresponding field for each record.
There might be 10 parts in the group, but only 2 might need
drawings-maybe
none. I don't want to have a bunch of blank pages after each group.
.
.

How do you determine which part group needs a drawing and how many
drawings to assign to a part group? Is there one drawing per part,
several, or does one drawing serve several parts?

Johnny

You have a grouping called PartGroup. I might contemplate something
like this....

First, create a GroupFooter for PartGroup.

Next, create another report that will display the pictures. You would
sort by PartGroup, PartNo by selecting Sorting/Grouping from the menu
bar under the View option.

Now open up your first report. From the toolbox, select the SubReport
icon and drop that into the GroupFooter for PartGroup. Set the proper
links between the main/sub report (the link would be PartGroup).

You may have to futz with the page breaks. Dbl-click on the GroupFooter
band to pull up the property sheet. Under the Format tab there is a
ForceNewPage setting. Set as necessary.

[ChadDiesel]

Hello,

Thanks for responding. I tried what you said and got the report/subreport
link set up, but I can't for the life of me figure out how to do the page
breaks on the subreport. I put the subreport after a page break in the
group footer, and I get the list of parts and the drawing/blank space for
the first part of the list on the next page. The subreport page break
doesn't work--I mean I'm sure it works, but I obviously am not doing it
right. Thanks for pointing me in the right direction. Your help is
appreciated.

Thanks,

Chad
"Salad" <oi*@vinegar.com> wrote in message
news:GH*****************@newsread1.news.pas.earthl ink.net...

ChadDiesel wrote:

Thanks for responding. I have a part description table which has a list
of all the parts. Two of the fields are OLE fields containing a links to
the drawings. There are usually 2 drawings per part. Some of these
fields are blank because those parts do not need drawings. The drawings
are usually unique to the part number. There is one drawing that covers
more than one part, but that is very rare and I can print out an extra
copy of the drawing. That's not a big deal. As for how to determine
what groups needs what drawings, I guess it is the part number in the
group since that is how I have them in my table. Figuring out how to
associate these parts with drawings and print only the needed drawings
after the group is what is confusing me.

Chad

"Johnny Meredith" <jm*******@gmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

.
.
I'm used to having a corresponding field for each record.
There might be 10 parts in the group, but only 2 might need
drawings-maybe
none. I don't want to have a bunch of blank pages after each group.
.
.

How do you determine which part group needs a drawing and how many
drawings to assign to a part group? Is there one drawing per part,
several, or does one drawing serve several parts?

Johnny

You have a grouping called PartGroup. I might contemplate something like
this....

First, create a GroupFooter for PartGroup.

Next, create another report that will display the pictures. You would
sort by PartGroup, PartNo by selecting Sorting/Grouping from the menu bar
under the View option.

Now open up your first report. From the toolbox, select the SubReport
icon and drop that into the GroupFooter for PartGroup. Set the proper
links between the main/sub report (the link would be PartGroup).

You may have to futz with the page breaks. Dbl-click on the GroupFooter
band to pull up the property sheet. Under the Format tab there is a
ForceNewPage setting. Set as necessary.

[Salad]

ChadDiesel wrote:

Hello,

Thanks for responding. I tried what you said and got the report/subreport
link set up, but I can't for the life of me figure out how to do the page
breaks on the subreport. I put the subreport after a page break in the
group footer, and I get the list of parts and the drawing/blank space for
the first part of the list on the next page. The subreport page break
doesn't work--I mean I'm sure it works, but I obviously am not doing it
right. Thanks for pointing me in the right direction. Your help is
appreciated.

Thanks,

Chad
"Salad" <oi*@vinegar.com> wrote in message
news:GH*****************@newsread1.news.pas.earthl ink.net...

ChadDiesel wrote:

Thanks for responding. I have a part description table which has a list
of all the parts. Two of the fields are OLE fields containing a links to
the drawings. There are usually 2 drawings per part. Some of these
fields are blank because those parts do not need drawings. The drawings
are usually unique to the part number. There is one drawing that covers
more than one part, but that is very rare and I can print out an extra
copy of the drawing. That's not a big deal. As for how to determine
what groups needs what drawings, I guess it is the part number in the
group since that is how I have them in my table. Figuring out how to
associate these parts with drawings and print only the needed drawings
after the group is what is confusing me.

Chad

"Johnny Meredith" <jm*******@gmail.com> wrote in message
news:11*********************@g14g2000cwa.google groups.com...
.
.
I'm used to having a corresponding field for each record.
There might be 10 parts in the group, but only 2 might need
drawings-maybe
none. I don't want to have a bunch of blank pages after each group.
.
.

How do you determine which part group needs a drawing and how many
drawings to assign to a part group? Is there one drawing per part,
several, or does one drawing serve several parts?

Johnny

You have a grouping called PartGroup. I might contemplate something like
this....

First, create a GroupFooter for PartGroup.

Next, create another report that will display the pictures. You would
sort by PartGroup, PartNo by selecting Sorting/Grouping from the menu bar
under the View option.

Now open up your first report. From the toolbox, select the SubReport
icon and drop that into the GroupFooter for PartGroup. Set the proper
links between the main/sub report (the link would be PartGroup).

You may have to futz with the page breaks. Dbl-click on the GroupFooter
band to pull up the property sheet. Under the Format tab there is a
ForceNewPage setting. Set as necessary.

Bummer. I know I got you pointed in the right direction but I know that
there are some differences between a "report" and a "sub-report".

My next suggestion is to see if a similar problem has been answered
elsewhere. Go to http://groups.google.com. Click on advanced search.
In the Words To Search, enter something like "Subreport pagebreaks" and
in the groups textbox enter "*Access*" (remove quotes in my search
criteria) and then search. Maybe somebody from the past has a solution.

You may have to move things up if you find no answer. For example,
create a subreport to print the detail lines and put that in a header
group (don't know if that will work) and then put the pictures in the
detail line.

I know you need to futz with this. I'm sure it can be done. It might
require a lot of experimentation.

[ChadDiesel]

Moving up the reports worked great! I'm really close. My only problem now
is that I get a bunch of blank pages where part numbers do not have
pictures. I don't know how to filter out the blank pages. If I do, I don't
get all the part numbers-just the ones that have pictures. I guess this is
because the pictures are on the main report. I just can't get it to work the
other way. Thanks for the information. You have been a great deal of help.

Chad
"Salad" <oi*@vinegar.com> wrote in message
news:BC*****************@newsread2.news.pas.earthl ink.net...

ChadDiesel wrote:

Hello,

Thanks for responding. I tried what you said and got the
report/subreport link set up, but I can't for the life of me figure out
how to do the page breaks on the subreport. I put the subreport after a
page break in the group footer, and I get the list of parts and the
drawing/blank space for the first part of the list on the next page. The
subreport page break doesn't work--I mean I'm sure it works, but I
obviously am not doing it right. Thanks for pointing me in the right
direction. Your help is appreciated.

Thanks,

Chad
"Salad" <oi*@vinegar.com> wrote in message
news:GH*****************@newsread1.news.pas.earthl ink.net...

ChadDiesel wrote:
Thanks for responding. I have a part description table which has a list
of all the parts. Two of the fields are OLE fields containing a links
to the drawings. There are usually 2 drawings per part. Some of these
fields are blank because those parts do not need drawings. The drawings
are usually unique to the part number. There is one drawing that covers
more than one part, but that is very rare and I can print out an extra
copy of the drawing. That's not a big deal. As for how to determine
what groups needs what drawings, I guess it is the part number in the
group since that is how I have them in my table. Figuring out how to
associate these parts with drawings and print only the needed drawings
after the group is what is confusing me.

Chad

"Johnny Meredith" <jm*******@gmail.com> wrote in message
news:11*********************@g14g2000cwa.googl egroups.com...
>.
>.
>I'm used to having a corresponding field for each record.
>There might be 10 parts in the group, but only 2 might need
>drawings-maybe
>none. I don't want to have a bunch of blank pages after each group.
>.
>.
>
>How do you determine which part group needs a drawing and how many
>drawings to assign to a part group? Is there one drawing per part,
>several, or does one drawing serve several parts?
>
>Johnny
>

You have a grouping called PartGroup. I might contemplate something like
this....

First, create a GroupFooter for PartGroup.

Next, create another report that will display the pictures. You would
sort by PartGroup, PartNo by selecting Sorting/Grouping from the menu bar
under the View option.

Now open up your first report. From the toolbox, select the SubReport
icon and drop that into the GroupFooter for PartGroup. Set the proper
links between the main/sub report (the link would be PartGroup).

You may have to futz with the page breaks. Dbl-click on the GroupFooter
band to pull up the property sheet. Under the Format tab there is a
ForceNewPage setting. Set as necessary.

Bummer. I know I got you pointed in the right direction but I know that
there are some differences between a "report" and a "sub-report".

My next suggestion is to see if a similar problem has been answered
elsewhere. Go to http://groups.google.com. Click on advanced search. In
the Words To Search, enter something like "Subreport pagebreaks" and in
the groups textbox enter "*Access*" (remove quotes in my search criteria)
and then search. Maybe somebody from the past has a solution.

You may have to move things up if you find no answer. For example, create
a subreport to print the detail lines and put that in a header group
(don't know if that will work) and then put the pictures in the detail
line.

I know you need to futz with this. I'm sure it can be done. It might
require a lot of experimentation.